StringBuffer sqldd = new StringBuffer("delete from dingdanb where ddh='");
sqldd.append(getDdh());
sqldd.append("'");
StringBuffer sqlDelete = new StringBuffer("delete from ghmxb where ddh='"); //清空购物车
sqlDelete.append(getDdh());
sqlDelete.append("'");
try {
Connection connection = DriverManager.getConnection(sConnStr, user, pwd)
getConnection().setAutoCommit(false);
Statement st = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sqldd.toString());
st.executeUpdate(sqlDelete.toString());
getConnection().commit();//提交JDBC事务
getConnection().setAutoCommit(true);// 恢复JDBC事务的默认提交方式
st.close();
//closeStatement();
closeConnection();
} catch (Exception e) {
try {
getConnection().rollback();
st.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
e.printStackTrace();
//closeStatement();
closeConnection();
}
可是出错后 第一条sql语名执行成功,第二条出错,但第一个表的数据被删除了,但第二个表没删除
sqldd.append(getDdh());
sqldd.append("'");
StringBuffer sqlDelete = new StringBuffer("delete from ghmxb where ddh='"); //清空购物车
sqlDelete.append(getDdh());
sqlDelete.append("'");
try {
Connection connection = DriverManager.getConnection(sConnStr, user, pwd)
getConnection().setAutoCommit(false);
Statement st = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sqldd.toString());
st.executeUpdate(sqlDelete.toString());
getConnection().commit();//提交JDBC事务
getConnection().setAutoCommit(true);// 恢复JDBC事务的默认提交方式
st.close();
//closeStatement();
closeConnection();
} catch (Exception e) {
try {
getConnection().rollback();
st.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
e.printStackTrace();
//closeStatement();
closeConnection();
}
可是出错后 第一条sql语名执行成功,第二条出错,但第一个表的数据被删除了,但第二个表没删除
..........
..........
}type=innodb;