一.配置pom文件
<build>标签下<plugins>内添加
<plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.3</version> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.39</version> </dependency> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.3</version> </dependency> </dependencies> <executions> <execution> <id>Generate MyBatis Artifacts</id> <phase>package</phase> <goals> <goal>generate</goal> </goals> </execution> </executions> <configuration> <skip>false</skip> <!--允许移动生成的文件 --> <verbose>true</verbose> <!-- 是否覆盖 --> <overwrite>true</overwrite> <!-- 自动生成的配置 --> <configurationFile> src/main/resources/generatorConfig.xml </configurationFile> </configuration> </plugin>
指定configurationFile位置 例如: src/main/resources/generatorConfig.xml
注:首次install前将<skip>设置成false,而后改为true防止重复生成
二.添加配置generatorConfig.xml 在刚才pom文件指定的路径下新建generatorConfig.xml文件
设置数据库连接信息、和指定表
指定dao类model类映射文件生成的路径
<?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> <!--数据库驱动--> <context id="mysql" targetRuntime="MyBatis3"> <!-- <properties resource="generatorConfig.properties"/> --> <property name="autoDelimitKeywords" value="false"/> <property name="javaFileEncoding" value="UTF-8"/> <!--<plugin type="com.fulihui.common.plugin.PaginationPlugin" />--> <!-- <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin" /> <plugin type="org.mybatis.generator.plugins.SerializablePlugin" /> <plugin type="org.mybatis.generator.plugins.CaseInsensitiveLikePlugin" /> <plugin type="org.mybatis.generator.plugins.ToStringPlugin" /> --> <commentGenerator > <property name="suppressDate" value="true"/> <property name="suppressAllComments" value="true"/> </commentGenerator> <!--数据库链接地址账号密码--> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.x.xx:3306/mytest?characterEncoding=UTF-8" userId="root" password="pwd111111"> <!-- 针对oracle数据库 --> <!-- <property name="remarksReporting" value="true"></property> --> <!-- 针对mysql数据库 --> <property name="useInformationSchema" value="true"></property> </jdbcConnection> <javaTypeResolver> <property name="forceBigDecimals" value="false"/> </javaTypeResolver> <!--生成Model类存放位置--> <javaModelGenerator targetPackage="com.gentest.model" targetProject="D:\folderOfBranch\test02\src\main\java\"> <property name="enableSubPackages" value="true"/> <property name="trimStrings" value="true"/> <property name="trimStrings" value="true" /> </javaModelGenerator> <!--生成映射文件存放位置--> <sqlMapGenerator targetPackage="sqlmap" targetProject="src/main/resources"> <property name="enableSubPackages" value="true"/> </sqlMapGenerator> <!--生成Dao类存放位置--> <javaClientGenerator type="XMLMAPPER" targetPackage="com.gentest.mapper" targetProject="src/main/java"> <property name="enableSubPackages" value="true"/> </javaClientGenerator> <!--生成对应表及类名--> <!--<table tableName="fuli_category_info"> <generatedKey column="id" sqlStatement="JDBC"/> <columnOverride column="is_show" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> <columnOverride column="use_module" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> <columnOverride column="show_module" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> <columnOverride column="delete_flag" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> <columnOverride column="status" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> <columnOverride column="push_app_type" jdbcType="TINYINT" javaType="java.lang.Integer"> </columnOverride> </table>--> <table tableName="newuser"> <generatedKey column="user_id" sqlStatement="JDBC"/> </table> </context> </generatorConfiguration>
三.执行install
查看生成的文件