SpringBoot整合MyBatis逆向工程及 MyBatis通用Mapper实例详解

<project xmlns="http://maven.apache.org/pom/4.0.0" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance"
 xsi:schemalocation="http://maven.apache.org/pom/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
 <modelversion>4.0.0</modelversion>
 <parent>
  <groupid>org.springframework.boot</groupid>
  <artifactid>spring-boot-starter-parent</artifactid>
  <version>1.5.6.release</version>
 </parent>
 <groupid>org.rcddup</groupid>
 <artifactid>rcddup-custom</artifactid>
 <version>1.0.0</version>
 <properties>
  <java.version>1.8</java.version>
  <mybatis.version>1.3.1</mybatis.version>
  <mapper.version>3.4.3</mapper.version>
  <mybatis-generator.version>1.3.3</mybatis-generator.version>
  <mybatis-tk.version>1.1.4</mybatis-tk.version>
  <pagehelper.version>1.2.1</pagehelper.version>
 </properties>
 <dependencies>
  <!-- springboot - web -->
  <dependency>
   <groupid>org.springframework.boot</groupid>
   <artifactid>spring-boot-starter-web</artifactid>
  </dependency>
  <!-- springboot - mybatis -->
  <dependency>
   <groupid>org.mybatis.spring.boot</groupid>
   <artifactid>mybatis-spring-boot-starter</artifactid>
   <version>${mybatis.version}</version>
  </dependency>
  <!-- springboot - mybatis 逆向工程 -->
  <dependency>
   <groupid>org.mybatis.generator</groupid>
   <artifactid>mybatis-generator-core</artifactid>
   <version>${mybatis-generator.version}</version>
  </dependency>
  <!-- mybatis 通用 mapper -->
  <dependency>
   <groupid>tk.mybatis</groupid>
   <artifactid>mapper-spring-boot-starter</artifactid>
   <version>${mybatis-tk.version}</version>
  </dependency>
  <!-- mysql -->
  <dependency>
   <groupid>mysql</groupid>
   <artifactid>mysql-connector-java</artifactid>
  </dependency>
 </dependencies>
 <build>
  <plugins>
   <!-- mybatis 逆向工程 插件 -->
   <plugin>
    <groupid>org.mybatis.generator</groupid>
    <artifactid>mybatis-generator-maven-plugin</artifactid>
    <version>${mybatis.generator.version}</version>
    <dependencies>
     <dependency>
      <groupid>mysql</groupid>
      <artifactid>mysql-connector-java</artifactid>
      <version>${mysql.version}</version>
     </dependency>
     <dependency>
      <groupid>tk.mybatis</groupid>
      <artifactid>mapper</artifactid>
      <version>${mapper.version}</version>
     </dependency>
    </dependencies>
    <configuration>
     <!-- 允许移动生成的文件 -->
     <verbose>true</verbose>
     <!-- 是否覆盖 -->
     <overwrite>true</overwrite>
     <!-- 配置文件 -->
     <configurationfile>
      ${basedir}/src/main/resources/generator/generatorconfig.xml
     </configurationfile>
    </configuration>
   </plugin>
  </plugins>
 </build>
</project>

<?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>
 <!-- 引入 application.properties -->
 <properties resource="application.properties" />
 <!-- mybatis3simple：不生成 example相关类及方法 -->
 <context id="mysql" targetruntime="mybatis3simple" defaultmodeltype="flat">
  <property name="beginningdelimiter" value="`" />
  <property name="endingdelimiter" value="`" />
  <!-- 指定生成 mapper 的继承模板 -->
  <plugin type="tk.mybatis.mapper.generator.mapperplugin">
   <property name="mappers" value="${generator.mappers}" />
  </plugin>
  <!-- 生成 javabean 对象重写 tostring方法 -->
  <plugin type="org.mybatis.generator.plugins.tostringplugin" />
  <!-- 生成 javabean 对象继承 serializable 类 -->
  <plugin type="org.mybatis.generator.plugins.serializableplugin" />
  <!-- 生成 javabean 对象重写 equals 和 hashcode 方法 -->
  <!-- <plugin type="org.mybatis.generator.plugins.equalshashcodeplugin" /> -->
  <!-- jdbc 连接配置 -->
  <jdbcconnection driverclass="${spring.datasource.driver-class-name}"
   connectionurl="${spring.datasource.url}"
   userid="${spring.datasource.username}"
   password="${spring.datasource.password}">
  </jdbcconnection>
  <javamodelgenerator targetpackage="${generator.javamodel-targetpackage}"
   targetproject="${generator.targetproject}" />
  <sqlmapgenerator targetpackage="${generator.sqlmap-targetpackage}" 
   targetproject="${generator.targetproject}" />
  <javaclientgenerator targetpackage="${generator.javaclient-targetpackage}"
   targetproject="${generator.targetproject}" type="xmlmapper" />
  <!-- mysql 配置 -->
  <!-- <generatedkey column="id" sqlstatement="mysql" identity="true" /> -->
  <!-- oracle 配置 -->
  <!-- <generatedkey column="id" sqlstatement="select seq_{1}.nextval from dual" identity="false" type="pre"/> -->
  <!-- tablename：数据库表名，domainobjectname：生成文件名 ，schema：数据源-->
  <table tablename="user">
   <generatedkey column="id" sqlstatement="mysql" identity="true" />
  </table>
 </context>
</generatorconfiguration>

# generator
generator.targetproject=src/main/java
generator.mappers=org.rcddup.app.common.base.ibasemapper
generator.javamodel-targetpackage=org.rcddup.app.domain
generator.sqlmap-targetpackage=org.rcddup.app.dao
generator.javaclient-targetpackage=org.rcddup.app.dao

package org.rcddup.app.common.base;
import tk.mybatis.mapper.common.mapper;
import tk.mybatis.mapper.common.mysqlmapper;
public interface ibasemapper<t> extends mapper<t>, mysqlmapper<t> {
}

package org.rcddup.app.dao;
import org.rcddup.app.common.base.ibasemapper;
import org.rcddup.app.domain.user;
public interface usermapper extends ibasemapper<user> {
}

<?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="org.rcddup.app.dao.usermapper">
 <resultmap id="baseresultmap" type="org.rcddup.app.domain.user">
 <!--
  warning - @mbg.generated
 -->
 <id column="id" jdbctype="bigint" property="id" />
 <result column="name" jdbctype="varchar" property="name" />
 <result column="age" jdbctype="tinyint" property="age" />
 <result column="status" jdbctype="tinyint" property="status" />
 </resultmap>
</mapper>

package org.rcddup.app.service.impl;
import java.util.list;
import org.rcddup.app.dao.usermapper;
import org.rcddup.app.domain.user;
import org.rcddup.app.service.iuserservice;
import org.springframework.beans.factory.annotation.autowired;
import org.springframework.stereotype.service;
import tk.mybatis.mapper.entity.example;
@service
public class userservice implements iuserservice{
 @autowired
 private usermapper usermapper;
 @override
 public list<user> listuser() {
  return usermapper.selectall();
 }
 @override
 public user getuserbyid(long id) {
  // 方法一：适用于任何字段的查询
//  example example = new example(user.class);
//  example.createcriteria().andequalto("id", id);
//  list<user> list = usermapper.selectbyexample(example);
//  if (list != null && list.size() > 0) {
//   return list.get(0);
//  } else {
//   return null;
//  }
  // 方法二：只适用于主键字段
  return usermapper.selectbyprimarykey(id);
 }
}