/** JDBC事务代理工厂

最新推荐文章于 2023-04-27 14:04:39 发布

原创最新推荐文章于 2023-04-27 14:04:39 发布 · 348 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#事务

本文介绍了一个使用JDBC实现的事务代理工厂类，该类通过Spring管理的数据源进行数据库操作，并利用TransactionTemplate来管理事务。文章展示了如何在一个事务中执行多个数据库更新操作，并确保这些操作的原子性。

/**
JDBC事务代理工厂
*/
@SuppressWarnings({"rawtypes", "unchecked"})
public class WalletTransactionFactory {
@Resource(name = "jdbcTemplateC3p0MySQLAgent")
public JdbcTemplate jdbcTemplateC3p0MySQLAgent;

public static final ThreadLocal threadLocal = new ThreadLocal();

private DataSourceTransactionManager txManager;
private TransactionTemplate transactionTemplate;
private JdbcTemplate jdbcTemplate;
private String userId;
private Map<String, String> map;

public WalletTransactionFactory(String userId) {
this.userId=userId;
jdbcTemplate= SpringBeanFactory.getBean("jdbcTemplateC3p0MySQLIwl", JdbcTemplate.class);
DataSource dataSource = jdbcTemplate.getDataSource();
txManager = new DataSourceTransactionManager(dataSource);
transactionTemplate = new TransactionTemplate(txManager );
threadLocal.set(dataSource);
}
public WalletTransactionFactory(Map<String, String> map){
this.map=map;
jdbcTemplate= SpringBeanFactory.getBean("jdbcTemplateC3p0MySQLIwl", JdbcTemplate.class);
DataSource dataSource = jdbcTemplate.getDataSource();
txManager = new DataSourceTransactionManager(dataSource);
transactionTemplate = new TransactionTemplate(txManager );
threadLocal.set(dataSource);
}

//删除普通会员
public boolean service() {
Object object=
transactionTemplate.execute(new TransactionCallback(){
public Object doInTransaction(TransactionStatus transactionStatus) {
//调用具体业务操作服务方法
System.out.println("批量操作，如果出错会全部自动回滚....");
int consumptionStatus=0;
int walletStatus=0;int drivingStatus=0;int carStatus=0;int enterpriseStatus=0;
int basicStatus=0;int userStatus=0;
try{
consumptionStatus=jdbcTemplate.update("delete from iwl_consumption_detail where user_id="+userId);
walletStatus=jdbcTemplate.update("delete from iwl_my_wallet where user_id="+userId);
walletStatus=jdbcTemplate.update("delete from iwl_my_wallet where user_id="+userId);
drivingStatus=jdbcTemplate.update("delete from iwl_driving_in_formation where user_id="+userId);
carStatus=jdbcTemplate.update("delete from iwl_car_source where user_id="+userId);
enterpriseStatus=jdbcTemplate.update("delete from iwl_enterprise_information where user_id="+userId);
basicStatus=jdbcTemplate.update("delete from iwl_user_basic_in_formation where user_id="+userId);
userStatus=jdbcTemplate.update("delete from iwl_user where id="+userId);
return true;
}
catch(Exception e){
transactionStatus.setRollbackOnly();
System.out.println("walletStatus"+walletStatus+"drivingStatus"+drivingStatus+"carStatus"+carStatus+"enterpriseStatus"+enterpriseStatus+"basicStatus"+basicStatus+"userStatus"+userStatus);
System.out.println("更新failure");
return false;
}

}
});
boolean b=(Boolean)object;
System.out.println("service"+b);
return b;
}




}