我的代码 DBTools dbTools = new DBTools();
conn = dbTools.getConnection(); // 链接数据库
conn.setAutoCommit(false);
stmt = conn.createStatement();
String sql1="DELETE from OrderForm where OF_State=0 and "+rbPrimaryID+"="+rbPrimaryIDValue+" ";String sql2="DELETE from BookPeople where BP_State=0 and BP_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql3="DELETE from Voyage where Voyage_State=0 and Voyage_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql4="DELETE from FrequentFlyer where FF_State=0 and FF_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql5="DELETE from Contact where Contact_State=0 and Contact_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql6="DELETE from RECYCLEBIN where RB_ID="+rbId+" "; stmt.addBatch(sql1);
stmt.addBatch(sql2);
stmt.addBatch(sql3);
stmt.addBatch(sql4);
stmt.addBatch(sql5);
stmt.addBatch(sql6);
int[] is = stmt.executeBatch();
for (int i = 0; i < is.length; i++) {
System.out.println(is[i]);
}
conn.commit(); // 统一提交
conn.setAutoCommit(true);// 恢复JDBC事务的默认提交方式怎么只执行第一句和最后一句啊,急啊,各位高手帮帮忙啊!
conn = dbTools.getConnection(); // 链接数据库
conn.setAutoCommit(false);
stmt = conn.createStatement();
String sql1="DELETE from OrderForm where OF_State=0 and "+rbPrimaryID+"="+rbPrimaryIDValue+" ";String sql2="DELETE from BookPeople where BP_State=0 and BP_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql3="DELETE from Voyage where Voyage_State=0 and Voyage_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql4="DELETE from FrequentFlyer where FF_State=0 and FF_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql5="DELETE from Contact where Contact_State=0 and Contact_OF_Number=(select OF_Number from OrderForm where "+rbPrimaryID+"="+rbPrimaryIDValue+") ";String sql6="DELETE from RECYCLEBIN where RB_ID="+rbId+" "; stmt.addBatch(sql1);
stmt.addBatch(sql2);
stmt.addBatch(sql3);
stmt.addBatch(sql4);
stmt.addBatch(sql5);
stmt.addBatch(sql6);
int[] is = stmt.executeBatch();
for (int i = 0; i < is.length; i++) {
System.out.println(is[i]);
}
conn.commit(); // 统一提交
conn.setAutoCommit(true);// 恢复JDBC事务的默认提交方式怎么只执行第一句和最后一句啊,急啊,各位高手帮帮忙啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货