package Demo;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Test {
public static void main(String[] args) {
Connection conn=null;
PreparedStatement ps=null;
try {
conn=DBUtils.getConnection();
//开启事务
conn.setAutoCommit(false);
String sql="delete from student where id= ?";
ps=conn.prepareStatement(sql);
ps.setInt(1, 13);
int count=ps.executeUpdate();
System.out.println(count);
//提交事务
conn.commit();
} catch (Exception e) {
try {
//回滚事务
if(null!=conn) {
conn.rollback();
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally {
DBUtils.close(ps, conn);
}
}
}