mybatis-generator-in-short

github地址  官方文档    官方配置文件示例  运行方式

一个可以参考的配置文件

Mybatis自动生成配置文件和实体

MyBatis Generator 超详细配置,这个是在maven下使用的，对generator配置文件字段进行了详细说明！！！

MyBatis Generator 代码自动生成器

MyBatis逆向工程自动生成代码

Mybatis Generator生成的代码加上想要的注释

以下介绍了MyBatis-Plus 3.4.1 代码生成器 配置demo,感觉MyBatis-plus也需要了解一下。

1). 命令行方式:

https://mybatis.org/generator/running/runningFromCmdLine.html

java -jar mybatis-generator-core-x.x.x.jar -configfile generatorConfig.xml

java -jar mybatis-generator-core-x.x.x.jar -configfile generatorConfig.xml -overwrite

java -cp mybatis-generator-core-x.x.x.jar org.mybatis.generator.api.ShellRunner -configfile generatorConfig.xml

java -cp mybatis-generator-core-x.x.x.jar org.mybatis.generator.api.ShellRunner -configfile generatorConfig.xml -overwrite

2). ant任务

https://mybatis.org/generator/running/runningWithAnt.html

3). maven插件:

https://mybatis.org/generator/running/runningWithMaven.html

maven目标和执行:

mvn mybatis-generator:generate

mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate

4). java程序+xml配置文件:

https://mybatis.org/generator/running/runningWithJava.html

List<String> warnings = new ArrayList<String>();

boolean overwrite = true;

File configFile = new File("generatorConfig.xml");

ConfigurationParser cp = new ConfigurationParser(warnings);

Configuration config = cp.parseConfiguration(configFile);

DefaultShellCallback callback = new DefaultShellCallback(overwrite);

MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);

myBatisGenerator.generate(null);

5). java程序+基于java的配置

https://mybatis.org/generator/running/runningWithJava.html

List<String> warnings = new ArrayList<String>();

boolean overwrite = true;

Configuration config = new Configuration();

// ... fill out the config object as appropriate...

DefaultShellCallback callback = new DefaultShellCallback(overwrite);

MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);

myBatisGenerator.generate(null);

6). eclipse插件

https://mybatis.org/generator/running/runningWithEclipse.html

配置文件示例: 

mybatis3.xml: 

<?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>

<context id="simple" targetRuntime="MyBatis3">

<jdbcConnection driverClass="org.hsqldb.jdbcDriver"

connectionURL="jdbc:hsqldb:mem:aname" />

<javaModelGenerator targetPackage="example.model"

targetProject="src/main/java" />

<sqlMapGenerator targetPackage="example.mapper"

targetProject="src/main/resources" />

<javaClientGenerator type="XMLMAPPER" targetPackage="example.mapper"

targetProject="src/main/java" />

<table tableName="FooTable" />

</context>

</generatorConfiguration>

MyBatis3DynamicSql.xml

<?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>

<context id="dsql" targetRuntime="MyBatis3DynamicSql">

<jdbcConnection driverClass="org.hsqldb.jdbcDriver"

connectionURL="jdbc:hsqldb:mem:aname" />

<javaModelGenerator targetPackage="example.model"

targetProject="src/main/java" />

<javaClientGenerator targetPackage="example.mapper"

targetProject="src/main/java" />

<table tableName="FooTable" />

</context>

</generatorConfiguration>

MyBatis3Simple.xml: 

<?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>

<context id="simple" targetRuntime="MyBatis3Simple">

<jdbcConnection driverClass="org.hsqldb.jdbcDriver"

connectionURL="jdbc:hsqldb:mem:aname" />

<javaModelGenerator targetPackage="example.model"

targetProject="src/main/java" />

<javaClientGenerator type="ANNOTATEDMAPPER"

targetPackage="example.mapper" targetProject="src/main/java" />

<table tableName="FooTable" />

</context>

</generatorConfiguration>

MyBatis3Kotlin.xml

<?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>

<context id="kotlin" targetRuntime="MyBatis3Kotlin">

<jdbcConnection driverClass="org.hsqldb.jdbcDriver"

connectionURL="jdbc:hsqldb:mem:aname" />

<javaModelGenerator targetPackage="example.model"

targetProject="src/main/kotlin" />

<javaClientGenerator targetPackage="example.mapper"

targetProject="src/main/kotlin" />

<table tableName="FooTable" />

</context>

</generatorConfiguration>

