springboot篇---4.整合mybatis

一、Spring Boot 整合Mybatis

1.导入jar包

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.1</version>
</dependency>

2.配置数据库连接信息

spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver
    #?serverTimezone=UTC解决时区的报错
    url: jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8

二、代码。

1.创建实体类，导入 Lombok

@Data
@NoArgsConstructor
@AllArgsConstructor
public class user {
    private Integer id;
    private String username;
    private String password;
}

2.创建mapper目录以及对应的 Mapper 接口

//这个注解表示了Mybatis的mapper类
@Mapper
@Repository
public interface UserMapper {
    // 获取所有用户信息
    List<User> getUserForList();

    // 新增一个用户
    int addUser(User user);

    // 通过id获得用户信息
    User getUserById(Integer id);

    // 通过id删除用户
    int deleteById(Integer id);
}

 3.对应的Mapper映射文件

<?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="cn.hl.mapper.UserMapper">

    <select id="getUserForList" resultType="User">
       select * from user
    </select>

    <insert id="addUser" parameterType="User">
        insert into user (username,password)
        values (#{username},#{password});
    </insert>

    <select id="getUserById" resultType="User">
        select * from user where id = #{id}
    </select>
    <delete id="deleteById" parameterType="Integer">
        delete from user where id = #{id}
    </delete>

</mapper>

4.yaml中配置mybatis

#整合mybatis
mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml
  type-aliases-package: cn.hl.entity

三、编写controller测试

1.UserController 

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @RequestMapping("/getUserForList")
    public List<User> getUserForList(){
        List<User> userForList = userMapper.getUserForList();
        return userForList;
    }

    @RequestMapping("/addUser")
    public String addUser(){
        userMapper.addUser(new User(null,"adminadmin","admin"));
        return "add ok";
    }

    @RequestMapping("/getUserById")
    public User getUserById(){
        User userById = userMapper.getUserById(7);
        return userById;
    }

    @RequestMapping("/deleteById")
    public String deleteById(){
        userMapper.deleteById(7);
        return "delete ok";
    }
}