springboot通用mybatis使用示例

1.依赖引入
（1）pom.xml

<dependencies>
   <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter</artifactId>
   </dependency>
   <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
   </dependency>
      <dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
         <version>1.16.10</version>
      </dependency>
   <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
   </dependency>
   <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.40</version>
   </dependency>
   <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.3.0</version>
   </dependency>
   <!--通用mybatis配置-->
   <dependency>
      <groupId>tk.mybatis</groupId>
      <artifactId>mapper-spring-boot-starter</artifactId>
      <version>1.1.3</version>
   </dependency>
   <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-logging</artifactId>
   </dependency>
</dependencies>

（2）application.properties

#数据库
spring.datasource.url=jdbc:mysql://ip:port/jd_test?useUnicode=yes&characterEncoding=UTF-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=123
spring.dataSource.driverClassName=com.mysql.jdbc.Driver
# mybatis 配置
#mybatis.type-aliases-package=com.test.layui.model
#指定mapper.xml的位置，必须配置
mybatis.mapper-locations=classpath:mapper/*.xml

#日志
logging.path=logs
logging.file=app.log
log.maxFileSize=100MB
log.maxHistory=60
log.totalSizeCap=20GB

2.数据库表

CREATE TABLE `person` (
  `ID` bigint(32) NOT NULL,
  `USER_NAME` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

3.model

package com.test.layui.model;
import lombok.Getter;
import lombok.Setter;	
import javax.pers