MyBatis Generator:根据表生成对应的映射文件,接口,以及bean类,支持基本的增删改查。
下载jar包或者添加依赖
新建配置文件:
<?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="/Program Files/IBM/SQLLIB/java/db2java.zip" />
<context id="DB2Tables" targetRuntime="MyBatis3">
//数据库连接信息
<jdbcConnection driverClass="COM.ibm.db2.jdbc.app.DB2Driver"
connectionURL="jdbc:db2:TEST"
userId="db2admin"
password="db2admin">
</jdbcConnection>
//类型解析器
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
/*JavaBean生成策略
* targetPackage:目标类包名
* targetProject="\.src":目标工程
*/
<javaModelGenerator targetPackage="test.model" targetProject="\MBGTestProject\src">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
/*
*sql生成策略
targetPackage:目标包
*targetProject=".\src":目标工程
*/
<sqlMapGenerator targetPackage="test.xml" targetProject="\MBGTestProject\src">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
/*指定mapper接口所在位置
*
*/
<javaClientGenerator type="XMLMAPPER" targetPackage="test.dao" targetProject="\MBGTestProject\src">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
//指定需要逆向生成的表
<table tableName="ALLTYPES" </table>
</context>
</generatorConfiguration>
新建java类:
List <String> warnings = new ArrayList <String>();
boolean overwrite = true;
文件configFile = new File(“generatorConfig.xml”);
ConfigurationParser cp = new ConfigurationParser(警告);
配置config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,callback,warnings);
myBatisGenerator.generate(NULL);
运行即可生成