SpringBoot 09——整合Mybatis

搭建SpringBoot工程

在IDEA中用Spring Initializr快速构建工程时在依赖项中选上MyBatis Framework和MySQL Driver引入起步依赖

编写DataSource和Mybatis相关配置

# datasource
spring:
  datasource:
    url: jdbc:mysql:///user
    driver: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456

准备数据表和实体类

注意配置get和set方法

编写mapper接口（纯注解开发）

@Mapper
@Repository
public interface UserMapper {

    @Select("select * from User")
    public List<User> findAll();
}

测试

@RunWith(SpringRunner.class)
@SpringBootTest
class SpringBootMybatisApplicationTests {

    @Autowired
    private UserMapper userMapper;

    @Test
    public void testFindAll(){
        List<User> list = userMapper.findAll();
        System.out.println(list);
    }

}

编写dao接口和mapper.xml配置文件

@Mapper
@Repository
public interface UserXmlMapper {

    public List<User> findAll();
}

命名空间与id结合设置调用的方法
resultType设置返回的实体类

<?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.example.springbootmybatis.mapper.UserXmlMapper">
    <select id="findAll" resultType="user">
        select * from user
    </select>
</mapper>

测试

@RunWith(SpringRunner.class)
@SpringBootTest
class SpringBootMybatisApplicationTests {
    @Autowired
    private UserXmlMapper userXmlMapper;
    
    @Test
    public void testFindAll2(){
        List<User> list = userXmlMapper.findAll();
        System.out.println(list);
    }
}

结果