SpringBoot框架之（tk.mybatis.mapper）插件

tk.mybatis的好处
tk.mybatis是在mybatis框架的基础上提供了很多工具，让开发更加高效。这个插件里面封装好了我们需要用到的很多sql语句，不过这个插件是通过我们去调用它封装的各种方法来实现sql语句的效果。单表查询不需要写SQL语句，这样就不用像mybatis那样每次写一个接口就要写一条sql语句，这样大大减少了我们的工作量。

使用步骤：
1、添加tk.mybatis的依赖包

<!-- mapper依赖 -->
	<dependency>
		<groupId>tk.mybatis</groupId>
		<artifactId>mapper</artifactId>
		<version>4.1.5</version>
	</dependency>
	<dependency>
		<groupId>tk.mybatis</groupId>
		<artifactId>mapper-spring-boot-starter</artifactId>
		<version>2.1.5</version>
	</dependency>

2、添加一个SysUser实体类

@Table(name = "sys_user")
public class SysUser {
    @Id
    private String id;
    private String username;
    private String password;
    private String nickname;
    private Integer age;
    private Integer sex;
    private Integer job;

    @Column(name = "face_image")
    private String faceImage;
    private String province;
    private String city;
    private String district;
    private String address;
    /**
     * 用于权限的“盐”
     */
    @Column(name = "auth_salt")
    private String authSalt;
    
    @Column(name = "last_login_ip")
    private String lastLoginIp;
    
    @Column(name = "last_login_time")
    private Date lastLoginTime;

    @Column(name = "is_delete")
    private Integer isDelete;

    @Column(name = "regist_time")
    private Date registTime;
    
}
</