Springboot整合TkMybatis

增删改查方法可参考：mybatis使用方法

Springboot整合tkMybatis

pom.xml导入坐标

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
<!--        mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <!--tk.mybatis依赖-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>

<!--        Lombok 省掉getter setter-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
<!--        测试-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

application.yml 配置数据库等

spring:
    datasource:
        url: jdbc:mysql:///ssm?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
        username: root
        password: root
        driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
    mapper-locations: classpath*:com/hbsi/mapper/*Mapper.xml  #mapper位置
logging:
    level:
        com.hbsi.mapper.*: debug    #这是你的mapper包路径，配置用与显示sql语句

实体

@Data
@ToString
@Table(name = "user")  //与数据库表名称对应
public class UsersEntity {
	@Id
    @KeySql(useGeneratedKeys = true)
    private Integer id;
    private String username;
    private String password;
    private String permission;
}

UserMapper

@Repository
public interface UserMapper extends Mapper<UsersEntity>, MySqlMapper<UsersEntity> {
}

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.hzcard.crm.mybatis.mapper.SampleMainMapper">
<!-- 字段与数据库字段对应-->
    <resultMap id="BaseResultMap" type="com.hbsi.entity.Users">
        <id column="id" jdbcType="INT" property="id" />
        <result column="username" jdbcType="VARCHAR" property="username" />
        <result column="password" jdbcType="VARCHAR" property="password" />
        <result column="permission" jdbcType="VARCHAR" property="permission" />
    </resultMap>
</mapper>

主启动类@MapperScan() 扫描mapper ，注意：tk.mybatis.spring.annotation.MapperScan

测试