修改入口类

需要使用 @MapperScan 注解来指定 Mapper 接口的路径
PS： 注意这里的 @MapperScan 注解是 tk.mybatis.spring.annotation.MapperScan; 包下的

  1. package com.funtl.hello.spring.boot;
  3. import org.springframework.boot.SpringApplication;
  4. import org.springframework.boot.autoconfigure.SpringBootApplication;
  5. import tk.mybatis.spring.annotation.MapperScan;
  7. @SpringBootApplication
  8. @MapperScan(basePackages = "com.funtl.hello.spring.boot.mapper")
  9. public class HelloSpringBootApplication {
  11.     public static void main(String[] args) {
  12.         SpringApplication.run(HelloSpringBootApplication.class, args);
  13.     }
  14. }

创建测试类

如果想测试的数据不写入数据库里就进行回滚操作，加上下面两个注解
@Transactional
@Rollback

  1. package com.funtl.hello.spring.boot;
  3. import com.funtl.hello.spring.boot.entity.TbUser;
  4. import com.funtl.hello.spring.boot.mapper.TbUserMapper;
  5. import com.github.pagehelper.PageHelper;
  6. import com.github.pagehelper.PageInfo;
  7. import org.junit.Test;
  8. import org.junit.runner.RunWith;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.boot.test.context.SpringBootTest;
  11. import org.springframework.test.annotation.Rollback;
  12. import org.springframework.test.context.junit4.SpringRunner;
  13. import org.springframework.transaction.annotation.Transactional;
  14. import tk.mybatis.mapper.entity.Example;
  16. import java.util.Date;
  17. import java.util.List;
  19. @RunWith(SpringRunner.class)
  20. @SpringBootTest(classes = HelloSpringBootApplication.class)
  21. @Transactional
  22. @Rollback
  23. public class MyBatisTests {
  25.     /**
  26.      * 注入数据查询接口
  27.      */
  28.     @Autowired
  29.     private TbUserMapper tbUserMapper;
  31.     /**
  32.      * 测试插入数据
  33.      */
  34.     @Test
  35.     public void testInsert() {
  36.         // 构造一条测试数据
  37.         TbUser tbUser = new TbUser();
  38.         tbUser.setUsername("Lusifer");
  39.         tbUser.setPassword("123456");
  40.         tbUser.setPhone("15888888888");
  41.         tbUser.setEmail("topsale@vip.qq.com");
  42.         tbUser.setCreated(new Date());
  43.         tbUser.setUpdated(new Date());
  45.         // 插入数据
  46.         tbUserMapper.insert(tbUser);
  47.     }
  49.     /**
  50.      * 测试删除数据
  51.      */
  52.     @Test
  53.     public void testDelete() {
  54.         // 构造条件，等同于 DELETE from tb_user WHERE username = 'Lusifer'
  55.         Example example = new Example(TbUser.class);
  56.         example.createCriteria().andEqualTo("username", "Lusifer");
  58.         // 删除数据
  59.         tbUserMapper.deleteByExample(example);
  60.     }
  62.     /**
  63.      * 测试修改数据
  64.      */
  65.     @Test
  66.     public void testUpdate() {
  67.         // 构造条件
  68.         Example example = new Example(TbUser.class);
  69.         example.createCriteria().andEqualTo("username", "Lusifer");
  71.         // 构造一条测试数据
  72.         TbUser tbUser = new TbUser();
  73.         tbUser.setUsername("LusiferNew");
  74.         tbUser.setPassword("123456");
  75.         tbUser.setPhone("15888888888");
  76.         tbUser.setEmail("topsale@vip.qq.com");
  77.         tbUser.setCreated(new Date());
  78.         tbUser.setUpdated(new Date());
  80.         // 修改数据
  81.         tbUserMapper.updateByExample(tbUser, example);
  82.     }
  84.     /**
  85.      * 测试查询集合
  86.      */
  87.     @Test
  88.     public void testSelect() {
  89.         List<TbUser> tbUsers = tbUserMapper.selectAll();
  90.         for (TbUser tbUser : tbUsers) {
  91.             System.out.println(tbUser.getUsername());
  92.         }
  93.     }
  95.     /**
  96.      * 测试分页查询
  97.      */
  98.     @Test
  99.     public void testPage() {
  100.         // PageHelper 使用非常简单，只需要设置页码和每页显示笔数即可
  101.         PageHelper.startPage(0, 2);
  103.         // 设置分页查询条件
  104.         Example example = new Example(TbUser.class);
  105.         PageInfo<TbUser> pageInfo = new PageInfo<>(tbUserMapper.selectByExample(example));
  107.         // 获取查询结果
  108.         List<TbUser> tbUsers = pageInfo.getList();
  109.         for (TbUser tbUser : tbUsers) {
  110.             System.out.println(tbUser.getUsername());
  111.         }
  112.     }
  113. }

