Mybatis逆向生成工具

依赖包：

mysql --connector -- java -5.1.28-bin.jar

log4j-1.2.16.jar 

mybatis-3.2.3.jar

mybatis-generator-core-1.3.2.jar

 

log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

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 Main {

	public static void main(String[] args) throws Exception {
		
		List<String> warnings = new ArrayList<String>();
		boolean overwrite = true;
		File configFile = new File("src/mybatisGeneratorConfig.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);
		
	}
	
}

 

mybatisGeneratorConfig.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>

	<!-- id随便取名 -->
	<context id="mysqlTables" targetRuntime="MyBatis3">

		<!-- 去掉注释： 其中suppressDate是去掉生成日期那行注释，suppressAllComments是去掉所有的注解； -->
		<commentGenerator>
			<property name="suppressDate" value="true" />
			<property name="suppressAllComments" value="true" />
		</commentGenerator>


		<!--################################################### -->
		<!-- 根据实际情况更改jdbc的四大属性值 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost:3306/manage" 
			userId="root"
			password="mysql">
		</jdbcConnection>

		<!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 
			和 NUMERIC 类型解析为java.math.BigDecimal -->
		<javaTypeResolver>
			<property name="forceBigDecimals" value="false" />
		</javaTypeResolver>


		<!-- targetProject:生成PO类的位置 -->
		<javaModelGenerator targetPackage="cn.manage.entity"
			targetProject=".\src">

			<!-- enableSubPackages:是否让schema作为包的后缀 -->
			<property name="enableSubPackages" value="true" />

			<!-- 从数据库返回的值被清理前后的空格 -->
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!-- targetProject:mapper映射文件生成的位置 (mapper.xml) -->
		<sqlMapGenerator targetPackage="cn.manage.mapper"
			targetProject=".\src">

			<!-- enableSubPackages:是否让schema作为包的后缀 -->
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!-- targetPackage：mapper接口生成的位置(mapper.java) -->
		<javaClientGenerator type="XMLMAPPER"
			targetPackage="cn.manage.mapper" targetProject=".\src">

			<!-- enableSubPackages:是否让schema作为包的后缀 -->
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>


        <!-- 简单写法-->
        <table tableName="表名称" domainObjectName="POJO名称" >


		<!-- 加上下面这段就不会生成注释和多余的代码
			schema="general" 
			enableCountByExample="false" enableUpdateByExample="false" 
			enableDeleteByExample="false" enableSelectByExample="false" 
			selectByExampleQueryId="false"
		-->
		
		<table tableName="t_user" domainObjectName="SysUser" schema="general" 
			enableCountByExample="false" enableUpdateByExample="false" 
			enableDeleteByExample="false" enableSelectByExample="false" 
			selectByExampleQueryId="false"> 
			<columnOverride column="id" property="id" /> 
			<columnOverride column="name" property="name" /> 
			<columnOverride column="password" property="password" /> 
			<columnOverride column="salt" property="salt" /> 
			<columnOverride column="status" property="status" /> 
			<columnOverride column="mobile" property="mobile" /> 
			<columnOverride column="email" property="email" /> 
			<columnOverride column="address" property="address" /> 
			<columnOverride column="create_time" property="createTime" /> 
			<columnOverride column="creator" property="creator" /> 
			<columnOverride column="update_time" property="updateTime" /> 
			<columnOverride column="updator" property="updator" /> 
			<columnOverride column="last_modify_password" property="lastModifyPassword" /> 
			<columnOverride column="remark" property="remark" /> 
		</table> 

	</context>
</generatorConfiguration>