SpringBoot整合mybatis

1、导入需要mybatis的依赖

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

2、aplication.yml中配置数据库连接

################# 数据库基本配置
spring:
  datasource:
    username: root
    password: root
    # 注意时间区
    url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver # mysql 5
    type: com.alibaba.druid.pool.DruidDataSource
    dbcp2:
      initial-size: 5
    tomcat:
      max-active: 200

    filters: stat,wall,log4j

############### 整合mybatis
mybatis:type-aliases-package: com.chini.jdbx.demo.mapper
mybatis:
  type-aliases-package: com.chini.jdbx.demo.popj # 实体类
  mapper-locations: classpath:mybatis/mapper/*.xml # mapper.xml放置的位置

3、实体类popj：略
4、mapper接口 以查询为例

@Mapper
@Repository
public interface UserMapper {
    List<User> getAllUsers();
}

5、UserMapper.xml中写对应的sql的语句

<?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.chini.jdbx.demo.mapper.UserMapper">
   
    <select id="getAllUsers" resultType="User">
       select * from user
    </select>
</mapper>

6、UserController调用

@RestController
public class UserController {
    @Autowired
    UserMapper userMapper;

    @GetMapping("/getAll")
    public List<User> getAllUsers(){
        List<User> allUsers = userMapper.getAllUsers();
        for(User user : allUsers)
            System.out.println(user.getName());
        return allUsers;
    }
}