spring-mybatis文件

编写mybatis-config.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>
	<settings>
		<setting name="cacheEnabled" value="true" />
		<!-- 开启二级缓存 -->
		<setting name="lazyLoadingEnabled" value="true" />
		<setting name="multipleResultSetsEnabled" value="true" />
		<setting name="useColumnLabel" value="true" />
		<setting name="useGeneratedKeys" value="false" />
		<setting name="autoMappingBehavior" value="PARTIAL" />
		<setting name="defaultExecutorType" value="SIMPLE" />
		<setting name="defaultStatementTimeout" value="25" />
		<setting name="safeRowBoundsEnabled" value="false" />
		<setting name="mapUnderscoreToCamelCase" value="false" />
		<setting name="localCacheScope" value="SESSION" />
		<setting name="jdbcTypeForNull" value="OTHER" />
		<setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString" />
	</settings>
	<typeAliases>
		<!-- vo简写 -->
		<package name="domain.blog" />
	</typeAliases>
	<!-- Using classpath relative resources -->
	<mappers>
		<mapper resource="org/mybatis/builder/AuthorMapper.xml" />
		<mapper resource="org/mybatis/builder/BlogMapper.xml" />
		<mapper resource="org/mybatis/builder/PostMapper.xml" />
	</mappers>
	<!-- Using url fully qualified paths -->
	<!-- <mappers>
		<mapper url="file:///var/mappers/AuthorMapper.xml" />
		<mapper url="file:///var/mappers/BlogMapper.xml" />
		<mapper url="file:///var/mappers/PostMapper.xml" />
	</mappers> -->
	<!-- Using mapper interface classes -->
<!-- <mappers>
  <mapper class="org.mybatis.builder.AuthorMapper"/>
  <mapper class="org.mybatis.builder.BlogMapper"/>
  <mapper class="org.mybatis.builder.PostMapper"/>
</mappers> -->
<!-- Register all interfaces in a package as mappers -->
<!-- <mappers>
  <package name="org.mybatis.builder"/>
</mappers> -->
</configuration>

 

编写spring-mybatis.xml

 

 

<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
		<!-- 初始化连接大小 -->
		<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="25200000" />

		<!-- 打开removeAbandoned功能 -->
		<property name="removeAbandoned" value="true" />
		<!-- 1800秒，也就是30分钟 -->
		<property name="removeAbandonedTimeout" value="1800" />
		<!-- 关闭abanded连接时输出错误日志 -->
		<property name="logAbandoned" value="true" />

		<!-- 监控数据库 -->
		<!-- <property name="filters" value="stat" /> -->
		<property name="filters" value="mergeStat" />
	</bean>

 

编写sessionfactory，这个类在spring生命周期是singleton

 

 

<!-- 定义Spring与MyBatis整合的操作控制，此时数据库的连接对象取得由Spring负责 -->
	<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- Mybatis操作需要有数据库连接池的支持，所以此处将之前配置连接池设置到此类之中 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 编写的mapper.xml -->
		<property name="mapperLocations" value="classpath:sona/rfk/mapping/*.xml"/>
		<!-- 配置所有资源文件的保存路径的资源匹配符 -->
		<property name="configLocation" value="classpath:mybatis/mybatis.cfg.xml" />
	</bean>

 

去除dao实现子类

 

 

<!-- 定义数据层子类的自动实现控制，这样才可以将DAO接口与映射文件整合在一起，该bean不需要做引用 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 存放在sona.rfk下的包接口才可以被自动的映射实现子类,无需编写dao的实现子类 -->
		<property name="basePackage" value="sona.rfk.dao"/>
		<!-- 定义本次要使用的SessionFactory类型的对象，直接以Bean的名称进行导入 -->
		<property name="sqlSessionFactoryBeanName" value="sessionFactory"/>
	</bean>  

 

<!-- 注解方式配置事物 -->
	 <tx:annotation-driven transaction-manager="transactionManager" />

 

配置事物管理器使用jdbc事物管理

注解方式配置事务

 

 

<!-- 配置事务管理器 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>

 

<!-- 拦截器方式配置事物 -->
	<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" />
			<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="search*" propagation="SUPPORTS" />
			<tx:method name="datagrid*" propagation="SUPPORTS" />

			<tx:method name="*" propagation="SUPPORTS" />
		</tx:attributes>
	</tx:advice>

 

 

进行aop切面

 

<aop:config>
		<aop:pointcut id="transactionPointcut" expression="execution(* com.xx.service.impl.*.*(..))" />
		<aop:advisor pointcut-ref="transactionPointcut" advice-ref="transactionAdvice" />
	</aop:config>