test/jdbc/Connection/ConnTest29.java

   1 //Create Connection, insert 1 tuple, call rollback. Repeat the steps(connec,insert,rollback) for 10K times.
   2 //Then connect and check whether 0 tuples are present.
   3 //Author: XieLiang
   4 import java.sql.*;
   5 public class ConnTest29
   6 {
   7     public static void main(String[] args)
   8     {
   9        try
  10        {
  11            Class.forName("csql.jdbc.JdbcSqlDriver");
  12            Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
  13            con.setAutoCommit(false);
  14            Statement cStmt = con.createStatement();
  15            PreparedStatement stmt = null;
  16            int ret = 0;
  17            cStmt.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
  18            con.commit();
  19            con.close();
  20            for (int i=0; i <10000; i++)
  21            {
  22                 con = DriverManager.getConnection("jdbc:csql","root","manager");
  23                 con.setAutoCommit(false);
  24                 stmt = con.prepareStatement("INSERT INTO T1 VALUES(?,?);");
  25                 stmt.setInt(1,1);
  26                 stmt.setString(2,"xieliangkingsoft");
  27                 ret = stmt.executeUpdate();
  28                 if(ret != 1)
  29                 {
  30                    System.out.println("test failed");
  31                    break;
  32                 }
  33                 stmt.close();
  34                 con.rollback();
  35                 con.close();
  36            }
  37            con = DriverManager.getConnection("jdbc:csql","root","manager");
  38            int count = 0;
  39            cStmt = con.createStatement();
  40            ResultSet rs = cStmt.executeQuery("SELECT * from T1;");
  41            while(rs.next())
  42            {
  43                     count++;
  44            }
  45            rs.close();
  46            System.out.println("Total rows selected " + count);
  47            cStmt.execute("DROP TABLE T1;");
  48            con.commit();
  49            con.close();
  50            if (count == 0) System.exit(0); else System.exit(1);
  51         }catch(Exception e) {
  52            System.out.println("Exception in Test: "+e);
  53            e.printStackTrace();
  54            System.exit(1);
  55         }
  56     }
  57 }