tk mapper和mybatis plus_dozermapper

<dependency>

  <groupId>tk.mybatis</groupId>

  <artifactId>mapper</artifactId>

  <version>版本号</version>

</dependency>

<dependency>

  <groupId>tk.mybatis</groupId>

  <artifactId>mapper-spring-boot-starter</artifactId>

  <version>版本号</version>

</dependency>

mapper:

  mappers:

    - tk.mybatis.mapper.common.Mapper

    - tk.mybatis.mapper.common.Mapper2

  notEmpty: true

mapper.mappers=tk.mybatis.mapper.common.Mapper,tk.mybatis.mapper.common.Mapper2

mapper.notEmpty=true

@tk.mybatis.spring.annotation.MapperScan(basePackages = "扫描包")
@SpringBootApplication
public class SampleMapperApplication implements CommandLineRunner {

Example example = new Example(Country.class);
example.setForUpdate(true);
example.createCriteria().andGreaterThan("id", 100).andLessThan("id",151);
example.or().andLessThan("id", 41);
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT id,countryname,countrycode FROM country WHERE ( id > ? and id < ? ) or ( id < ? ) ORDER BY id desc FOR UPDATE 
DEBUG [main] - ==> Parameters: 100(Integer), 151(Integer), 41(Integer)
DEBUG [main] - <==      Total: 90

Example example = new Example(Country.class);
Example.Criteria criteria = example.createCriteria();
if(query.getCountryname() != null){
    criteria.andLike("countryname", query.getCountryname() + "%");
}
if(query.getId() != null){
    criteria.andGreaterThan("id", query.getId());
}
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT id,countryname,countrycode FROM country WHERE ( countryname like ? ) ORDER BY id desc 
DEBUG [main] - ==> Parameters: China%(String)
DEBUG [main] - <==      Total: 1

Example example = new Example(Country.class);
example.orderBy("id").desc().orderBy("countryname").orderBy("countrycode").asc();
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT id,countryname,countrycode FROM country order by id DESC,countryname,countrycode ASC 
DEBUG [main] - ==> Parameters: 
DEBUG [main] - <==      Total: 183

Example example = new Example();
//设置 distinct
example.setDistinct(true);
example.createCriteria().andCountrynameLike("A%");
example.or().andIdGreaterThan(100);
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT distinct id,countryname,countrycode FROM country WHERE ( countryname like ? ) or ( Id > ? ) ORDER BY id desc 
DEBUG [main] - ==> Parameters: A%(String), 100(Integer)
DEBUG [main] - <==      Total: 95

Example example = new Example(Country.class);
example.selectProperties("id", "countryname");
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT id , countryname FROM country ORDER BY id desc 
DEBUG [main] - ==> Parameters: 
DEBUG [main] - <==      Total: 183

Example example = Example.builder(Country.class)
        .select("countryname")
        .where(Sqls.custom().andGreaterThan("id", 100))
        .orderByAsc("countrycode")
        .forUpdate()
        .build();
List<Country> countries = mapper.selectByExample(example);

DEBUG [main] - ==>  Preparing: 
SELECT countryname FROM country WHERE ( id > ? ) order by countrycode Asc FOR UPDATE 
DEBUG [main] - ==> Parameters: 100(Integer)
DEBUG [main] - <==      Total: 83

List<Country> selectByWeekendSql = mapper.selectByExample(
        new Example.Builder(Country.class)
                .where(WeekendSqls.<Country>custom().andLike(Country::getCountryname, "%a%")
                        .andGreaterThan(Country::getCountrycode, "123"))
                .build());

DEBUG [main] - ==>  Preparing: 
SELECT id,countryname,countrycode FROM country WHERE ( countryname like ? and countrycode > ? ) 
DEBUG [main] - ==> Parameters: %a%(String), 123(String)
DEBUG [main] - <==      Total: 151

public interface BaseMapper<T> extends Mapper<T>, MySqlMapper<T> {}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<properties resource="generator/generator.properties" />

<classPathEntry location="E:\mysql\mysql-connector-java-5.1.29.jar"/>

<property name="beginningDelimiter" value="`"/>

<property name="endingDelimiter" value="`"/>  

<!--配置model生成路径及所在包-->
<javaModelGenerator targetPackage="com.jbdp.zgcfz.generator.domain.model" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java" />

注:项目路径为个人测试地址

<!--配置mapper.xml生成路径及所在包-->
<sqlMapGenerator targetPackage="mapper" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/resources/mybatis" />

<javaClientGenerator>

<!--配置mapper接口生成路径及所在包-->
<javaClientGenerator targetPackage="com.jbdp.zgcfz.generator.domain.mapper" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java" type="XMLMAPPER" />

<table tableName="user login info" domainObjectName="UserLoginInfo">
   <generatedKey column="id" sqlStatement="Mysql"/>
</table>

<insert id="insert" parameterType="test.model.UserLoginInfo">
   <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
      SELECT LAST_INSERT_ID()
   </selectKey>
   insert into `user login info` (Id, username, logindate, loginip)
   values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{logindate,jdbcType=TIMESTAMP}, #{loginip,jdbcType=VARCHAR})
</insert>

<table tableName="user login info" domainObjectName="UserLoginInfo">
   <generatedKey column="id" sqlStatement="select SEQ_ID.nextval from dual"/>
</table>

<insert id="insert" parameterType="test.model.UserLoginInfo">
   <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Integer">
      select SEQ_ID.nextval from dual
   </selectKey>
   insert into `user login info` (Id, username, logindate, loginip)
   values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{logindate,jdbcType=TIMESTAMP},#{loginip,jdbcType=VARCHAR})
</insert>

<columnRenamingRule searchString="^CUST_" replaceString="" />

<table schema="DB2ADMIN" tableName="ALLTYPES" >
   <columnOverride column="LONG_VARCHAR_FIELD" javaType="java.lang.String" jdbcType="VARCHAR" />
</table>

<!-- 通用 Mapper -->
<!-- https://mvnrepository.com/artifact/tk.mybatis/mapper -->
<dependency>
    <groupId>tk.mybatis</groupId>
    <artifactId>mapper</artifactId>
    <version>4.0.0</version>
</dependency>

package com.jbdp.generator;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

public class Generator {
   public static void main(String[] args) throws Exception {
      // TODO Auto-generated method stub
      List<String> warnings = new ArrayList<String>();
        boolean overwrite = true;
        ConfigurationParser cp = new ConfigurationParser(warnings);
        Configuration config =  

cp.parseConfiguration(getResourceAsStream("generator/generatorConfig.xml"));
        DefaultShellCallback callback = new DefaultShellCallback(overwrite);
        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
        myBatisGenerator.generate(null);
        for (String warning : warnings) {
            System.out.println(warning);
        }
   }
}

package xxx.base;
import tk.mybatis.mapper.common.Mapper;

import tk.mybatis.mapper.common.MySqlMapper;
/**
 * 继承自己的MyMapper
 */

public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> {
    //TODO
    //FIXME 特别注意，该接口不能被扫描到，否则会出错
}

<property name="mappers" value="xxx.base.MyMapper"/>

<table tableName="country">
   <generatedKey column="id" sqlStatement="select SEQ_{1}.nextval from dual"  identity="false" type="pre"/>
</table>

public class Country {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY,
            generator = "select SEQ_COUNTRY.nextval from dual")
    private Integer id;
    // 省略其他
}

