Spring Boot整合使用xml方式的MyBatis

在官网新建一个spring boot项目，导入到IDE

配置

• 在pom文件中添加依赖

<dependencies>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <!--mybatis-->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.3.1</version>
    </dependency>

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

</dependencies>

• 在application.properties文件中配置数据源和mybatis扫描路径和配置文件路径

spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

mybatis.configLocation=classpath:MybatisConfig.xml
mybatis.mapperLocations=classpath:mapping/*.xml

• 在resources文件夹中新增mapping文件夹和MybatisConfig.xml配置文件

MybatisConfig.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd" >
<configuration>
</configuration>

• 配置自动扫描

@SpringBootApplication
@MapperScan("com.learn.dao")
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

使用MyBatis

• 在Mysql中创建User表，包含id(BIGINT)、name(VARCHAR)、age(INT)字段。同时，创建映射对象User

public class User {

    private Long id;
    private String name;
    private Integer age;

    // getter和setter

}

• 创建User映射的操作UserMapper，为了后续单元测试验证，实现插入和查询操作

package com.learn.dao;

public interface UserMapper {

    User findByName(@Param("name") String name);

    int insert(@Param("name") String name, @Param("age") Integer age);
    
}

• 在mapping文件夹中创建映射文件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.learn.dao.UserMapper">

    <select id="findByName" resultType="com.learn.model.User">
        SELECT * FROM USER WHERE NAME = #{name}
    </select>

    <insert id="insert">
      INSERT INTO USER(NAME, AGE) VALUES(#{name}, #{age})
    </insert>

</mapper>

• 创建单元测试
  • 测试逻辑：插入一条name=AAA，age=20的记录，然后根据name=AAA查询，并判断age是否为20
  • 测试结束回滚数据，保证测试单元每次运行的数据环境独立

@RunWith(SpringRunner.class)
@SpringBootTest
@Transactional
public class ApplicationTests {

    @Autowired
    private UserMapper userMapper;

    @Test
    @Rollback
    public void findByName() throws Exception {
        userMapper.insert("AAA", 20);
        User u = userMapper.findByName("AAA");
        Assert.assertEquals(20, u.getAge().intValue());
    }

}

添加翻页插件

• 在pom文件中加入依赖

<dependencies>
    <!-- 翻页控件 -->
    <dependency>
        <groupId>com.github.miemiedev</groupId>
        <artifactId>mybatis-paginator</artifactId>
        <version>1.2.17</version>
    </dependency>
</dependencies>

• 在MybatisConfig.xml中加入

<configuration>
  <plugins>
    <plugin interceptor="com.github.miemiedev.mybatis.paginator.OffsetLimitInterceptor">
      <property name="dialectClass" value="com.github.miemiedev.mybatis.paginator.dialect.MySQLDialect"/>
    </plugin>
  </plugins>
</configuration>

• 在UserMapper中新增接口findAll

public interface UserMapper {
    List<User> findAll(PageBounds pageBounds);
}

• 在UserMapper.xml中新增映射

<mapper>
    <select id="findAll" resultType="com.learn.model.User">
        SELECT *
        FROM user
    </select>
</mapper>

• 创建测试用例

@RunWith(SpringRunner.class)
@SpringBootTest
@Transactional
public class ApplicationTests {

    @Resource
    private UserMapper userMapper;

    @Test
    @Rollback
    public void findAll() throws Exception {
        userMapper.insert("小米", 21);
        userMapper.insert("小兰", 22);
        userMapper.insert("小四", 23);
        userMapper.insert("张三", 24);
        userMapper.insert("李四", 25);
        userMapper.insert("王五", 26);
        userMapper.insert("泽六", 27);
        PageBounds pageBounds = new PageBounds(1, 5, Order.formString("age.desc"));
        PageList<User> users = (PageList<User>) userMapper.findAll(pageBounds);
        System.out.println("--------------------page-------------------------");
        System.out.println(users);
        System.out.println("总数量：" + users.getPaginator().getTotalCount());
        System.out.println("总页数：" + users.getPaginator().getTotalPages());
        System.out.println("当前页：" + users.getPaginator().getPage());
        System.out.println("每页条数：" + users.getPaginator().getLimit());
        System.out.println("--------------------end-------------------------");
    }
}

运行可以看到结果

--------------------page-------------------------
[User{id=58, name='泽六', age=27}, User{id=57, name='王五', age=26}, User{id=56, name='李四', age=25}, User{id=55, name='张三', age=24}, User{id=54, name='小四', age=23}]
总数量：7
总页数：2
当前页：1
每页条数：5
--------------------end-------------------------

项目地址