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>