MyBatis Generator工具使用:根据数据库表生成实体类、SQL定义文件、Mapper接口。

529 阅读1分钟

1. pom.xml导入mybatis、mybatis-generator-core、以及MySQL驱动包。

<dependencies>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.6</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis.generator</groupId>
			<artifactId>mybatis-generator-core</artifactId>
			<version>1.3.5</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.46</version>
		</dependency>
</dependencies>

2,在项目根目录下添加一个mybatis-generator配置文件

<?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="C:\Users\mysql-connector-java-5.1.43.jar" />
	
	  <context id="DB2Tables" targetRuntime="MyBatis3">
		<!-- 指定连接参数 -->
		<jdbcConnection driverClass="com.mysql.jdbc.Driver"
			connectionURL="jdbc:mysql://localhost:3306/****"    <!--设置数据库-->
			userId="root"
			password="11111111">
		</jdbcConnection>
	
		<!-- 指定entity类位置 -->
		<javaModelGenerator targetPackage="ovls.entity" targetProject=".\src\main\java">
		  <property name="enableSubPackages" value="true" />
		  <property name="trimStrings" value="true" />
		</javaModelGenerator>
	
		<!-- 指定sql xml位置 -->
		<sqlMapGenerator targetPackage="sql"  targetProject=".\src\main\resources">
		  <property name="enableSubPackages" value="true" />
		</sqlMapGenerator>
	
		<!-- 指定Mapper接口位置 -->
		<javaClientGenerator type="ANNOTATEDMAPPER" targetPackage="***.dao"  targetProject=".\src\main\java">
		  <property name="enableSubPackages" value="true" />
		</javaClientGenerator>
	
		<!-- 指定根据数据哪些表生成上面元素 -->
		<table  tableName="%" enableCountByExample="false" 
			enableDeleteByExample="false" enableSelectByExample="false"
			enableUpdateByExample="false">
		</table>
	
	  </context>
</generatorConfiguration>

3,加载相关配置文件执行生成

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

运行该类,OK。