test/jdbc/Statement/TestScript11.java

   1 //execute with select ,close  statement and call getResultSet(). it should not give result set
   2 import java.sql.*;
   3 /**
   4  *
   5  * @author bijaya
   6  */
   7 public class TestScript11 {
   8  public static void main(String[] args)
   9     {
  10        try
  11        {
  12            Class.forName("csql.jdbc.JdbcSqlDriver");
  13            Connection con = DriverManager.getConnection("jdbc:csql", "root", "manager");
  14            Statement cStmt = con.createStatement();
  15            cStmt.execute("CREATE TABLE T1 (f1 integer, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);");
  16            con.commit();
  17            PreparedStatement stmt = null, selStmt= null;
  18            stmt = con.prepareStatement("INSERT INTO T1 VALUES (?,?,?,?,?,?,?,?,?);");
  19            stmt.setInt(1, 1);
  20            stmt.setShort(2,(short)2);
  21            stmt.setByte(3,(byte)3);
  22            stmt.setLong(4,(long)4);
  23            stmt.setFloat(5,(float)5);
  24            stmt.setString(6, String.valueOf(5));
  25            stmt.setDate(7,Date.valueOf("2008-03-21"));
  26            stmt.setTime(8,Time.valueOf("18:00:00"));
  27            stmt.setTimestamp(9,Timestamp.valueOf("2008-03-21 18:00:00"));
  28            stmt.executeUpdate();
  29            stmt.close();
  30            con.commit();
  31
  32            cStmt = con.createStatement();
  33            cStmt.execute("SELECT * from T1;");
  34            cStmt.close();
  35            ResultSet rs=cStmt.getResultSet();
  36            if(rs==null)
  37            {
  38                 System.out.println("Test case Passed ");
  39                 cStmt = con.createStatement();
  40                 cStmt.execute("DROP TABLE T1 ;");
  41                 con.close();
  42                 System.exit(0);
  43            }else
  44            {
  45                System.out.println("Test case failed");
  46                cStmt = con.createStatement();
  47                cStmt.execute("DROP TABLE T1 ;");
  48                con.close();
  49                System.exit(1);
  50            }
  51
  52
  53         }catch(Exception e) {
  54              System.out.println("Exception in Test: "+e);
  55              e.printStackTrace();
  56         }
  57     }
  58 }