使用Mybatis Generator包自动生成Mybatis相关内容
1.环境 mybatits+oracle
准备工作:
ojdbc5.jar
mybatis-generator-core-1.3.1.jar
mybatis-3.1.0-SNAPSHOT.jar
2.新建一web工程
src目录新建包com.sm.dao/model
文件:generator.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:\myspace\sm\WebContent\WEB-INF\lib\ojdbc5.jar" /> <context id="DB2Tables" targetRuntime="MyBatis3"> <commentGenerator> <property name="suppressDate" value="true" /> </commentGenerator> <jdbcConnection driveruserId="hr" password="123456"> </jdbcConnection> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver> <javaModelGenerator targetPackage="com.sm.model" targetProject="../src"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator> <sqlMapGenerator targetPackage="com.sm.model" targetProject="../src"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator> <javaClientGenerator type="XMLMAPPER" targetPackage="com.sm.dao" targetProject="../src"> <property name="enableSubPackages" value="true" /> </javaClientGenerator> <table tableName="t_user" domainObjectName="User"> </table> <table tableName="t_rolemap" domainObjectName="Rolemap"> </table> <table tableName="t_role" domainObjectName="Role"> </table> <table tableName="t_extrafield" domainObjectName="Extrafield"> </table> <table tableName="regions" domainObjectName="Regions"> </table> <table tableName="manager" domainObjectName="Manager"> </table> <table tableName="locations" domainObjectName="Locations"> </table> <table tableName="job_history" domainObjectName="Job_history"> </table> <table tableName="jobs" domainObjectName="Jobs"> </table> <table tableName="employees" domainObjectName="Employees"> </table> <table tableName="departments" domainObjectName="Departments"> </table> <table tableName="countries" domainObjectName="Countries"> </table> </context></generatorConfiguration>
这里有必要把上面的xml 标签介绍一下
* 其中classPathEntry 是引用的jdbc的类路径，这里将jdbc jar和generator的jar包放在一起了；(我在测试的时候使用相对路径出现了问题,后就使用绝对路径)
* commentGenerator 是用来除去时间信息的，这在配合类似subversion的代码管理工具时使用很有效，因为可以减少没有必要的注释迁入；
* jdbcConnection是指定的jdbc的连接信息；
* javaTypeResolver式类型转换的信息，这里并没有用到；
* javaModelGenerator是模型的生成信息，这里将指定这些Java model类的生成路径；
* sqlMapGenerator是mybatis 的sqlMapper XML文件的生成信息，包括生成路径等；
* javaClientGenerator是应用接口的生成信息；
* table是用户指定的被生成相关信息的表，它必须在指定的jdbc连接中已经被建立。
MapperConfig.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL" /> <property name="username" value="hr" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/sm/model/UserMapper.xml" /> <mapper resource="com/sm/model/ManagerMapper.xml" /> </mappers> </configuration>
2.导入如上3个java包;
3.运行mybatis-generator 最简单的就是命令行的方式，只需要指定相应的配置文件的路径即可：
java -jar mybatis-generator-core-1.3.0.jar -configfile ../src/main/resource/config.xml -overwrite
下面是我的代码(同样使用相对路径报错)
E:\myspace\sm\src>java -jar E:\myspace\sm\WebContent\WEB-INF\lib\mybatis-generator-core-1.3.1.jar -configfile generator.xml -overwrite
4 验证代码，新建一个Test.java 如代如下
package com.sm.test;/** * @author rabbit <hackpor@hp009.com> * @version * @since Ver 1.1 * @Date Feb 8, 2012 10:05:26 AM */public class Test {public static void main(String[] args) throws Exception {String resource = "MapperConfig.xml";Reader reader = Resources.getResourceAsReader(resource);SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader);SqlSession sqlSession = sqlMapper.openSession();UserExample user = new UserExample();user.or().andAccountIsNotNull();ManagerExample managerExa = new ManagerExample();managerExa.or().andAgeIsNotNull();try {UserMapper uMapper = sqlSession.getMapper(UserMapper.class);List<User> allRecords = uMapper.selectByExample(user);for (User s : allRecords) {System.out.println(s.getAccount() + "," + s.getPassword() + ","+ s.getStatus() + "," + s.getRegtime());}ManagerMapper mMapper = sqlSession.getMapper(ManagerMapper.class);List<Manager> managerRec = mMapper.selectByExample(managerExa);for (Manager s : managerRec) {System.out.println(s.getUserid().toString() + ","+ s.getUsername() + "," + s.getAge());}} finally {sqlSession.close();}}}5.结果如下
scott,123456,1,Fri Jun 17 00:00:00 CST 2011
tomcat,123456,null,Fri Jun 17 00:00:00 CST 2011
java,java,null,Fri Jun 17 00:00:00 CST 2011
11,hackpro,28
1450,aaa,11
1551,ccc,22
1550,bb,11
1,admin,20
2,tomcat,19
16,javaeye,10
明天研究springMVC和mybatis集成