在一个事务里面调用存储过程。使用了三种方法编写事务,下面的一)和二)都不能回滚存储过程,只能回滚存储过程外的sql数据库操作。第三种方法才能回滚存储过程。
一)
@Transactional
二)org.springframework.transaction.support.TransactionTemplate
java代码
xml配置:
三)确保每个调用的Connection con是同一个,发生错误时,回滚。
一)
@Transactional
二)org.springframework.transaction.support.TransactionTemplate
java代码
public void savePurchaseOrder(final PurchaseOrder purchaseOrder,final long changerId) {
transactionTemplate.execute(new TransactionCallback() {
public Object doInTransaction(TransactionStatus ts)
{
try{
long identity0=0;//父级id
identity0=savePurchaseOrderSummary(purchaseOrder, changerId);
for(int i=0;i<purchaseOrder.getPurchaseOrder_material_list().size();i++){
long identity1=0;//父级id
PurchaseOrder_material purchaseOrder_material=purchaseOrder.getPurchaseOrder_material_list().get(i);
identity1=savePurchaseOrderMaterial(purchaseOrder_material,identity0);
for(int j=0;j<purchaseOrder_material.getPurchaseOrder_material_colorNo_list().size();j++){
long identity2=0;//父级id
PurchaseOrder_material_colorNo purchaseOrder_material_colorNo=purchaseOrder_material.getPurchaseOrder_material_colorNo_list().get(j);
identity2=savePurchaseOrderMaterialColorNo(purchaseOrder_material_colorNo,identity1);
for(int k=0;k<purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().size();k++){
long identity3=0;
PurchaseOrder_material_colorNo_yarnCount purchaseOrder_material_colorNo_yarnCount=purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().get(k);
identity3=savePurchaseOrderMaterialColorNoYarnCount(purchaseOrder_material_colorNo_yarnCount,identity2);
//此处不做循环,不需要有返回值identity,可使用预处理
savePurchaseOrderMaterialColorNoYarnCountClNoOrYrNoList(purchaseOrder_material_colorNo_yarnCount.getPurchaseOrder_material_colorNo_yarnCount_clNoOrYrNo_list());
}
}
}
}catch(Exception e){
ts.setRollbackOnly();
}
return null;
}
});
}
xml配置:
<bean id="yarnSpinningScheduleService" class="com.jjfz.fasys.service.impl.YarnSpinningScheduleServiceImpl">
<property name="dao" ref="dao"/>
<property name="transactionTemplate">
<bean class="org.springframework.transaction.support.TransactionTemplate">
<property name="transactionManager" ref="transactionManager"/>
</bean>
</property>
</bean>
三)确保每个调用的Connection con是同一个,发生错误时,回滚。
@Transactional//必须有这句,下面才能回滚
public void savePurchaseOrder(final PurchaseOrder purchaseOrder,final long changerId) {
dao.getJdbcTemplate().execute(new ConnectionCallback() {
public Object doInConnection(Connection con)
{
try{
long identity0=0;//父级id
identity0=savePurchaseOrderSummary(con,purchaseOrder, changerId);
for(int i=0;i<purchaseOrder.getPurchaseOrder_material_list().size();i++){
long identity1=0;//父级id
PurchaseOrder_material purchaseOrder_material=purchaseOrder.getPurchaseOrder_material_list().get(i);
identity1=savePurchaseOrderMaterial(con,purchaseOrder_material,identity0);
for(int j=0;j<purchaseOrder_material.getPurchaseOrder_material_colorNo_list().size();j++){
long identity2=0;//父级id
PurchaseOrder_material_colorNo purchaseOrder_material_colorNo=purchaseOrder_material.getPurchaseOrder_material_colorNo_list().get(j);
identity2=savePurchaseOrderMaterialColorNo(purchaseOrder_material_colorNo,identity1);
for(int k=0;k<purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().size();k++){
long identity3=0;
PurchaseOrder_material_colorNo_yarnCount purchaseOrder_material_colorNo_yarnCount=purchaseOrder_material_colorNo.getPurchaseOrder_material_colorNo_yarnCount_list().get(k);
identity3=savePurchaseOrderMaterialColorNoYarnCount(purchaseOrder_material_colorNo_yarnCount,identity2);
//此处不做循环,不需要有返回值identity,可使用预处理
savePurchaseOrderMaterialColorNoYarnCountClNoOrYrNoList(purchaseOrder_material_colorNo_yarnCount.getPurchaseOrder_material_colorNo_yarnCount_clNoOrYrNo_list());
}
}
}
}catch(Exception e){
try {
con.rollback();
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
return null;
}
});
}