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>

  1. 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
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • 老妹过来玩,真是让我见识了她手机上吉萌app的强大,让你瘦一圈,白两圈,自带化妆美颜,哈哈哈哈,永远十八岁。
    健身妖妖阅读 2,773评论 0 1
  • 现代人对等待这件事的容忍度真的很低,下午跑去理发,要排队等,坐了2分钟我走了;去加油站圈存想顺便加个油,要排队等,...
    4aa2b8b6ec3d阅读 4,245评论 1 51
  • Day4 13-7-2017 亲爱的老公,看到你很努力去做新的项目,祝福你!
    JennyMo阅读 1,222评论 0 0
  • 最近的睡眠有些混乱,总是在睡不着和睡不醒,老是后者也还好,至少不用瞪着眼睛等天亮,当然若是能刚刚好那就再好...
    李劲静阅读 1,885评论 1 0