根据一个可以参考的配置文件一文，更详细的一种配置如下： 

<?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>

<!-- 数据库驱动包位置 -->

<classPathEntry location="D:\generator\mysql-connector-java-5.1.34.jar" />

<!-- <classPathEntry location="C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar" />-->

<context id="DB2Tables" targetRuntime="MyBatis3">

<commentGenerator>

            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->

<property name="suppressAllComments" value="true" />

</commentGenerator>

<!-- 数据库链接URL、用户名、密码 -->

<jdbcConnection driverClass="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://localhost:3306/shop" userId="root"

password="12345">

<!--<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="msa" password="msa">-->

</jdbcConnection>

<javaTypeResolver>

<property name="forceBigDecimals" value="false" />

</javaTypeResolver>

<!-- 生成模型的包名和位置 -->

<javaModelGenerator targetPackage="andy.model"

targetProject="D:\generator\src">

<property name="enableSubPackages" value="true" />

<property name="trimStrings" value="true" />

</javaModelGenerator>

<!-- 生成的映射文件包名和位置 -->

<sqlMapGenerator targetPackage="andy.mapping"

targetProject="D:\generator\src">

<property name="enableSubPackages" value="true" />

</sqlMapGenerator>

<!-- 生成DAO的包名和位置 -->

<javaClientGenerator type="XMLMAPPER" targetPackage="andy.dao"

targetProject="D:\generator\src">

<property name="enableSubPackages" value="true" />

</javaClientGenerator>

<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->

<table tableName="user_info" domainObjectName="UserInfo"

enableCountByExample="false" enableUpdateByExample="false"

enableDeleteByExample="false" enableSelectByExample="false"

selectByExampleQueryId="false" />

<table tableName="course_info" domainObjectName="CourseInfo"

enableCountByExample="false" enableUpdateByExample="false"

enableDeleteByExample="false" enableSelectByExample="false"

selectByExampleQueryId="false" />

<table tableName="course_user_info" domainObjectName="CourseUserInfo"

enableCountByExample="false" enableUpdateByExample="false"

enableDeleteByExample="false" enableSelectByExample="false"

selectByExampleQueryId="false" />

</context>

</generatorConfiguration>

需要修改对应数据库的驱动文件位置、数据库名密码；

设置对应的生成表的表名以及对应的类名，运行如下命令，

java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite

这样就自动生成了model，dao，mappding配置文件

自行修改了一下: 

<?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>

<!-- 数据库驱动包位置 -->

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

<context id="MySQLTables" targetRuntime="MyBatis3">

<commentGenerator>

            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->

<property name="suppressAllComments" value="true" />

</commentGenerator>

<!-- 数据库链接URL、用户名、密码 -->

<jdbcConnection driverClass="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://localhost:3306/test?useSSL=false" userId="root"

password="12345">

</jdbcConnection>

<javaTypeResolver>

<property name="forceBigDecimals" value="false" />

</javaTypeResolver>

<!-- 生成模型的包名和位置 -->

<javaModelGenerator targetPackage="com.ali.model"

targetProject="E:\data\mbg\src">

<property name="enableSubPackages" value="true" />

<property name="trimStrings" value="true" />

</javaModelGenerator>

<!-- 生成的映射文件包名和位置 -->

<sqlMapGenerator targetPackage="com.ali.mapping"

targetProject="E:\data\mbg\src">

<property name="enableSubPackages" value="true" />

</sqlMapGenerator>

<!-- 生成DAO的包名和位置 -->

<javaClientGenerator type="XMLMAPPER" targetPackage="com.ali.mapper"

targetProject="E:\data\mbg\src">

<property name="enableSubPackages" value="true" />

</javaClientGenerator>

<!-- 要生成那些表(更改tableName和domainObjectName就可以) -->

<table tableName="user_info" domainObjectName="UserInfo"

enableCountByExample="false" enableUpdateByExample="false"

enableDeleteByExample="false" enableSelectByExample="false"

selectByExampleQueryId="false" />

</context>

</generatorConfiguration>

注意：mysql驱动链接需要增加useSSL参数，否则会报错，如下：

Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

生成文件如下: 

UserInfo.java位于: com\ali\model  

package com.ali.model;

public class UserInfo {

    private Integer id;

    private String uid;

    private String name;

    private String city;

    private String province;

    private Byte status;

    public Integer getId() {

        return id;

    }

    public void setId(Integer id) {

        this.id = id;

    }

