使用JDBC实现数据库的回滚:
实现步奏:
private static String driver=“com.mysql.jdbc.Driver”;
private static String url=“jdbc:mysql:///test”;
private static String user=“root”;
private static String password=“123456”;
Class.forName(driver);//加载数据库驱动
try{
Connection conn = DriverManager.getConnection(url, user, password);
try(PrepareStatement ps = conn.prepareStament(sql1)){
}catch(Exception e){
e.printStack();
conn.rollback();
}
try(PrepareStatement ps = conn.prepareStament(sql2)){
}catch(Eception e){
conn.rolback;
e.printStack();
}
}catch(Exception e){
e.printStack();
}
.
.
.
欢迎留言交流。