一、事务简介:
开启事务
提交事务
回滚事务
二、通过代码实现
mport cm.bzcxy.JDBCutils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class bankTest {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement psmt =null;
try{
conn = JDBCutils.getconnection();
conn.setAutoCommit(false);
String sql ="update bank set balance = balance + ? where accountname = ?";
psmt =conn.prepareStatement(sql);
psmt.setObject(1,500);
psmt.setObject(2,"lisi");
psmt.executeUpdate();
psmt.setObject(1,-500);
psmt.setObject(2,"zhangsan");
psmt.executeUpdate();
conn.commit();
}catch (Exception e){
try {
conn.rollback();
} catch (SQLException ex) {
ex.printStackTrace();
}
}finally {
try {
JDBCutils.close(conn,psmt);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
代码仅供参考