插件方式构建逆向工程

1.搭建 MyBatis Generator 插件环境

  1. 添加插件依赖 pom.xml

<!--mybatis 逆向生成插件--><plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.2</version><configuration><configurationFile>src/main/resources/generatorConfig.xml</configurationFile><verbose>true</verbose><overwrite>true</overwrite></configuration><executions><execution><id>Generate MyBatis Artifacts</id></execution></executions><dependencies><dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.3.2</version></dependency></dependencies></plugin>

2.配置文件 generatorConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><!-- 配置Run As Maven build : Goals 参数 : mybatis-generator:generate -Dmybatis.generator.overwrite=true -->
<!-- 配置 tableName,使用 Run As Maven build 生成 dao model 层 -->
<generatorConfiguration><!--数据库驱动包路径 --><classPathEntrylocation="D:\maven\mvnRespo\mysql\mysql-connector-java\8.0.15\mysql-connector-java-8.0.15.jar"/><context id="DB2Tables" targetRuntime="MyBatis3"><!--关闭注释 --><commentGenerator><property name="suppressAllComments" value="true"/></commentGenerator><!--数据库连接信息 --><jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/frame?useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false"userId="root" password="zxc123456"></jdbcConnection><!--生成的model 包路径 --><javaModelGenerator targetPackage="com.zpark.springbt.model"targetProject="src/main/java"><property name="enableSubPackages" value="ture"/><property name="trimStrings" value="true"/></javaModelGenerator><!--生成xml mapper文件 路径 --><sqlMapGenerator targetPackage="mapper"targetProject="src/main/resources"><property name="enableSubPackages" value="ture"/></sqlMapGenerator><!-- 生成的Dao接口 的包路径 --><javaClientGenerator type="XMLMAPPER"targetPackage="com.zpark.springbt.dao" targetProject="src/main/java"><property name="enableSubPackages" value="ture"/></javaClientGenerator><!--对应数据库表名，多个表，请复制指定 --><!--生成对应表及类名--><!-- schema指定表的schema名字，否则会造成mapper.xml代码重复 --><table schema="frame" tableName="aaa" domainObjectName="aaa"></table></context>
</generatorConfiguration>

二、开始生成逆向工程

选择maven-->plugins-->mybatis-generator-->mybatis-generator-gennerate

1、create  2、run   即可生成文件

二、逆向工程之Example

逆向工程会生成一个BeanExample类，里面封装了一些where后我们可以会用到的方法。

例如：

SELECT * FROM frame.student where sex = '女' order by id desc

where后我们会用到sex='女'，order by id，desc。这三个条件已经在example中，我们可以直接使用

package com.zpark.neimin.first.controller;import com.zpark.neimin.first.model.Student;
import com.zpark.neimin.first.model.StudentExample;
import com.zpark.neimin.first.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;import java.util.List;@Controller
@RequestMapping("/student")
public class StudentController {@AutowiredStudentService studentService;@RequestMapping("/example")@ResponseBodypublic List<Student> example() {//    SELECT * FROM frame.student where sex = '女' order by id descStudentExample studentExample = new StudentExample();//根据id  降序排列studentExample.setOrderByClause("id desc");StudentExample.Criteria criteria = studentExample.createCriteria();criteria.andSexEqualTo("女");
//        criteria.andRealNameEqualTo()List<Student> students = studentService.selectByExample(studentExample);return students;}
}

其他可能用到的方法：

Mybatis逆向工程会生成实例及实例对应的example（用于添加条件，相当于where后的部分）
xxxExample example = new xxxExample();
Criteria criteria = example.createCriteria();
方法说明：
// 1.添加升序排列条件，DESC为降序
example.setOrderByClause("字段名ASC")
// 2.去除重复，boolean类型，true为选择不重复的记录
example.setDistinct(false)
// 3.添加字段xxx为null的条件
criteria.andXxxIsNull
// 4.添加字段xxx不为null的条件
criteria.andXxxIsNotNull
// 5.添加xxx字段等于value条件
criteria.andXxxEqualTo(value)
// 6.添加xxx字段不等于value条件
criteria.andXxxNotEqualTo(value)
// 7.添加xxx字段大于value条件
criteria.andXxxGreaterThan(value)
// 8.添加xxx字段大于等于value条件
criteria.andXxxGreaterThanOrEqualTo(value)
// 9.添加xxx字段小于value条件
criteria.andXxxLessThan(value)
// 10.添加xxx字段小于等于value条件
criteria.andXxxLessThanOrEqualTo(value)
// 11.添加xxx字段值在List
criteria.andXxxIn(List)
// 12.不添加xxx字段值在List
criteria.andXxxNotIn(List)
// 13.添加xxx字段值在之间
criteria.andXxxBetween(value1,value2)
// 14.添加xxx字段值不在之间
criteria.andXxxNotBetween(value1,value2)