DB2生成表model与mybatis的mapper中的常用方法

已经用这个工具很久了感觉很方便，该工具会将bd2中的表生成model与mapper以及mapper.xml中的增删改查的常用方法，话不多说，上菜...

[size=x-large][color=red][b]1.配置[/b][/color][/size]
[color=blue]<?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:\db2jcc_license_cu.jar" />
<classPathEntry location="E:\db2jcc4.jar" />
<classPathEntry location="E:\db2java.jar" />
<context id="context1" defaultModelType="flat" targetRuntime="MyBatis3">

<!-- 为了防止生成的代码中有很多注释 -->
<commentGenerator>
<property name="suppressAllComments" value="true" />
<property name="suppressDate" value="true" />
</commentGenerator>
<!-- 注释控制完毕 -->
<jdbcConnection driverClass="com.ibm.db2.jcc.DB2Driver"
connectionURL="数据库地址" userId="用户名"
password="密码">
</jdbcConnection>
<!--targetPackage包路径 targetProject：src绝对路径 -->
<!-- bean example -->
<javaModelGenerator targetPackage="com.test.model"<!--此处的targetPackage为要生成的model的项目路径，对应到要应用项目的路径-->
targetProject="E:\test"><!--此处的targetProject为该model生成到本地的地址-->
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- mapper.xml -->
<sqlMapGenerator targetPackage="com.fuiou.fwp.db.mapper"<!--此处的targetPackage为要生成的model的项目路径，对应到要应用项目的路径-->
targetProject="E:\test"><!--此处的targetProject为该mapper生成到本地的地址-->
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- mapper接口 -->
<javaClientGenerator targetPackage="com.fuiou.fwp.db.mapper"
targetProject="E:\test" type="XMLMAPPER">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!--数据库表 -->
<table schema="" tableName="xxxx" enableSelectByExample="true"<!--tableName为你要生成的表的名字-->
enableDeleteByExample="true" enableCountByExample="true"
enableUpdateByExample="true">
<property name="useActualColumnNames" value="false" />
</table>
</context>
</generatorConfiguration>[/color]

[size=x-large][color=red][b]2.执行 main方法[/b][/color][/size]

[color=blue]package com.***.test;

import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.InvalidConfigurationException;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;


public class MybatisTool {
public static void main(String[] args) {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
String genCfg = "mbgConfiguration.xml";
System.out.println(MybatisTool.class.getResource(genCfg));
File configFile = new File(MybatisTool.class.getResource(genCfg).getFile());
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = null;
try {
config = cp.parseConfiguration(configFile);
} catch (IOException e) {
e.printStackTrace();
} catch (XMLParserException e) {
e.printStackTrace();
}
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = null;
try {
myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
} catch (InvalidConfigurationException e) {
e.printStackTrace();
}
try {
myBatisGenerator.generate(null);
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (InterruptedException e) {
e.printStackTrace();
}
}
}


[/color]


附件为详细的jar包以及代码，谢谢...