<plugins>
    <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <configuration>
            <source>${jdk.version}</source>
            <target>${jdk.version}</target>
        </configuration>
    </plugin>
    <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.6</version>
        <configuration>
            <configurationFile>
                ${basedir}/src/main/resources/generator/generatorConfig.xml
            </configurationFile>
            <overwrite>true</overwrite>
            <verbose>true</verbose>
        </configuration>
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.29</version>
            </dependency>
            <dependency>
                <groupId>tk.mybatis</groupId>
                <artifactId>mapper</artifactId>
                <version>4.0.0</version>
            </dependency>
        </dependencies>
    </plugin>
</plugins>

package com.isea533.mybatis.model;
import javax.persistence.*;
@Table(name = "country")
public class Country {
    /**
     * 主键
     */
    @Id
    @Column(name = "Id")
    @GeneratedValue(generator = "JDBC")
    private Integer id;
    /**
     * 名称
     */
    private String countryname;
    /**
     * 代码
     */
    private String countrycode;
    /**
     * 获取主键
     *
     * @return Id - 主键
     */
    public Integer getId() {
        return id;
    }
    /**
     * 设置主键
     *
     * @param id 主键
     */
    public void setId(Integer id) {
        this.id = id;
    }
    /**
     * 获取名称
     *
     * @return countryname - 名称
     */
    public String getCountryname() {
        return countryname;
    }
    /**
     * 设置名称
     *
     * @param countryname 名称
     */
    public void setCountryname(String countryname) {
        this.countryname = countryname;
    }
    /**
     * 获取代码
     *
     * @return countrycode - 代码
     */
    public String getCountrycode() {
        return countrycode;
    }
    /**
     * 设置代码
     *
     * @param countrycode 代码
     */
    public void setCountrycode(String countrycode) {
        this.countrycode = countrycode;
    }
}

