使用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了,如果沒有建包會自動生成包