项目目录

- dao 存放mapper.java文件
- models 存放生成的数据库表model
- resources目录下的mapperXML存放生成的.xml文件
配置详情
maven配置
properties标签内添加对应版本
1 2 3 4
| <mybatis.version>3.3.0</mybatis.version> <mybatis-spring.version>1.2.0</mybatis-spring.version>
<mybatis_pagehelper_version>4.1.6</mybatis_pagehelper_version>
|
dependencies标签内添加
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>${mybatis-spring.version}</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>${mybatis_pagehelper_version}</version> </dependency>
|
build标签的子标签plugins内添加
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.2</version> <configuration> <verbose>true</verbose> <overwrite>true</overwrite> <configurationFile>./src/main/resources/generatorConfig.xml </configurationFile> </configuration> <dependencies> <dependency> <groupId>org.postgresql</groupId> <artifactId>postgresql</artifactId> <version>9.4.1208</version> </dependency> </dependencies> </plugin>
|
generatorConfig.xml配置
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| <?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="application.properties"/> <context id="context1" targetRuntime="MyBatis3"> <property name="suppressTypeWarnings" value="true"/>
<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/> <plugin type="org.mybatis.generator.plugins.CaseInsensitiveLikePlugin"/> <plugin type="org.mybatis.generator.plugins.ToStringPlugin"/>
<commentGenerator> <property name="suppressAllComments" value="true"/> <property name="suppressDate" value="true"/> </commentGenerator>
<jdbcConnection driverClass="${datasource.driverClass}" connectionURL="${datasource.url}" userId="${datasource.username}" password="${datasource.password}"> </jdbcConnection>
<javaTypeResolver> <property name="forceBigDecimals" value="false"/> </javaTypeResolver>
<javaModelGenerator targetPackage="com.ppmon.qa.models" targetProject="${project}"> <property name="enableSubPackages" value="false"/> <property name="trimStrings" value="true"/> <property name="isMergeable" value="false"/> </javaModelGenerator>
<sqlMapGenerator targetPackage="mapperXML" targetProject="${project_sources}"> <property name="enableSubPackages" value="false"/> </sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER" targetPackage="com.ppmon.qa.dao" targetProject="${project}"> <property name="enableSubPackages" value="false"/> </javaClientGenerator> <table schema="" tableName="user_info" domainObjectName="UserInfo" modelType="flat" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"> </table> </context> </generatorConfiguration>
|
application.properties配置
这里面的配置变量会在generatorConfig.xml中使用到
1 2 3 4 5 6 7
| datasource.url=jdbc:postgresql://1xx.xx.xx.xx:5432/database_name?characterEncoding#UTF-8 datasource.username=username datasource.password=password datasource.driverClass=org.postgresql.Driver
project=./src/main/java project_sources=./src/main/resources
|
生成代码文件和xml文件
选择idea右侧的maven,点击刷新,再找到mybatis-generator双击mybatis-generator:generate

生成后的样子

遇到的问题
- 点击生成后,一直提示找不到路径E:\gauge_java\silvergrd\silvergrd-gauge\src\main\resources,处理方法:src子目录下名字本是test,改为main即可。 但是为什么要去寻找main目录,尚未找到答案。
- 提示找不到generatorConfig.xml文件,处理方法:在maven的pom文件内,指定正确的generatorConfig.xml路径。请看maven配置的configurationFile一行。
- 生成的XML文件与我期望的不匹配,处理方法:generatorConfig.xml文件内配置的targetProject不对
如下:
1 2 3
| <sqlMapGenerator targetPackage="mapperXML" targetProject="${project_sources}"> <property name="enableSubPackages" value="false"/> </sqlMapGenerator>
|
参考出处
mybatis官网
csdn文章1-作者:兮风
csdn文章2-作者:橙子wj
cnblog文章-作者:梦见舟