test/jdbc/Statement/StmtTest5.java

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