test/jdbc/network/Statement/TestScript9.java

   1
   2 //execute with select and getResultSet(). getUpdateCount() should return -1.
   3 import java.sql.*;
   4
   5 /**
   6  *
   7  * @author bijaya
   8  */
   9 public class TestScript9 {
  10      public static void main(String[] args)
  11     {
  12        try
  13        {
  14            Class.forName("csql.jdbc.JdbcSqlDriver");
  15            Connection con = DriverManager.getConnection("jdbc:csql://localhost:5678", "root", "manager");
  16            Statement cStmt = con.createStatement();
  17            cStmt.execute("CREATE TABLE T1 (f1 integer, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);");
  18            con.commit();
  19            PreparedStatement stmt = null, selStmt= null;
  20            stmt = con.prepareStatement("INSERT INTO T1 VALUES (?,?,?,?,?,?,?,?,?);");
  21            stmt.setInt(1, 1);
  22            stmt.setShort(2,(short)2);
  23            stmt.setByte(3,(byte)3);
  24            stmt.setLong(4,(long)4);
  25            stmt.setFloat(5,(float)5);
  26            stmt.setString(6, String.valueOf(5));
  27            stmt.setDate(7,Date.valueOf("2008-03-21"));
  28            stmt.setTime(8,Time.valueOf("18:00:00"));
  29            stmt.setTimestamp(9,Timestamp.valueOf("2008-03-21 18:00:00"));
  30            stmt.executeUpdate();
  31            stmt.close();
  32            con.commit();
  33
  34            cStmt = con.createStatement();
  35            cStmt.execute("SELECT * from T1;");
  36            ResultSet rs=cStmt.getResultSet();
  37            int retval=cStmt.getUpdateCount();
  38            if(retval!=-1)
  39            {
  40                System.out.println("Update count not returning -1 ");
  41                System.exit(1);
  42            } else
  43            {
  44                System.out.println("Update count returning -1 ");
  45            }
  46            while (rs.next())
  47            {
  48                  System.out.println("Tuple value is " + rs.getInt(1) + " "+
  49                                                         rs.getShort(2) + " "+
  50                                                         rs.getByte(3) + " "+
  51                                                         rs.getLong(4) + " "+
  52                                                         rs.getFloat(5) + " "+
  53                                                         rs.getString(6) + " "+
  54                                                         rs.getDate(7) + " "+
  55                                                         rs.getTime(8) + " "+
  56                                                         rs.getTimestamp(9) + " "
  57                                                         );
  58            }
  59            rs.close();
  60            cStmt.close();
  61
  62            cStmt.execute("DROP TABLE T1 ;");
  63            con.close();
  64         }catch(Exception e) {
  65              System.out.println("Exception in Test: "+e);
  66              e.printStackTrace();
  67         }
  68     }
  69
  70 }