package com.isea533.mybatis.mapper;
import com.isea533.mybatis.model.Country;
import tk.mybatis.mapper.common.Mapper;
public interface CountryMapper extends Mapper<Country> {
}

<?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.isea533.mybatis.mapper.CountryMapper">
    <resultMap id="BaseResultMap" type="com.isea533.mybatis.model.Country">
        <!--
          WARNING - @mbg.generated
        -->
        <id column="Id" jdbcType="INTEGER" property="id" />
        <result column="countryname" jdbcType="VARCHAR" property="countryname" />
        <result column="countrycode" jdbcType="VARCHAR" property="countrycode" />
    </resultMap></mapper>

<property name="targetProject" value="../myproject-api/src/main/java"/>

<dependency>
   <groupId>org.freemarker</groupId>
   <artifactId>freemarker</artifactId>
   <version>2.3.23</version>
</dependency>

特殊：targetPackage值在 ${package} 中。
<!-- 详细日期用法参考：http://freemarker.apache.org/docs/ref_builtins_date.html -->
当前时间：
<#assign dateTime = .now>
日期：${dateTime?date}
时间：${dateTime?time}
格式化：${dateTime?string["yyyy-MM-dd HH:mm:ss"]}
所有配置的属性信息:
<#list props?keys as key>
    ${key} - ${props[key]}
</#list>
实体和表的信息：
表名：${tableClass.tableName}
变量名：${tableClass.variableName}
小写名：${tableClass.lowerCaseName}
类名：${tableClass.shortClassName}
全名：${tableClass.fullClassName}
包名：${tableClass.packageName}
列的信息：
=====================================
<#if tableClass.pkFields??>
    主键：
    <#list tableClass.pkFields as field>
        -------------------------------------
        列名：${field.columnName}
        列类型：${field.jdbcType}
        字段名：${field.fieldName}
        注释：${field.remarks}
        类型包名：${field.typePackage}
        类型短名：${field.shortTypeName}
        类型全名：${field.fullTypeName}
        是否主键：${field.identity?c}
        是否可空：${field.nullable?c}
        是否为BLOB列：${field.blobColumn?c}
        是否为String列：${field.stringColumn?c}
        是否为字符串列：${field.jdbcCharacterColumn?c}
        是否为日期列：${field.jdbcDateColumn?c}
        是否为时间列：${field.jdbcTimeColumn?c}
        是否为序列列：${field.sequenceColumn?c}
        列长度：${field.length?c}
        列精度：${field.scale}
    </#list>
