准备条件：
将下面的文件放入同一目录下
操作步骤：
1/ 在 generatorConfig.xml 中配置相关的参数，与需要被自动生成的表
也可以 执行项目中的MybatisConfigAutoGen.java 将得到的结果复制过来 替换当前文档的内容
2/ 打开cmd 窗口，进入当前文件夹下，执行命令：
java -jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml -overwrite
3/ 将src 中的文件复制到 项目对应的目录下即可根据实际来修改
附：
1/ generatorConfig.xml 的内容为：(下面的配置文件是对应Oracle数据库）
<?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="ojdbc7.jar"/>
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressDate" value="true"/>
<property name="suppressAllComments" value="true"/>
</commentGenerator>
<jdbcConnection driverClass="oracle.jdbc.OracleDriver" connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:ORCL" userId="panie" password="panie123">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>
<javaModelGenerator targetPackage="com.panie.modules.configure.entity" targetProject="src">
<property name="enableSubPackages" value="true"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>
<sqlMapGenerator targetPackage="mappings.com.panie.modules.configure" targetProject="src">
<property name="enableSubPackages" value="true"/>
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER" targetPackage="com.panie.modules.configure.dao" targetProject="src">
<property name="enableSubPackages" value="true"/>
</javaClientGenerator>
<table tableName="BPMP_VERSION" domainObjectName="BpmpVersion" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> </context>
</generatorConfiguration>
2/ 使用Java 代码 遍历 ORACLE ，生成可用的配置
package com.panie.common.utils;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class MybatisConfigAutoGen
{ public static String jdbcDriver = "oracle.jdbc.OracleDriver";
public static String jdbcUrl = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
public static String jdbcUser = "panie";
public static String jdbcPassword = "panie123";
public static String newline = "\r\n";
public static String tableKey = "BPMP_VERSION"; public static String driverJar = "ojdbc7.jar";//所使用驱动包 public static String entityPkg = "com.panie.modules.configure.entity";
public static String mappingPkg = "mappings.com.panie.modules.configure";
public static String daoPkg = "com.panie.modules.configure.dao"; public static String genConfig()
{
StringBuilder sb = new StringBuilder();
sb.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>").append(newline);
sb.append("<!DOCTYPE generatorConfiguration PUBLIC \"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN\" ").append(newline);
sb.append("\"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd\"> ").append(newline);
sb.append("<generatorConfiguration>").append(newline);
sb.append(" <classPathEntry location=\"").append(driverJar).append("\"/> ").append(newline);
sb.append(" <context id=\"DB2Tables\" targetRuntime=\"MyBatis3\">").append(newline);
sb.append(" <commentGenerator>").append(newline);
sb.append(" <property name=\"suppressDate\" value=\"true\"/>").append(newline);
sb.append(" <property name=\"suppressAllComments\" value=\"true\"/> ").append(newline);
sb.append(" </commentGenerator>").append(newline);
sb.append(" <jdbcConnection driverClass=\"").append(jdbcDriver).append("\" connectionURL=\"").append(jdbcUrl).append("\" userId=\"").append(jdbcUser).append("\" password=\"").append(jdbcPassword).append("\"> ").append(newline);
sb.append(" </jdbcConnection>").append(newline);
sb.append(" <javaTypeResolver> ").append(newline);
sb.append(" <property name=\"forceBigDecimals\" value=\"false\"/> ").append(newline);
sb.append(" </javaTypeResolver>").append(newline);
sb.append(" <javaModelGenerator targetPackage=\"").append(entityPkg).append("\" targetProject=\"src\"> ").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/> ").append(newline);
sb.append(" <property name=\"trimStrings\" value=\"true\"/>").append(newline);
sb.append(" </javaModelGenerator> ").append(newline);
sb.append(" <sqlMapGenerator targetPackage=\"").append(mappingPkg).append("\" targetProject=\"src\">").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/>").append(newline);
sb.append(" </sqlMapGenerator>").append(newline);
sb.append(" <javaClientGenerator type=\"XMLMAPPER\" targetPackage=\"").append(daoPkg).append("\" targetProject=\"src\"> ").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/> ").append(newline);
sb.append(" </javaClientGenerator> ").append(newline);
sb.append(genDbTable()).append(newline);
sb.append(" </context>").append(newline); sb.append("</generatorConfiguration>").append(newline);
return sb.toString(); } public static String genDbTable()
{ StringBuilder sb = new StringBuilder();
Connection conn = null;
Statement stmt; //创建声明
try
{
Class.forName(jdbcDriver);
conn = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword); stmt = conn.createStatement();
ResultSet res = stmt.executeQuery("select * from user_tab_comments");
while(res.next())
{
String tablename = res.getString(1);
String tabletype = res.getString(2);
if(tabletype.equals("TABLE")&&tablename.indexOf(tableKey)!=-1)
{
sb.append("<table tableName=\"");
sb.append(tablename);
sb.append("\" domainObjectName=\"");
sb.append(StringUtils.toCapitalizeCamelCase(tablename));
sb.append("\" enableCountByExample=\"false\" enableUpdateByExample=\"false\" enableDeleteByExample=\"false\" enableSelectByExample=\"false\" selectByExampleQueryId=\"false\"></table>").append(newline); }
} } catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} finally
{
if (conn != null)
{
try
{
conn.close();
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} return sb.toString(); } public static void main(String[] args)
{
System.out.println(genConfig());
}
}
3/ 使用Java 代码 遍历 MYSQL，生成可用的配置
package com.panie.common.utils;import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class MybatisConfigAutoGen
{ public static String jdbcDriver = "com.mysql.jdbc.Driver";
public static String jdbcUrl = "jdbc:mysql://localhost:3306/blogdb?useUnicode=true&characterEncoding=utf-8";
public static String jdbcUser = "root";
public static String jdbcPassword = "123456";
public static String newline = "\r\n";
public static String tableKey = "sys_"; public static String driverJar = "mysql-connector-java-5.1.38.jar";//所使用驱动包 public static String entityPkg = "com.panie.modules.sys.entity";
public static String mappingPkg = "mappings.com.panie.sys.configure";
public static String daoPkg = "com.panie.modules.sys.dao"; public static String genConfig()
{
StringBuilder sb = new StringBuilder();
sb.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>").append(newline);
sb.append("<!DOCTYPE generatorConfiguration PUBLIC \"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN\" ").append(newline);
sb.append("\"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd\"> ").append(newline);
sb.append("<generatorConfiguration>").append(newline);
sb.append(" <classPathEntry location=\"").append(driverJar).append("\"/> ").append(newline);
sb.append(" <context id=\"DB2Tables\" targetRuntime=\"MyBatis3\">").append(newline);
sb.append(" <commentGenerator>").append(newline);
sb.append(" <property name=\"suppressDate\" value=\"true\"/>").append(newline);
sb.append(" <property name=\"suppressAllComments\" value=\"true\"/> ").append(newline);
sb.append(" </commentGenerator>").append(newline);
sb.append(" <jdbcConnection driverClass=\"").append(jdbcDriver).append("\" connectionURL=\"").append(jdbcUrl).append("\" userId=\"").append(jdbcUser).append("\" password=\"").append(jdbcPassword).append("\"> ").append(newline);
sb.append(" </jdbcConnection>").append(newline);
sb.append(" <javaTypeResolver> ").append(newline);
sb.append(" <property name=\"forceBigDecimals\" value=\"false\"/> ").append(newline);
sb.append(" </javaTypeResolver>").append(newline);
sb.append(" <javaModelGenerator targetPackage=\"").append(entityPkg).append("\" targetProject=\"src\"> ").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/> ").append(newline);
sb.append(" <property name=\"trimStrings\" value=\"true\"/>").append(newline);
sb.append(" </javaModelGenerator> ").append(newline);
sb.append(" <sqlMapGenerator targetPackage=\"").append(mappingPkg).append("\" targetProject=\"src\">").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/>").append(newline);
sb.append(" </sqlMapGenerator>").append(newline);
sb.append(" <javaClientGenerator type=\"XMLMAPPER\" targetPackage=\"").append(daoPkg).append("\" targetProject=\"src\"> ").append(newline);
sb.append(" <property name=\"enableSubPackages\" value=\"true\"/> ").append(newline);
sb.append(" </javaClientGenerator> ").append(newline);
sb.append(genDbTable()).append(newline);
sb.append(" </context>").append(newline); sb.append("</generatorConfiguration>").append(newline);
return sb.toString(); } public static String genDbTable()
{ StringBuilder sb = new StringBuilder();
Connection conn = null;
Statement stmt; //创建声明
try
{
Class.forName(jdbcDriver);
conn = DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword);
DatabaseMetaData metadata = conn.getMetaData();
ResultSet res = metadata.getTables("blogdb", null, null, null);
while(res.next())
{
String tablename = res.getString(3);
String tabletype = res.getString(4);
if(tabletype.equals("TABLE")&&tablename.toLowerCase().indexOf(tableKey)!=-1)
{
sb.append("<table tableName=\"");
sb.append(tablename);
sb.append("\" domainObjectName=\"");
sb.append(StringUtils.toCapitalizeCamelCase(tablename));
sb.append("\" enableCountByExample=\"false\" enableUpdateByExample=\"false\" enableDeleteByExample=\"false\" enableSelectByExample=\"false\" selectByExampleQueryId=\"false\"></table>").append(newline); }
} } catch (Exception e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} finally
{
if (conn != null)
{
try
{
conn.close();
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} return sb.toString(); } public static void main(String[] args)
{
System.out.println(genConfig());
}
}