    public String getUid() {

        return uid;

    }

    public void setUid(String uid) {

        this.uid = uid == null ? null : uid.trim();

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name == null ? null : name.trim();

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city == null ? null : city.trim();

    }

    public String getProvince() {

        return province;

    }

    public void setProvince(String province) {

        this.province = province == null ? null : province.trim();

    }

    public Byte getStatus() {

        return status;

    }

    public void setStatus(Byte status) {

        this.status = status;

    }

}

UserInfoMapper.java: 位于com\ali\mapper

package com.ali.mapper;

import com.ali.model.UserInfo;

public interface UserInfoMapper {

    int deleteByPrimaryKey(Integer id);

    int insert(UserInfo record);

    int insertSelective(UserInfo record);

    UserInfo selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(UserInfo record);

    int updateByPrimaryKey(UserInfo record);

}

UserInfoMapper.xml位于：com\ali\mapping

<?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.ali.mapper.UserInfoMapper">

  <resultMap id="BaseResultMap" type="com.ali.model.UserInfo">

    <id column="id" jdbcType="INTEGER" property="id" />

    <result column="uid" jdbcType="VARCHAR" property="uid" />

    <result column="name" jdbcType="VARCHAR" property="name" />

    <result column="city" jdbcType="VARCHAR" property="city" />

    <result column="province" jdbcType="VARCHAR" property="province" />

    <result column="status" jdbcType="TINYINT" property="status" />

  </resultMap>

  <sql id="Base_Column_List">

    id, uid, name, city, province, status

  </sql>

  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">

    select 

    <include refid="Base_Column_List" />

    from user_info

    where id = #{id,jdbcType=INTEGER}

  </select>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">

    delete from user_info

    where id = #{id,jdbcType=INTEGER}

  </delete>

  <insert id="insert" parameterType="com.ali.model.UserInfo">

    insert into user_info (id, uid, name, 

      city, province, status

      )

    values (#{id,jdbcType=INTEGER}, #{uid,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, 

      #{city,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, #{status,jdbcType=TINYINT}

      )

  </insert>

  <insert id="insertSelective" parameterType="com.ali.model.UserInfo">

    insert into user_info

    <trim prefix="(" suffix=")" suffixOverrides=",">

      <if test="id != null">

        id,

      </if>

      <if test="uid != null">

        uid,

      </if>

      <if test="name != null">

        name,

      </if>

      <if test="city != null">

        city,

      </if>

      <if test="province != null">

        province,

      </if>

      <if test="status != null">

        status,

      </if>

    </trim>

    <trim prefix="values (" suffix=")" suffixOverrides=",">

      <if test="id != null">

        #{id,jdbcType=INTEGER},

      </if>

      <if test="uid != null">

        #{uid,jdbcType=VARCHAR},

      </if>

      <if test="name != null">

        #{name,jdbcType=VARCHAR},

      </if>

      <if test="city != null">

        #{city,jdbcType=VARCHAR},

      </if>

      <if test="province != null">

        #{province,jdbcType=VARCHAR},

      </if>

      <if test="status != null">

        #{status,jdbcType=TINYINT},

      </if>

    </trim>

  </insert>

  <update id="updateByPrimaryKeySelective" parameterType="com.ali.model.UserInfo">

    update user_info

    <set>

      <if test="uid != null">

        uid = #{uid,jdbcType=VARCHAR},

      </if>

      <if test="name != null">

        name = #{name,jdbcType=VARCHAR},

      </if>

      <if test="city != null">

        city = #{city,jdbcType=VARCHAR},

      </if>

      <if test="province != null">

        province = #{province,jdbcType=VARCHAR},

      </if>

      <if test="status != null">

        status = #{status,jdbcType=TINYINT},

      </if>

    </set>

    where id = #{id,jdbcType=INTEGER}

  </update>

  <update id="updateByPrimaryKey" parameterType="com.ali.model.UserInfo">

    update user_info

    set uid = #{uid,jdbcType=VARCHAR},

      name = #{name,jdbcType=VARCHAR},

      city = #{city,jdbcType=VARCHAR},

      province = #{province,jdbcType=VARCHAR},

      status = #{status,jdbcType=TINYINT}

    where id = #{id,jdbcType=INTEGER}

  </update>

</mapper>

根据这篇文章MyBatis逆向工程自动生成代码

使用java程序生成，

配置文件：

