mybatis使用generator自動生成代碼

1.在maven工程中的resource目錄中建立generatorConfig.xml文件

ggg.png
2.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>

<properties resource="generator/mybatisGeneratorinit.properties"/>
<context id="MysqlTables" targetRuntime="MyBatis3Simple" defaultModelType="flat">

<property name="autoDelimitKeywords" value="true"/>

<property name="javaFileEncoding" value="utf-8"/>

<property name="beginningDelimiter" value=""/> <property name="endingDelimiter" value=""/>

<property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>

<property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
<plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>

<commentGenerator>
<property name="suppressAllComments" value="false"/>
<property name="suppressDate" value="true"/>
</commentGenerator>

<jdbcConnection driverClass="${jdbc_driver}"
connectionURL="${jdbc_url}"
userId="${jdbc_user}"
password="${jdbc_password}"/>

<javaTypeResolver>

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

<javaModelGenerator targetPackage="com.huangxiaobin.personproject.demo.model"
targetProject="${project}">
<property name="enableSubPackages" value="false"/>
<property name="trimStrings" value="true"/>
</javaModelGenerator>

<sqlMapGenerator targetPackage="mappers" targetProject="${resources}">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>

<javaClientGenerator targetPackage="com.huangxiaobin.personproject.demo.dao"
targetProject="${project}"
type="XMLMAPPER">
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>

<table tableName="UserInfo" enableCountByExample="true" enableUpdateByExample="true"
enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true">
<property name="useActualColumnNames" value="false"/>

<generatedKey column="id" sqlStatement="Mysql" identity="true"/>
</table>
</context>
</generatorConfiguration>

3. application.propertis（對於mybatis的配置） 的編寫

   
   image.png
   

   4.配置pom.xml （generator 插件的編寫）
   <plugins>
   
   <plugin>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-maven-plugin</artifactId>
   <executions>
   <execution>
   <id>Generate MyBatis Artifacts</id>
   <goals>
   <goal>generate</goal>
   </goals>
   </execution>
   </executions>
   <configuration> <configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>
   <verbose>true</verbose>
   <overwrite>true</overwrite>
   </configuration>
   <dependencies>
   <dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.45</version>
   </dependency>
   <dependency>
   <groupId>org.mybatis.generator</groupId>
   <artifactId>mybatis-generator-core</artifactId>
   <version>1.3.2</version>
   </dependency>
   </dependencies>
   </plugin>
   <plugin>
   5.使用 IDEA 的maven 插件直接快速生成

   
   image.png