使用Mybatis Generator自动生成Model,Mapper.java,Mapper.xml文件
一、首先在Eclipse安装Mybatis Generator插件help—> Eclipse Markeplace -> 搜索Mybatis Generator,然后点击Install,等待安装好
二、在项目下建一个generatorConfig.xml,内容如下:
<?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="E:\Company\Tool\maven\m2\repository\com\oracle\ojdbc6\11.2.0.3\ojdbc6-11.2.0.3.jar" />
<context id="DB2Tables" targetRuntime="MyBatis3">
<commentGenerator>
<!-- 是否警告 -->
<property name="suppressTypeWarnings" value="false" />
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressAllComments" value="true" />
<!-- 是否生成带时间戳的注释 -->
<property name="suppressDate" value="true" />
</commentGenerator>
<!-- 数据库驱动、链接URL、用户名、密码 -->
<!-- mysql
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/my_db?characterEncoding=utf8" userId="root" password="root"> -->
<!-- oracle -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:orcl" userId="test" password="test"></jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 生成javabeen的包名,工程上下文名称 -->
<javaModelGenerator targetPackage="com.test.demo.model" targetProject="demo">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 生成的映射文件包名,工程上下文名称 -->
<sqlMapGenerator targetPackage="com.test.demo.mapper" targetProject="demo">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 生成Mapper接口的包名,工程上下文名称 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.test.demo.mapper" targetProject="demo">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- 要生成哪些表(更改tableName表名和domainObjectName对象名就可以) -->
<table tableName="USER" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
</context>
</generatorConfiguration>
三、右键generatorConfig.xml—>Run as—> Run Mybatis Generator,然后生成ok了,如果没有建包会自动生成包