test/jdbc/Statement/TestScript8.java

   1
   2 //execute with ins,upd,del and getUpdateCount(). getResultSet() should return null.
   3
   4 import java.sql.Connection;
   5 import java.sql.DriverManager;
   6 import java.sql.ResultSet;
   7 import java.sql.Statement;
   8
   9 /**
  10  *
  11  * @author bijaya
  12  */
  13 public class TestScript8 {
  14  public static void main(String[] args)
  15     {
  16        try
  17        {
  18            Class.forName("csql.jdbc.JdbcSqlDriver");
  19            Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
  20            Statement cStmt = con.createStatement();
  21            cStmt.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
  22
  23            con.commit();
  24            for(int i=0;i<10;i++){
  25                cStmt.execute("INSERT INTO T1 VALUES (1, 'FIRST');");
  26            }
  27            ResultSet rs = null;
  28            rs=cStmt.getResultSet();
  29            if(rs==null)
  30                System.out.println(" Not return a result set for insert statement");
  31            else
  32                System.out.println(" Test Case Failed");
  33            con.commit();
  34
  35            rs = null;
  36            rs = cStmt.executeQuery("SELECT * from T1 ;");
  37            while (rs.next())
  38            {
  39                System.out.println("Tuple value is " + rs.getInt(1)+ " "+ rs.getString(2));
  40            }
  41            rs.close();
  42
  43            cStmt.executeUpdate("UPDATE T1 SET f2 = 'CHANGED' WHERE f1 <4;");
  44            int cout=cStmt.getUpdateCount();
  45            System.out.println("Total update: "+cout);
  46            rs=cStmt.getResultSet();
  47            if(rs==null)
  48                System.out.println(" Not return a result set for update statement");
  49            else
  50                System.out.println(" Test Case Failed");
  51            con.commit();
  52            cStmt.execute("SELECT * from T1 ;");
  53            rs = cStmt.getResultSet();
  54            while (rs.next())
  55            {
  56                System.out.println("Tuple value is " + rs.getInt(1)+ " "+ rs.getString(2));
  57            }
  58            rs.close();
  59            con.commit();
  60
  61            cStmt.executeUpdate("DELETE FROM T1 WHERE f1 <5;");
  62            cout=cStmt.getUpdateCount();
  63            System.out.println("Total delete: "+cout);
  64            rs=cStmt.getResultSet();
  65            if(rs==null)
  66                System.out.println(" Not return a result set for delete statement");
  67            else
  68                System.out.println(" Test Case Failed");
  69            con.commit();
  70
  71            System.out.println("After delete, listing tuples:");
  72            rs = cStmt.executeQuery("SELECT * from T1 ;");
  73            while (rs.next())
  74            {
  75                System.out.println("Tuple value is " + rs.getInt(1)+ " "+ rs.getString(2));
  76            }
  77            rs.close();
  78            con.commit();
  79            cStmt.execute("DROP TABLE T1 ;");
  80            con.close();
  81         }catch(Exception e) {
  82             System.out.println("Exception in Test: "+e);
  83             e.printStackTrace();
  84         }
  85     }
  86
  87 }