SpringBoot整合持久层技术

SpringBoot整合SpringMVC+Mybatis

1. 配置pom.xml文件
2. 添加application.properties 全局配置文件

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ssm
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#给包下的实体类取别名
mybatis.type-aliases-package=com.steer.pojo

3. 创建数据库与实体类
4. 编写mapper接口以及映射配置文件
5. 编写业务层
6. 编写控制类
7. 编写页面

1.在mapper接口上要添加@Component注解
2.在业务层实现类上添加@Service和@Transactional这两个注解
@Transactional将该公共类方法纳入事务管理
3.启动类上要添加别名扫描
@MapperScan("com.steer.mapper") //@MapperScan 用户扫描MyBatis的Mapper接口，这样在mapper.xml文件中，参数类型就不用写全地址(com.steer.pojo.users)了,直接写users就行了。

UsersMapper.java
@Component
public interface UsersMapper {
    // 新增用户信息
    void insUser(Users users);
    // 查询所有用户信息
    List<Users> selAllUser();
    // 根据id查询用户信息
    Users findUserById(Integer id);
    // 修改选中的用户信息
    void updUser(Users users);
    //删除用户信息
    void delUser(Integer id);
}

UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.steer.mapper.UsersMapper">
    <insert id="insUser" parameterType="users">
        insert into users(name, age) values (#{name}, #{age})
    </insert>
    <select id="selAllUser" resultType="users">
        select * from users
    </select>
    <select id="findUserById" parameterType="int" resultType="users">
        select * from users where id=#{id}
    </select>
    <update id="updUser" parameterType="users">
        update users set name=#{name}, age=#{age} where id=#{id}
    </update>
    <delete id="delUser" parameterType="int">
        delete from users where id=#{id}
    </delete>
</mapper>

UserServiceImpl.java
@Service
@Transactional
        public class UsersServiceImpl implements UsersService {

    @Autowired
    private UsersMapper usersMapper;

    @Override
    public void addUser(Users users) {
        this.usersMapper.insUser(users);
    }

    @Override
    public List<Users> showAllUser() {
        return this.usersMapper.selAllUser();
    }

    @Override
    public Users findUserById(Integer id) {
       return this.usersMapper.findUserById(id);
    }

    @Override
    public void updUser(Users users) {
        this.usersMapper.updUser(users);
    }

    @Override
    public void delUser(Integer id) {
        this.usersMapper.delUser(id);
    }
}