1.单独使用时,使用SqlSession:
SqlSession session = sqlSessionFactory.openSession(false);
//...这里填SQL操作代码
session.commit();
finally:session.close();
2.Spring:transactio-manager方式
(1).在配置文件中加上:
<!-- 事务注解驱动,标注@Transactional的类和方法将具有事务性 -->
<tx:annotation-driven transaction-manager="txManager" />
(2).在方法前面加上@Transactional
3.Spring:TransactionTemplate方式(看上去类型HibernateTemplate)
(1).在配置文件中加入:
<bean id="txTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<constructor-arg type="org.springframework.transaction.PlatformTransactionManager" ref="transactionManager" />
</bean>
(2).Java代码中:
@Autowired
TransactionTemplate txTemplate;
int retVal = txTemplate.execute(new TransactionCallback<Integer>() {
@Override
public Integer doInTransaction(TransactionStatus status) { // 事务操作
User user = new User(9, "Before exception");
int affectedCount = mapper.updateUser(user); // 因后面的异常而回滚
User user2 = new User(10, "After exception");
int i = 1 / 0; // 抛出运行时异常并回滚
int affectedCount2 = mapper.updateUser(user2); // 未执行
if (affectedCount == 1 && affectedCount2 == 1) {
return 1;
}
return 0;
}
});
注:不可catch Exception或RuntimeException而不抛出:
Java代码 收藏代码
@Transactional
public int txUpdateUsersWhenExceptionAndCatch() { // 事务性操作,但是外围框架捕获不到异常,认为执行正确而提交。
try {
User user = new User(9, "Before exception");
int affectedCount = mapper.updateUser(user); // 执行成功
User user2 = new User(10, "After exception");
int i = 1 / 0; // 抛出运行时异常
int affectedCount2 = mapper.updateUser(user2); // 未执行
if (affectedCount == 1 && affectedCount2 == 1) {
return 1;
}
} catch (Exception e) { // 所有异常被捕获而未抛出
e.printStackTrace();
}
return 0;
}
SqlSession session = sqlSessionFactory.openSession(false);
//...这里填SQL操作代码
session.commit();
finally:session.close();
2.Spring:transactio-manager方式
(1).在配置文件中加上:
<!-- 事务注解驱动,标注@Transactional的类和方法将具有事务性 -->
<tx:annotation-driven transaction-manager="txManager" />
(2).在方法前面加上@Transactional
3.Spring:TransactionTemplate方式(看上去类型HibernateTemplate)
(1).在配置文件中加入:
<bean id="txTemplate" class="org.springframework.transaction.support.TransactionTemplate">
<constructor-arg type="org.springframework.transaction.PlatformTransactionManager" ref="transactionManager" />
</bean>
(2).Java代码中:
@Autowired
TransactionTemplate txTemplate;
int retVal = txTemplate.execute(new TransactionCallback<Integer>() {
@Override
public Integer doInTransaction(TransactionStatus status) { // 事务操作
User user = new User(9, "Before exception");
int affectedCount = mapper.updateUser(user); // 因后面的异常而回滚
User user2 = new User(10, "After exception");
int i = 1 / 0; // 抛出运行时异常并回滚
int affectedCount2 = mapper.updateUser(user2); // 未执行
if (affectedCount == 1 && affectedCount2 == 1) {
return 1;
}
return 0;
}
});
注:不可catch Exception或RuntimeException而不抛出:
Java代码 收藏代码
@Transactional
public int txUpdateUsersWhenExceptionAndCatch() { // 事务性操作,但是外围框架捕获不到异常,认为执行正确而提交。
try {
User user = new User(9, "Before exception");
int affectedCount = mapper.updateUser(user); // 执行成功
User user2 = new User(10, "After exception");
int i = 1 / 0; // 抛出运行时异常
int affectedCount2 = mapper.updateUser(user2); // 未执行
if (affectedCount == 1 && affectedCount2 == 1) {
return 1;
}
} catch (Exception e) { // 所有异常被捕获而未抛出
e.printStackTrace();
}
return 0;
}