背景
本文主要介绍spring+mybatis+PamirsTransaction的配置。即ORM映射框架和事务的配合使用
mybatis配置
mybatis主要完成java到db的映射。主要模块有datasource、sqlSessionFactory、DAO及sqlmap四个部分组成。其中datasource为数据源，目前一般用的都是mysql数据库。sqlSessionFactory为数据会话，该会话完成接口到sql的映射工作。DAO接口类，对于数据库操作的抽象接口，上层调用可以直接调用该接口进行DB操作，sqlmap完成DAO到DB的映射配置文件。DAO接口类即通过sqlmap完成对DB的操作。
PamirsTransaction
事务管理，即在mybatis增加对于事务的处理。实际上任何框架本身是不支持事务的处理的，而事务的处理最终是依赖于DB。PamirsTransaction即协助管理了事务，使用PamirsTransaction即可完成对于事务的提交和回滚。
代码
XML配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.springframework.org/schema/beans"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
">
<bean id="tbDataSource" class="com.taobao.pamirs.transaction.TBDataSourceImpl">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8" />
<property name="username" value="root" />
<property name="password" value="123456" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="tbDataSource" />
<property name="mapperLocations" value="classpath:mapper/*.xml" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="TRANSACTION.DAO" />
</bean>
<bean id="pamirsTransactionTemplate" class="com.taobao.pamirs.transaction.PamirsTransactionTemplate" />
<bean id="tbTransactionHandler" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource" />
</property>
</bean>
</beans>
DAO
package TRANSACTION.DAO;
import org.apache.ibatis.annotations.Delete;
/**
* Created by jianghuiwen on 17/5/5.
*/
public interface StudentDAO {
@Delete(
"delete from test where id = #{id}")
public void delete(Long id);
}
测试表
测试类
@Test
public void testDAOrollback()
throws SQLException {
ApplicationContext context =
new ClassPathXmlApplicationContext(
"mysqltransaction.xml");
final StudentDAO dao = (StudentDAO)context.getBean(
"studentDAO");
PamirsTransactionTemplate pamirsTransactionTemplate = (PamirsTransactionTemplate) context.getBean(
"pamirsTransactionTemplate");
Boolean isSuccess = (Boolean) pamirsTransactionTemplate.execute(
new PamirsTransactionAction(){
public Object
doInTransaction(PamirsTransactionStatus pamirsTransactionStatus)
throws Exception {
dao.delete(
1L);
return true;
}
});
}
