Mybatis逆向工程自动生成代码

最新推荐文章于 2019-07-30 10:23:39 发布

零下几度寒

最新推荐文章于 2019-07-30 10:23:39 发布

阅读量358

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/lichuang2012/article/details/51537444

版权

java 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

创建工程，所需要的jar包：

mybatis-3.2.7.jar

mybatis-generator-core-1.3.2.jar

mysql-connector-java-5.1.25-bin.jar

目录结构：

生成代码配置文件：generatorConfig.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>
	<!-- 数据库驱动 -->
	<classPathEntry location="lib/mysql-connector-java-5.1.25-bin.jar" />
	<context id="DB2Tables" targetRuntime="MyBatis3">
		<commentGenerator>
			<property name="suppressDate" value="true" />
			<!-- 是否去除自动生成的注释 true：是 ： false:否 -->
			<property name="suppressAllComments" value="true" />
		</commentGenerator>

		<!--数据库链接URL，用户名、密码 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost/zg_db" userId="root" password="root">
		</jdbcConnection>

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

		<!-- 生成模型的包名和位置 -->
		<javaModelGenerator targetPackage="com.zg.entity"
			targetProject="D:\Workspaces\MyEclipse 10\mybatis-generator\src\">
			<property name="enableSubPackages" value="true" />
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!-- 生成映射文件的包名和位置 -->
		<sqlMapGenerator targetPackage="com.zg.server.mapper"
			targetProject="D:\Workspaces\MyEclipse 10\mybatis-generator\src\">
			<property name="enableSubPackages" value="true" />
		</sqlMapGenerator>

		<!-- 生成DAO的包名和位置 -->
		<javaClientGenerator type="XMLMAPPER"
			targetPackage="com.zg.server.mapper" targetProject="D:\Workspaces\MyEclipse 10\mybatis-generator\src\">
			<property name="enableSubPackages" value="true" />
		</javaClientGenerator>

		<!-- 要生成的表 tableName是数据库中的表名或视图名 domainObjectName是实体类名 -->
		<table tableName="config" domainObjectName="Config"
			enableCountByExample="false" enableUpdateByExample="false"
			enableDeleteByExample="false" enableSelectByExample="false"
			selectByExampleQueryId="false"></table>

	</context>
</generatorConfiguration>

执行生成程序：generatorSqlMap.java

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) {
		generatorSqlMap sqlMap = new generatorSqlMap();
		try {
			sqlMap.generator();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}