MyBatis Generator 与Spring整合实例.doc

MyBatis Generator 代码生成器与Spring整合示例引言 Mybatis-generator是一个mybatis相关代码的自动生成工具。本文并未使用Ant和Maven等命令工具，而是直接使用了一个JUnit来完成的同时生成的代码还会被进一步被修改，不是直接使用（可能后期会提供一插件）1. 编写目的 本文档是 mybatisgenerator的实战说明，编写目的是：为即将使用 mybatis的开发人员提供帮助。Demo示例需要环境1. 使用Eclipse新建一个项目，可以在原项目中加入所需要的jar包，附加doc和src方便代码，然后新建xml文件。2. 导入Oracle等数据驱动包 3. 向项目中引入Junit4，新建单元测试类 配置文件generatorConfig.xmlGena !- - Junit测试生成类MbgTestpackage com.annto.mbg;import static org.junit.Assert.*;import java.io.File;import java.io.IOException;import java.math.BigDecimal;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import org.apache.log4j.Logger;import org.junit.Test;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 ernal.DefaultShellCallback;/* * Mbg test * * author zx Jan 15, 2013 * */public class MbgTest Logger logger = Logger.getLogger(MbgTest.class);/* * 测试 * throws XMLParserException * throws IOException * throws InvalidConfigurationException * throws InterruptedException * throws SQLException */Testpublic void testGenerate() throws IOException, XMLParserException, InvalidConfigurationException, SQLException, InterruptedException String pathSptor = System.getProperty(path.separator);String filePath = System.getProperty(java.class.path);filePath = filePath.substring(0,filePath.indexOf(pathSptor)+ File.separator + generatorConfig.xml;List warnings = new ArrayList();boolean overwrite = true;(filePath);File configFile = new File(filePath);ConfigurationParser cp = new ConfigurationParser(warnings);Configuration config = cp.parseConfiguration(configFile);DefaultShellCallback callback = new DefaultShellCallback(overwrite);MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);myBatisGenerator.generate(null);for(String w : warnings)(w);运行JUnit 后生成Mapper，model和xml配置文件手动完善生成的代码当然，如果需要使用Spring的Mapper映射，需要再维护下生成的类（比较乱），而且Oracle的NVarchar2会识别成Object类型。维护好代码以后，可以放入自己项目生成环境的resource和model包下package com.annto.dao;import com.annto.mbg.gen.model.TrcUserLog;public interface TrcUserLogMapper public abstract int delete(Long id); public abstract int insert(TrcUserLog record); public abstract int update(TrcUserLog log); insert into TRC_USER_LOG SELECT SEQ_TRC_USER_LOG.nextval AS id FROM DUAL LOG_ID, USER_ID, USER_NAME, MODULE_ID, MODULE_NAME, ACTION, ACTION_DESC, INPUT, OUTPUT, EXEC_TIME, CREATE_DATE, CLIENT_IP, SERVER_IP, #logId,jdbcType=NUMERIC, #userId,jdbcType=VARCHAR, #userName,jdbcType=VARCHAR, #moduleId,jdbcType=VARCHAR, #moduleName,jdbcType=VARCHAR, #action,jdbcType=VARCHAR, #actionDesc,jdbcType=VARCHAR, #input,jdbcType=VARCHAR, #output,jdbcType=VARCHAR, #execTime,jdbcType=NUMERIC, #createDate,jdbcType=TIMESTAMP, #clientIp,jdbcType=VARCHAR, #serverIp,jdbcType=VARCHAR, update TRC_USER_LOG USER_ID = #userId,jdbcType=VARCHAR, USER_NAME = #userName,jdbcType=VARCHAR, MODULE_ID = #moduleId,jdbcType=VARCHAR, MODULE_NAME = #moduleName,jdbcType=VARCHAR, ACTION = #action,jdbcType=VARCHAR, ACTION_DESC = #actionDesc,jdbcType=VARCHAR, INPUT = #input,jdbcType=VARCHAR, OUTPUT = #output,jdbcType=VARCHAR, EXEC_TIME = #execTime,jdbcType=NUMERIC, CREATE_DATE = #createDate,jdbcType=TIMESTAMP, CLIENT_IP = #clientIp,jdbcType=VARCHAR, SERVER_IP = #serverIp,jdbcType=VARCHAR where LOG_ID = #logId,jdbcType=NUMERIC delete TRC_USER_LOG l where l.LOG_id = #id Spring Mapper的映射配置：配置以后，mapper.xml需要放在指定的位置单元测试生成的Mapper类package com.annto.mbg;import static org.junit.Assert.assertNotNull;import java.util.Date;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.annto.mbg.gen.model.TrcUserLog;RunWith(SpringJUnit4ClassRunner.class)ContextConfiguration(classpath:com/annto/testContext.xml)public class TrcUserLogMapperTest Autowiredcom.annto.dao.TrcUserLogMapper trcUserLogMapper = null;/* * 测试插入和删除 */Testpublic void testInsertAndUpdateAndDelete()TrcUserLog log = new TrcUserLog();log.setAction(test);log.setActionDesc(描述);log.setClientIp(teststset.asdfadf);log.setCreateDate(new Date();log.setExecTime(Long.valueOf(12123123l);log.setInput(输入);log.setModuleId(模块Id);log.setModuleName(模块名称);log.set