博客推荐:
Mybatis最入门---代码自动生成(generatorConfig.xml配置)
MyBatis Generator generatorConfig.xml配置详解
pom.xml<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.watermelon</groupId>
<artifactId>Simple</artifactId>
<version>0.0.1-SNAPSHOT</version> <properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties> <dependencies>
<!-- https://mvnrepository.com/artifact/junit/junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.3.0</version>
</dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency> <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-api -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.12</version>
</dependency> <!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-log4j12 -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.12</version>
<scope>test</scope>
</dependency> <!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency> <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<!-- 新增加 -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.3</version>
</dependency> </dependencies> <build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.6</source>
<target>1.6</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
1.java代码生成的方式
<?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>
<context id="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/> <commentGenerator>
<property name="suppressDate" value="true"/>
<property name="addRemarkComments" value="true"/>
</commentGenerator> <jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/simple"
userId="root"
password="123456">
</jdbcConnection> <javaModelGenerator targetPackage="test.model"
targetProject="src\main\java">
<property name="trimStrings" value="true"/>
</javaModelGenerator> <sqlMapGenerator targetPackage="test.xml"
targetProject="src\main\resources">
</sqlMapGenerator> <javaClientGenerator type="XMLMAPPER"
targetPackage="test.dao"
targetProject="src\main\java">
</javaClientGenerator> <table tableName="%">
<generatedKey column="id" sqlStatement="MySql"/>
</table>
</context>
</generatorConfiguration>
package com.watermelon.generator; import java.io.IOException;
import java.io.InputStream;
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.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback; public class Generator {
public static void main(String[] args) throws Exception, XMLParserException {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
InputStream is = Generator.class.getResourceAsStream("/generator/generatorConfig.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(is);
is.close(); DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator mybatisGenerator = new MyBatisGenerator(config, callback, warnings);
mybatisGenerator.generate(null);
for(String warning:warnings) {
System.out.println(warning);
}
}
}
2.Eclispe插件的方式(推荐使用)
优点;在所有生成的代码中都会有@mbggenerated 标记(通过MBG生成) 但是不管是maven,还是java main方法的方式运行生成的代码,
重新生成后都会覆盖中间自己修改的代码。只有Eclispe插件的方式才不会修改。
插件下载地址https://github.com/mybatis/generator/releases
<?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>
<!-- eclipse生成时必须指定classPathEntry 物理数据库驱动电脑上面可以随意指定一个 -->
<classPathEntry location="E:\java\jar\mysql\mysql-connector-java-5.1.18-bin.jar"/>
<context id="MySqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
<!-- 在关键字名称前后自动拼接` -->
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/> <property name="javaFileEncoding" value="UTF-8"/> <!-- 加注释 ,suppressDate去掉时间-->
<commentGenerator>
<property name="suppressDate" value="true"/>
<property name="addRemarkComments" value="true"/>
</commentGenerator> <!-- 配置数据库连接 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/simple"
userId="root"
password="123456">
</jdbcConnection> <!-- eclipse插件生成时必须targetProject前加项目名称 -->
<!-- 生成Model -->
<javaModelGenerator targetPackage="test.model"
targetProject="Simple\src\main\java">
<!--去掉多余的空格
public void setUserName(String userName) {
this.userName = userName == null ? null : userName.trim();
} -->
<property name="trimStrings" value="true"/>
</javaModelGenerator> <!-- 生成Mapper xml文件 -->
<sqlMapGenerator targetPackage="test.xml"
targetProject="Simple\src\main\resources">
</sqlMapGenerator> <!-- 生成对应的dao文件 -->
<javaClientGenerator type="XMLMAPPER"
targetPackage="test.dao"
targetProject="Simple\src\main\java">
</javaClientGenerator> <!-- tableName 生成的表名“%”多个表 -->
<table tableName="%">
<generatedKey column="id" sqlStatement="MySql"/>
</table>
</context>
</generatorConfiguration>
在配置文件上面单机右键运行。