<?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> <context id="testTables" targetRuntime="MyBatis3"> <commentGenerator> <!-- 是否去除自动生成的注释 true：是 ： false:否 --> <property name="suppressAllComments" value="true" /> </commentGenerator> <!--数据库连接的信息：驱动类、连接地址、用户名、密码 --> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/mybatis" userId="root" password="liayun"> </jdbcConnection> <!-- <jdbcConnection driverClass="oracle.jdbc.OracleDriver" connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:yycg" userId="yycg" password="yycg"> </jdbcConnection> --> <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和 NUMERIC 类型解析为java.math.BigDecimal --> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <!-- targetProject:生成PO类的位置 --> <javaModelGenerator targetPackage="com.meimeixia.ssm.po" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> <!-- 从数据库返回的值被清理前后的空格 --> <property name="trimStrings" value="true" /> </javaModelGenerator> <!-- targetProject:mapper映射文件生成的位置 --> <sqlMapGenerator targetPackage="com.meimeixia.ssm.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </sqlMapGenerator> <!-- targetPackage：mapper接口生成的位置 --> <javaClientGenerator type="XMLMAPPER" targetPackage="com.meimeixia.ssm.mapper" targetProject=".\src"> <!-- enableSubPackages:是否让schema作为包的后缀 --> <property name="enableSubPackages" value="false" /> </javaClientGenerator> <!-- 指定数据库表 --> <table schema="" tableName="user"></table> <table schema="" tableName="order"></table> <!-- 有些表的字段需要指定java类型 <table schema="" tableName=""> <columnOverride column="" javaType="" /> </table> --> </context> </generatorConfiguration>

<?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>

<context id="testTables" targetRuntime="MyBatis3">

<commentGenerator>

<!-- 是否去除自动生成的注释 true：是 ： false:否 -->

<property name="suppressAllComments" value="true" />

</commentGenerator>

<!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->

<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/mybatis" userId="root" password="liayun">

</jdbcConnection>

<!-- <jdbcConnection driverClass="oracle.jdbc.OracleDriver" connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:yycg" userId="yycg" password="yycg"> </jdbcConnection> -->

<!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和 NUMERIC 类型解析为java.math.BigDecimal -->

<javaTypeResolver>

<property name="forceBigDecimals" value="false" />

</javaTypeResolver>

<!-- targetProject:生成PO类的位置 -->

<javaModelGenerator targetPackage="com.meimeixia.ssm.po" targetProject=".\src">

<!-- enableSubPackages:是否让schema作为包的后缀 -->

<property name="enableSubPackages" value="false" />

<!-- 从数据库返回的值被清理前后的空格 -->

<property name="trimStrings" value="true" />

</javaModelGenerator>

<!-- targetProject:mapper映射文件生成的位置 -->

<sqlMapGenerator targetPackage="com.meimeixia.ssm.mapper" targetProject=".\src">

<!-- enableSubPackages:是否让schema作为包的后缀 -->

<property name="enableSubPackages" value="false" />

</sqlMapGenerator>

<!-- targetPackage：mapper接口生成的位置 -->

<javaClientGenerator type="XMLMAPPER" targetPackage="com.meimeixia.ssm.mapper" targetProject=".\src">

<!-- enableSubPackages:是否让schema作为包的后缀 -->

<property name="enableSubPackages" value="false" />

</javaClientGenerator>

<!-- 指定数据库表 -->

<table schema="" tableName="user"></table>

<table schema="" tableName="order"></table>

<!-- 有些表的字段需要指定java类型 <table schema="" tableName=""> <columnOverride column="" javaType="" /> </table> -->

</context>

</generatorConfiguration>

GeneratorSqlmap.java: 

package generator;

import java.io.File;

import java.util.ArrayList;

import java.util.List;

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;

public class GeneratorSqlmap {

    public void generator() throws Exception {

        List<String> warnings = new ArrayList<String>();

        boolean overwrite = true;

        //指定逆向工程配置文件

        File configFile = new File("generatorConfig.xml");

        ConfigurationParser cp = new ConfigurationParser(warnings);

        Configuration config = cp.parseConfiguration(configFile);

        DefaultShellCallback callback = new DefaultShellCallback(overwrite);

        MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);

        myBatisGenerator.generate(null);

    }

    public static void main(String[] args) throws Exception {

        try {

            GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();

            generatorSqlmap.generator();

        } catch (Exception e) {

            e.printStackTrace();

        }

    }

}