</#if>
<#if tableClass.baseFields??>
    基础列：
    <#list tableClass.baseFields as field>
        -------------------------------------
        列名：${field.columnName}
        列类型：${field.jdbcType}
        字段名：${field.fieldName}
        注释：${field.remarks}
        类型包名：${field.typePackage}
        类型短名：${field.shortTypeName}
        类型全名：${field.fullTypeName}
        是否主键：${field.identity?c}
        是否可空：${field.nullable?c}
        是否为BLOB列：${field.blobColumn?c}
        是否为String列：${field.stringColumn?c}
        是否为字符串列：${field.jdbcCharacterColumn?c}
        是否为日期列：${field.jdbcDateColumn?c}
        是否为时间列：${field.jdbcTimeColumn?c}
        是否为序列列：${field.sequenceColumn?c}
        列长度：${field.length?c}
        列精度：${field.scale}
    </#list>
</#if>
<#if tableClass.blobFields??>
    Blob列：
    <#list tableClass.blobFields as field>
        -------------------------------------
        列名：${field.columnName}
        列类型：${field.jdbcType}
        字段名：${field.fieldName}
        注释：${field.remarks}
        类型包名：${field.typePackage}
        类型短名：${field.shortTypeName}
        类型全名：${field.fullTypeName}
        是否主键：${field.identity?c}
        是否可空：${field.nullable?c}
        是否为BLOB列：${field.blobColumn?c}
        是否为String列：${field.stringColumn?c}
        是否为字符串列：${field.jdbcCharacterColumn?c}
        是否为日期列：${field.jdbcDateColumn?c}
        是否为时间列：${field.jdbcTimeColumn?c}
        是否为序列列：${field.sequenceColumn?c}
        列长度：${field.length?c}
        列精度：${field.scale}
    </#list>
</#if>
=====================================
全部列（包含了pk,base,blob 字段，可用的属性和上面的一样）：
<#if tableClass.allFields??>
    列名 - 字段名
    <#list tableClass.allFields as field>
        ${field.columnName} - ${field.fieldName}
    </#list>
</#if>

 <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
   <properties resource="generator/generator.properties" />
   <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"  >
        <!--数据库配置-->
      <property name="driverClass" value="${datasource.driverClassName}" />
      <property name="connectionURL" value="${datasource.url}" />
      <property name="userId" value="${datasource.username}" />
      <property name="password" value="${datasource.password}" />
      <property name="schema" value="${datasource.schema}" />
        <!--生成器配置-->
      <property name="beginningDelimiter" value="`" />
      <property name="endingDelimiter" value="`" />
      <property name="javaFileEncoding" value="UTF-8" />
        <!--使用通用 Mapper 提供的注释工具，目前只有 mysql 和 oracle 支持，设置 false后会用默认的，或者你可以配置自己的注释插件
        <commentGenerator type="自己的注释插件" />  -->
      <property name="useMapperCommentGenerator" value="true" />
      <!--Controller-->
      <plugin type="tk.mybatis.mapper.generator.TemplateFilePlugin">
         <property name="targetProject" value="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java"/>
         <property name="targetPackage" value="com.jbdp.zgcfz.generator.controller" />
         <property name="templatePath" value="generator/test/Controller.ftl" />
         <property name="fileName" value="${tableClass.shortClassName}Controller.java"/>
         <property name="fwPackage" value="${project.fwPackage}" />
         <!--默认值是下面这个，可以不配置-->
         <property name="templateFormatter"
                 value="tk.mybatis.mapper.generator.formatter.FreemarkerTemplateFormatter"/>
      </plugin>
      <!--Service-->
      <plugin type="tk.mybatis.mapper.generator.TemplateFilePlugin">
         <property name="targetProject" value="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java"/>
         <property name="targetPackage" value="com.jbdp.zgcfz.generator.service" />
         <property name="templatePath" value="generator/test/Service.ftl" />
         <property name="fileName" value="${tableClass.shortClassName}Service.java"/>
         <!--默认值是下面这个，可以不配置-->
         <property name="templateFormatter"
                 value="tk.mybatis.mapper.generator.formatter.FreemarkerTemplateFormatter"/>
      </plugin>
      <!--ServiceImpl-->
      <plugin type="tk.mybatis.mapper.generator.TemplateFilePlugin">
         <property name="targetProject" value="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java"/>
         <property name="targetPackage" value="com.jbdp.zgcfz.generator.service.impl" />
         <property name="templatePath" value="generator/test/ServiceImpl.ftl" />
         <property name="fileName" value="${tableClass.shortClassName}ServiceImpl.java"/>
         <property name="fwPackage" value="${project.fwPackage}" />
         <!--默认值是下面这个，可以不配置-->
         <property name="templateFormatter"
                 value="tk.mybatis.mapper.generator.formatter.FreemarkerTemplateFormatter"/>
      </plugin>
        <!--Mapper文件和model生成-->
        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="com.jbdp.base.domain.mapper.BaseMapper"/>
            <property name="caseSensitive" value="true"/>
            <property name="forceAnnotation" value="true"/>
        </plugin>
      <!--给mapper接口增加@Mapper注解-->
      <plugin type="org.mybatis.generator.plugins.MapperAnnotationPlugin" />
      <jdbcConnection
         driverClass="${datasource.driverClassName}"
         connectionURL="${datasource.url}"
         userId="${datasource.username}"
         password="${datasource.password}">
         <property name="useInformationSchema" value="true"></property>
         <property name="characterEncoding" value="UTF-8"></property>
      </jdbcConnection>
      <!--配置model生成路径及所在包-->
      <javaModelGenerator targetPackage="com.jbdp.zgcfz.generator.domain.model" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java" />
      <!--配置mapper.xml生成路径及所在包-->
      <sqlMapGenerator targetPackage="mapper" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/resources/mybatis" />
      <!--配置mapper接口生成路径及所在包-->
      <javaClientGenerator targetPackage="com.jbdp.zgcfz.generator.domain.mapper" targetProject="D:/Workspaces/IdeaProjects/zgcfz_generator/src/main/java" type="XMLMAPPER" />
      <table tableName="test">
         <!--让model继承某个类-->
         <property name="rootClass" value="com.jbdp.base.domain.model.BaseModel"/>
         <!--自动生成组件-->
         <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
      </table>
   </context>
