1. 首先添加maven插件
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<configuration>
<configurationFile>src/test/resources/config/generatorConfig.xml</configurationFile> //这是与数据库的配置地址
<verbose>true</verbose>
<overwrite>true</overwrite>
</configuration>
</plugin>
2.其次填写与数据库连接配置文件<?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 >
<classPathEntry location="/Users/seabook.liu/.m2/repository/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar" />
<context id="context1" >
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="" />(数据库连接)
<javaModelGenerator targetPackage="com.dianping.poi.updateflow.biz.model" targetProject="src/main/java">
<property name="enableSubPackages" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="config.sqlmap.updateflow" targetProject="src/main/resources" >(生成的mapper文件)
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator targetPackage="com.dianping.poi.updateflow.biz.dao" targetProject="src/main/java" type="XMLMAPPER" >(生成的dao层接口)
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table schema="" tableName="POI_Shop"(数据库表名) domainObjectName="PoiShop"(生产的实体对象)
enableCountByExample="true"
enableUpdateByExample="true"
enableDeleteByExample="true"
enableSelectByExample="true"
selectByExampleQueryId="true"
>
</table>
</context>
</generatorConfiguration>
3.利用maven命令自动生成
mybatis-generator:generate
4.最后能生成如下文件
只是实例一个
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.dianping.poi.updateflow.biz.dao.ProcInfoDao" >
<resultMap id="BaseResultMap" type="com.dianping.poi.updateflow.biz.model.ProcInfo" >
<!--
WARNING - @mbggenerated
This element is automatically generated by MyBatis Generator, do not modify.
This element was generated on Tue Jul 28 16:24:30 CST 2015.
-->
<id column="proc_id" property="procId" jdbcType="INTEGER" />
<result column="flow_id" property="flowId" jdbcType="INTEGER" />
<result column="entry_id" property="entryId" jdbcType="INTEGER" />
<result column="proc_type" property="procType" jdbcType="VARCHAR" />
<result column="proc_status" property="procStatus" jdbcType="TINYINT" />
<result column="editer_id" property="editerId" jdbcType="VARCHAR" />
<result column="result" property="result" jdbcType="VARCHAR" />
<result column="explain" property="explain" jdbcType="VARCHAR" />
<result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
<result column="update_time&#