数据回滚实例

数据回滚

 public class DataBaseTransaction {
 Connection con = null;
 
 public void testTransaction(){
  try{
   con.setAutoCommit(false);
   Statement stmt = con.createStatement();
   for(int i=0; i<2; i++)
    stmt.execute("insert into user values(" + i +  ",'ddd',24)");
   System.out.println("before commit, the tables is :::::::");
   viewTable();
   con.commit();
   System.out.println("after commit, the table is ::::::::");
   viewTable();
  } catch (Exception e) {
   e.printStackTrace();
   System.out.println("error");
   try{
    con.rollback();
   }catch(SQLException se){
    System.out.println("fatal error occur");
   }
  }
 }
 
 public void viewTable(){
  try{
   ResultSet rst = con.createStatement().executeQuery("select * from user");
   while(rst.next()){
    System.out.println(rst.getString("id"));
   }
   rst.close();
  } catch(Exception e){
   e.printStackTrace();
  }
 }
 
 public static void main(String args[]) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException{
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  DataBaseTransaction test = new DataBaseTransaction();
  test.con = java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/test","root","123456");   //跟据各人的数据而定
  test.testTransaction();
 }
}