用Mybatis的童鞋可能会有这种感想：mybatis可以像hibernate的一样直接生成文件和呢？答案是肯定的。下面我们就开始自己动手来Mybatis生成器。
一、准备generator-core-x.x.x.jar和驱动
generator-core-x.x.x.jar
下载路径:generator-core-x.x.x.jar。并解压到指定的目录下。在解压的mybatis-generator-core-1.3.2\lib目录中可以看到mybatis-generator-core-1.3.2.jar
ojdbc14.jar
下载网址http://www..com/tech/indexes/downloads/index.html驱动下找到jdbc驱动&
二、配置generator.xml
&?xml ="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:/oracle-jdbc/oracle/ojdbc14.jar" /&
&context id="MBG" targetRuntime="MyBatis3"&
&!-- 数据库配置 --&
&jdbcConnection driverClass="oracle.jdbc.driver.Driver"
connectionURL="jdbc:oracle:thin:@61:1521:orcl"
userId="cas"
password="cas"&
&/jdbcConnection&
&javaTypeResolver &
&property name="ceBigDecimals" value="/blog/false" /&
&/javaTypeResolver&
&!-- model配置 --&
&javaModelGenerator target="cc" targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&property name="trimStrings" value="/blog/true" /&
&/javaModelGenerator&
&!-- xml --&
&sqlMapGenerator targetPackage="cc"
targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&/sqlMapGenerator&
&javaClientGenerator type="XMLMAPPER" targetPackage="cc"
targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&/javaClientGenerator&
tableName="t_log_submanual_wcdma" domainObjectName="WcdmsTrackLog" &
&/context&&/generatorConfiguration&
上面的配置文件，你可能要修改以下几个地方：
1、 数据库驱动配置
&!-- 数据库驱动 --&
&classPathEntry location="E:/oracle-jdbc/oracle/ojdbc14.jar" /&
2、数据库连接属性配置：
&!-- 数据库配置 --&
&jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@192.168.1.161:1521:orcl"
userId="cas"
password="cas"&
&/jdbcConnection&
3、java对象类即table对应的类存放的地方targetProject(这些路径都可以直接指向你中的)：
&!-- model配置 --&
&javaModelGenerator targetPackage="cc" targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&property name="trimStrings" value="/blog/true" /&
&/javaModelGenerator&
4、sql配置xml文件存放路径配置targetProject：
&!-- xml配置文件 --&
&sqlMapGenerator targetPackage="cc"
targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&/sqlMapGenerator&
5、dao层接口代码存放路径配置targetProject和目标包targetPackage：
&!--接口--&
&javaClientGenerator type="XMLMAPPER" targetPackage="cc"
targetProject="C:\Users\Administrator\Desktop\tt"&
&property name="enableSubPackages" value="/blog/true" /&
&/javaClientGenerator&
6、配置表名tableName和对应的类名domainObjectName：
tableName="t_log_submanual_wcdma" domainObjectName="WcdmsTrackLog" &
三、编写generator.bat文件
@echo offecho==========mybatis开始生成代码================java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite
pauseecho==========mybatis生成代码完毕================
ps:mybatis-generator-core-1.3.2.jar 、ojdbc14.jar和 generator.xml 应该在同一个路径下。
mybatis-generator-core-1.3.2.jar (504.3 KB)
下载次数: 0
ojdbc14.jar (1.1 MB)
下载次数: 0spring-mabatis整合的配置文件 - 若_ - 推酷
spring-mabatis整合的配置文件 - 若_
1.spring.xml
1 &?xml version=&1.0& encoding=&UTF-8&?&
2 &beans xmlns=&http://www.springframework.org/schema/beans&
xmlns:xsi=&http://www.w3.org/2001/XMLSchema-instance& xmlns:p=&http://www.springframework.org/schema/p&
xmlns:context=&http://www.springframework.org/schema/context&
xmlns:jee=&http://www.springframework.org/schema/jee& xmlns:tx=&http://www.springframework.org/schema/tx&
xmlns:aop=&http://www.springframework.org/schema/aop&
xmlns:jaxws=&http://cxf.apache.org/jaxws&
xsi:schemaLocation=&
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/jee
http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://cxf.apache.org/jaxws
http://cxf.apache.org/schemas/jaxws.xsd&&
&!-- *************************导cxf的配置文件*************************** --&
&!-- 引入属性文件 --&
&context:property-placeholder location=&classpath:config.properties&/&
&!-- 自动扫描(自动注入) --&
&context:component-scan base-package=&sy.*&&&/context:component-scan&
28 &/beans&
spring.xml
&context:property-placeholder location=&classpath:config.properties&/&
自动 引入配置文件
&context:component-scan base-package=&sy.*&&&/context:component-scan&
自动扫描sy下的所有类，不需要再配置&beans id...&
2.spring-mybatis.xml
1 &?xml version=&1.0& encoding=&UTF-8&?&
2 &beans xmlns=&http://www.springframework.org/schema/beans&
xmlns:xsi=&http://www.w3.org/2001/XMLSchema-instance& xmlns:p=&http://www.springframework.org/schema/p&
xmlns:context=&http://www.springframework.org/schema/context&
xmlns:jee=&http://www.springframework.org/schema/jee& xmlns:tx=&http://www.springframework.org/schema/tx&
xmlns:aop=&http://www.springframework.org/schema/aop&
xmlns:jaxws=&http://cxf.apache.org/jaxws&
xsi:schemaLocation=&
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/jee
http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://cxf.apache.org/jaxws
http://cxf.apache.org/schemas/jaxws.xsd&&
&!-- *************************导cxf的配置文件*************************** --&
&!-- 配置数据源 --&
&bean name=&dataSource& class=&com.alibaba.druid.pool.DruidDataSource& init-method=&init& destroy-method=&close&&
&property name=&url& value=&${jdbc_url}&&&/property&
&property name=&username& value=&${jdbc_username}&&&/property&
&property name=&password& value=&${jdbc_password}&&&/property&
&!-- 初始化连接大小 --&
&property name=&initialSize& value=&0& /&
&!-- 连接池最大使用链接数量 --&
&property name=&maxActive& value=&20& /&
&!-- 连接池最大空闲 --&
&property name=&maxIdle& value=&20& /&
&!-- 连接池最小空闲 --&
&property name=&minIdle& value=&0& /&
&!-- 获取连接最大等待时间 --&
&property name=&maxWait& value=&60000& /&
&property name=&validationQuery& value=&${validationQuery}&/&
&property name=&testOnBorrow& value=&false&/&
&property name=&testOnReturn& value=&false&/&
&property name=&testWhileIdle& value=&true&/&
&!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --&
&property name=&timeBetweenEvictionRunsMillis& value=&60000&/&
&!-- 配置一个连接池在池中最小生存时间 单位毫秒 --&
&property name=&minEvictableIdleTimeMillis& value=&&/&
&!-- 打开removeAbandoned功能 --&
&property name=&removeAbandoned& value=&true&/&
&!-- 1800秒，也就是30分钟 --&
&property name=&removeAbandonedTimeout& value=&1800&/&
&!-- 关闭abanded连接时输出错误日志 --&
&property name=&logAbandoned& value=&true& /&
&!-- 监控数据库 --&
&property name=&filters& value=&mergeStat& /&
&!-- mybatis文件 --&
&bean id=&sqlSessionFactory& class=&org.mybatis.spring.SqlSessionFactoryBean&&
&property name=&dataSource& ref=&dataSource& /&
&!-- 自动扫描entity目录，省掉Configuration.xml手工配置 --&
&property name=&mapperLocations& value=&classpath:sy/mapping/*.xml&/&
&bean class=&org.mybatis.spring.mapper.MapperScannerConfigurer&&
&property name=&basePackage& value=&sy.dao&/&
&property name=&sqlSessionFactoryBeanName& value=&sqlSessionFactory&/&
&bean id=&transactionManager& class=&org.springframework.jdbc.datasource.DataSourceTransactionManager&&
&property name=&dataSource& ref=&dataSource& /&
&!-- 拦截器方式配置事物 --&
&tx:advice id=&transactionAdvice& transaction-manager=&transactionManager&&
&tx:attributes&
&tx:method name=&add*& propagation=&REQUIRED& /&
&tx:method name=&append*& propagation=&REQUIRED& /&
&tx:method name=&insert*& propagation=&REQUIRED& rollback-for=&java.lang.Exception&/&
&tx:method name=&save*& propagation=&REQUIRED& /&
&tx:method name=&update*& propagation=&REQUIRED& /&
&tx:method name=&modify*& propagation=&REQUIRED& /&
&tx:method name=&edit*& propagation=&REQUIRED& /&
&tx:method name=&delete*& propagation=&REQUIRED& /&
&tx:method name=&remove*& propagation=&REQUIRED& /&
&tx:method name=&repair& propagation=&REQUIRED& /&
&tx:method name=&delAndRepair& propagation=&REQUIRED& /&
&tx:method name=&get*& propagation=&SUPPORTS& /&
&tx:method name=&find*& propagation=&SUPPORTS& /&
&tx:method name=&load*& propagation=&SUPPORTS& /&
&tx:method name=&all*& propagation=&SUPPORTS& /&
&tx:method name=&search*& propagation=&SUPPORTS& /&
&tx:method name=&datagrid*& propagation=&SUPPORTS& /&
&tx:method name=&*& propagation=&SUPPORTS& /&
&/tx:attributes&
&/tx:advice&
&aop:config&
&aop:pointcut id=&transactionPointcut& expression=&execution(* com.zfy.service..*.*impl.*(..))& /&
&aop:advisor pointcut-ref=&transactionPointcut& advice-ref=&transactionAdvice& /&
&/aop:config&
&!-- 配置druid监控spring jdbc --&
&bean id=&druid-stat-interceptor& class=&com.alibaba.druid.support.spring.stat.DruidStatInterceptor&&
&bean id=&druid-stat-pointcut& class=&org.springframework.aop.support.JdkRegexpMethodPointcut& scope=&prototype&&
&property name=&patterns&&
&value&sy.service.*&/value&
&/property&
&aop:config&
&aop:advisor advice-ref=&druid-stat-interceptor& pointcut-ref=&druid-stat-pointcut& /&
&/aop:config&
120 &/beans&
spring-mybatis.xml
&property name=&url& value=&${jdbc_url}&&&/property&
&property name=&username& value=&${jdbc_username}&&&/property&
&property name=&password& value=&${jdbc_password}&&&/property&
读取配置文件的值
大部分代码都有注释，就不再一一说明了。
3.所需jar包
1 &dependencies&
&dependency&
&groupId&org.springframework&/groupId&
&artifactId&spring-core&/artifactId&
&version&4.0.6.RELEASE&/version&
&/dependency&
&dependency&
&groupId&org.mybatis&/groupId&
&artifactId&mybatis&/artifactId&
&version&3.2.7&/version&
&/dependency&
&dependency&
&groupId&org.mybatis&/groupId&
&artifactId&mybatis-spring&/artifactId&
&version&1.1.1&/version&
&/dependency&
&dependency&
&groupId&mysql&/groupId&
&artifactId&mysql-connector-java&/artifactId&
&version&5.1.32&/version&
&/dependency&
&/dependencies&
此处是以maven形式给出的，其实都可以自己一一下载，下载方式：
下载地址：
搜索对应的artifactId即可
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致Mabatis自动生成entity和mapper接口 | OpenWares | Open Source and Free Matters
Copyleft &
本站为原创网站,除非另有声明,本网站采用授权.}