mybatis-generator

mybatis-generator

官网概要

• 快速开始

命令行

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

MyBatis3DynamicSql

• 无xml配置文件
  • 多一个mapper的sql动态支持类，mapper大量使用java8的函数式编程，相对mybatis-plus未封装进独立jar包
• 生成代码的xml配置文件

<!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="mysql-connector-java-8.0.21.jar"/>
  <context id="dsql" targetRuntime="MyBatis3DynamicSql">
    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
        connectionURL="jdbc:mysql://****:3306/***?useUnicode=true&amp;characterEncoding=UTF-8" userId="root" password="***"/>

    <javaModelGenerator targetPackage="com.yzsoft.orm.fa" targetProject="java">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>
<!-- 这个无效
    <sqlMapGenerator targetPackage="com.yzsoft.dao.fa"  targetProject="resources">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>
-- >
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.yzsoft.dao.fa"  targetProject="java">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

    <table tableName="project_fa" domainObjectName="ProjectFaEntity"/>
  </context>
</generatorConfiguration>

MyBatis3Kotlin

• 针对Kotlin语言，略

MyBatis3

• 有xml的配置
• 老版的mapper，entity；example可配置，可能有单独主键对象或BLOB

<!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="mysql-connector-java-8.0.21.jar"/>
  <context id="dsql" targetRuntime="MyBatis3" defaultModelType="flat">
    
    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
        connectionURL="jdbc:mysql://***:3306/**?useUnicode=true&amp;characterEncoding=UTF-8" userId="root" password="***"/>

    <javaModelGenerator targetPackage="com.yzsoft.orm.fa" targetProject="java">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="false" />
    </javaModelGenerator>

    <sqlMapGenerator targetPackage="com.yzsoft.dao.fa"  targetProject="resources">
      <property name="enableSubPackages" value="false" />
    </sqlMapGenerator>

    <javaClientGenerator type="XMLMAPPER" targetPackage="com.yzsoft.dao.fa"  targetProject="java">
      <property name="enableSubPackages" value="false" />
    </javaClientGenerator>

    <table tableName="project_fa" mapperName="ProjectFaMapper" enableDeleteByExample="false" enableCountByExample="false" enableUpdateByExample="false" enableSelectByExample="false">
      <domainObjectRenamingRule searchString="^(\w+)" replaceString="$1Entity"/>
    </table>
  </context>
</generatorConfiguration>

MyBatis3Simple

• 有xml的配置
• 没有selective的方法

mybatis-generator的xml配置文件

• 官网