mybatis-generator自动生成mapper


1、pom.xml里加入依赖及插件配置

 1         
 2         <dependency>
 3             <groupId>mysqlgroupId>
 4             <artifactId>mysql-connector-javaartifactId>
 5             <version>5.1.13version>
 6         dependency>
 7         
 8         <dependency>
 9             <groupId>org.mybatisgroupId>
10             <artifactId>mybatisartifactId>
11             <version>3.4.2version>
12         dependency>
13         <dependency>
14             <groupId>org.mybatisgroupId>
15             <artifactId>mybatis-springartifactId>
16             <version>1.3.1version>
17         dependency>
 1 <build>
 2         
 3         <resources>
 4             <resource>
 5                 <directory>${basedir}/src/main/javadirectory>
 6             resource>
 7         resources>
 8         <plugins>
 9             
10             <plugin>
11             <groupId>org.mybatis.generatorgroupId>
12             <artifactId>mybatis-generator-maven-pluginartifactId>
13             <version>1.3.2version>
14             <configuration>
15                 
16                 <configurationFile>src/main/resources/generatorConfig.xmlconfigurationFile>
17                 <verbose>trueverbose>
18                 <overwrite>trueoverwrite>
19             configuration>
20             <executions>
21                 <execution>
22                     <id>Generate MyBatis Artifactsid>
23                     <goals>
24                         <goal>generategoal>
25                     goals>
26                 execution>
27             executions>
28             <dependencies>
29                 <dependency>
30                     <groupId>org.mybatis.generatorgroupId>
31                     <artifactId>mybatis-generator-coreartifactId>
32                     <version>1.3.2version>
33                 dependency>
34             dependencies>
35             plugin>
36         plugins>
37     build>

2、generatorConfig.xml文件(放在src/main/resources目录下)

 1<?xml version="1.0" encoding="UTF-8"?>

 2 DOCTYPE generatorConfiguration
 3         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
 4         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
 5 
 6 <generatorConfiguration>
 7     
 8     <classPathEntry location="/Users/apple/.m2/repository/mysql/mysql-connector-java/5.1.13/mysql-connector-java-5.1.13.jar" />
 9 
10     <context id="mysql_tables" targetRuntime="MyBatis3">
11         
12         <commentGenerator>
13             <property name="suppressAllComments" value="true" />
14             <property name="suppressDate" value="true" />
15         commentGenerator>
16 
17         
18         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
19                         connectionURL=""
20                         userId=""
21                         password="">
22         jdbcConnection>
23         
24         <javaTypeResolver >
25             <property name="forceBigDecimals" value="false" />
26         javaTypeResolver>
27 
28         
29         <javaModelGenerator targetPackage="com.xxx.po" targetProject="src/main/java">
30             <property name="enableSubPackages" value="true" />
31             <property name="trimStrings" value="true" />
32         javaModelGenerator>
33 
34         
35         <sqlMapGenerator targetPackage="mapper"  targetProject="src/main/resources">
36             <property name="enableSubPackages" value="true" />
37         sqlMapGenerator>
38 
39         
40         <javaClientGenerator type="XMLMAPPER" targetPackage="com.xxx.dao"  targetProject="src/main/java">
41             <property name="enableSubPackages" value="true" />
42         javaClientGenerator>
43 
44         
45         <table tableName="xxx" domainObjectName="xxx"/>
46     context>
47 generatorConfiguration>