从输出的日志可以看出数据库连接池是 MyHikariCP
image.png

附：完整的 POM

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  6.     <groupId>com.funtl</groupId>
  7.     <artifactId>hello-spring-boot</artifactId>
  8.     <version>0.0.1-SNAPSHOT</version>
  9.     <packaging>jar</packaging>
  11.     <name>hello-spring-boot</name>
  12.     <description></description>
  14.     <parent>
  15.         <groupId>org.springframework.boot</groupId>
  16.         <artifactId>spring-boot-starter-parent</artifactId>
  17.         <version>2.0.2.RELEASE</version>
  18.         <relativePath/> <!-- lookup parent from repository -->
  19.     </parent>
  21.     <properties>
  22.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  23.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  24.         <java.version>1.8</java.version>
  25.     </properties>
  27.     <dependencies>
  28.         <dependency>
  29.             <groupId>org.springframework.boot</groupId>
  30.             <artifactId>spring-boot-starter-web</artifactId>
  31.         </dependency>
  32.         <dependency>
  33.             <groupId>org.springframework.boot</groupId>
  34.             <artifactId>spring-boot-starter-tomcat</artifactId>
  35.         </dependency>
  36.         <dependency>
  37.             <groupId>org.springframework.boot</groupId>
  38.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
  39.         </dependency>
  40.         <dependency>
  41.             <groupId>org.springframework.boot</groupId>
  42.             <artifactId>spring-boot-starter-actuator</artifactId>
  43.         </dependency>
  44.         <dependency>
  45.             <groupId>org.springframework.boot</groupId>
  46.             <artifactId>spring-boot-starter-test</artifactId>
  47.             <scope>test</scope>
  48.         </dependency>
  50.         <dependency>
  51.             <groupId>com.alibaba</groupId>
  52.             <artifactId>druid-spring-boot-starter</artifactId>
  53.             <version>1.1.10</version>
  54.         </dependency>
  55.         <dependency>
  56.             <groupId>tk.mybatis</groupId>
  57.             <artifactId>mapper-spring-boot-starter</artifactId>
  58.             <version>2.0.2</version>
  59.         </dependency>
  60.         <dependency>
  61.             <groupId>com.github.pagehelper</groupId>
  62.             <artifactId>pagehelper-spring-boot-starter</artifactId>
  63.             <version>1.2.5</version>
  64.         </dependency>
  66.         <dependency>
  67.             <groupId>net.sourceforge.nekohtml</groupId>
  68.             <artifactId>nekohtml</artifactId>
  69.             <version>1.9.22</version>
  70.         </dependency>
  71.         <dependency>
  72.             <groupId>mysql</groupId>
  73.             <artifactId>mysql-connector-java</artifactId>
  74.             <scope>runtime</scope>
  75.         </dependency>
  76.     </dependencies>
  78.     <build>
  79.         <plugins>
  80.             <plugin>
  81.                 <groupId>org.springframework.boot</groupId>
  82.                 <artifactId>spring-boot-maven-plugin</artifactId>
  83.                 <configuration>
  84.                     <mainClass>com.funtl.hello.spring.boot.HelloSpringBootApplication</mainClass>
  85.                 </configuration>
  86.             </plugin>
  88.             <plugin>
  89.                 <groupId>org.mybatis.generator</groupId>
  90.                 <artifactId>mybatis-generator-maven-plugin</artifactId>
  91.                 <version>1.3.5</version>
  92.                 <configuration>
  93.                     <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
  94.                     <overwrite>true</overwrite>
  95.                     <verbose>true</verbose>
  96.                 </configuration>
  97.                 <dependencies>
  98.                     <dependency>
  99.                         <groupId>mysql</groupId>
  100.                         <artifactId>mysql-connector-java</artifactId>
  101.                         <version>${mysql.version}</version>
  102.                     </dependency>
  103.                     <dependency>
  104.                         <groupId>tk.mybatis</groupId>
  105.                         <artifactId>mapper</artifactId>
  106.                         <version>3.4.4</version>
  107.                     </dependency>
  108.                 </dependencies>
  109.             </plugin>
  110.         </plugins>
  111.     </build>
  113. </project>