Springboot整合通用mapper

    mysql
    mysql-connector-java









    
    
    



    tk.mybatis
    mapper-spring-boot-starter
    2.0.2

import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;

import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Transient;
import java.util.Date;
@Data
@Table(name="tb_user")//指定表名
public class User {
    @Id//主键
    @KeySql(useGeneratedKeys = true)//自动增长
    private Long id;
    private String userName;
    private String password;
    private String name;
    private Integer age;
    //1男，2女
    private Integer sex;
    private Date birthday;
    private String note;
    private Date created;
//    @Transient 忽略该字段
    private Date updated;
}

import tk.mybatis.mapper.common.Mapper;
//继承通用Mapper的Mapper接口，指定泛型为对应实体类

public interface UserMapper extends Mapper{

}

import tk.mybatis.spring.annotation.MapperScan;

@MapperScan(basePackages="com.lamoun.leyou.mapper")

#配置com.zaxxer:HikariCP:3.4.1连接池
  spring:
    datasource:
      driver-class-name: com.mysql.jdbc.Driver
      url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
      username: root
      password: root

#整合mybatis
  mybatis:
    #启用别名,配置实体类路径(也可以在实体类上加@Enity注解)
    type-aliases-package: com.company.pojo