SpringBoot整合MyBatis

创建SpringBoot工程，添加依赖：

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.2
        
        
        
            mysql
            mysql-connector-java
            runtime
        
        
        
            org.projectlombok
            lombok
        

配置数据库yml文件

spring:
  datasource:
    username: root
    password: 123
    url: jdbc:mysql:///mydb?serverTimezone=Asia/Shanghai

创建实体类

@Data
public class User {
    private Integer uid;
    private String username;
    private String password;

}

编写mapper类和mapper.xml文件

@Mapper
public interface UserMapper {
    List getAllUsers();
}

    
        select * from user
    

测试

@SpringBootTest
class SpringBootMybatisApplicationTests {
    @Autowired
    UserMapper userMapper;

    @Test
    void contextLoads() {
        List allUsers = userMapper.getAllUsers();
        System.out.println(allUsers);
    }

}

成功！