</generatorConfiguration>

Tk:
@Service
public class TestServiceImpl extends BaseServiceImpl implements TestService {
    @Resource
    TestMapper mapper;
    @Override
    public int insert(Test input) {
        return mapper.insert(input);
    }
}
该Mapper extends tk的Mapper接口
Mp:
Service层操作
public R<RPage<AccountLogListVo>> list(@Valid @ApiParam("查询对象")AccountLogQueryDto accountLogQueryDto, @ApiParam("分页对象")QPage qpage) {
    JcwlUser user = SecurityUtils.getUser();
    Account account = accountService.getOne(Wrappers.<Account>query()
            .lambda()
            .eq(Account::getUserId, user.getUserId())
            .eq(Account::getAccType, 1));
    return new R<>(new RPage<>());
}
accountService extends mp的IService接口,其实现类extends mp的ServiceImpl类
(ServiceImpl<M extends BaseMapper<T>, T> implements IService),
ServiceImpl类有一个baseMapper变量可以直接使用
Mapper层操作
public AccountVo info(JcwlUser user) {
    Account account = baseMapper.selectOne(Wrappers.<Account>query()
            .lambda()
            .eq(Account::getUserId, user.getUserId())
            .eq(Account::getAccType, 1)
    );
    AccountVo accountVo = new AccountVo();
    //....
    return accountVo;
}
可以使用mp ServiceImpl类的baseMapper,也可以在自己的mapper里extends mp的BaseMapper接口

Springboot引入依赖
<!--分页插件-->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.13</version>
</dependency>
配置
# 分页配置
pagehelper:
  helper-dialect: mysql
  reasonable: true
  support-methods-arguments: true
  params: count=countSql
使用
PageHelper.startPage(pageNum,pageSize);//这行是重点，表示从pageNum页开始，每页pageSize条数据
List<Tools> list = toolsMapper.findAll();//紧跟着第一个select方法会被分页
PageInfo<Tools> pageInfo = new PageInfo<Tools>(list);
return ServerResponse.createBySuccess("查询成功",pageInfo);