1 //Select Data with Field name instead of position
3 import java
.sql
.Connection
;
5 import java
.sql
.DriverManager
;
6 import java
.sql
.PreparedStatement
;
7 import java
.sql
.ResultSet
;
8 import java
.sql
.Statement
;
10 import java
.sql
.Timestamp
;
15 public class TestScript6
{
16 public static void main(String
[] arg
)
20 Class
.forName("csql.jdbc.JdbcSqlDriver");
21 Connection con
= DriverManager
.getConnection("jdbc:csql://localhost:5678", "root", "manager");
22 Statement cStmt
=con
.createStatement();
23 cStmt
.execute("CREATE TABLE T1 (f1 integer, f2 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);");
25 PreparedStatement stmt
=null,selStmt
=null;
26 stmt
=con
.prepareStatement("INSERT INTO T1 VALUES(?,?,?,?,?,?,?,?,?);");
31 stmt
.setShort(2,(short)(i
+1));
32 stmt
.setByte(3,(byte)(i
+2));
33 stmt
.setLong(4,(long)i
);
34 stmt
.setFloat(5,(float)1000+i
);
35 stmt
.setString(6, String
.valueOf("Bijaya"+i
));
36 stmt
.setDate(7,Date
.valueOf("2008-03-21"));
37 stmt
.setTime(8,Time
.valueOf("18:00:00"));
38 stmt
.setTimestamp(9,Timestamp
.valueOf("2008-03-21 18:00:00"));
39 ret
=stmt
.executeUpdate();
44 selStmt
=con
.prepareStatement("SELECT * FROM T1 ;");
46 rs
=selStmt
.executeQuery();
49 System
.out
.println("Tuple value is " + rs
.getInt("f1") + " "+
50 rs
.getShort("f2") + " "+
51 rs
.getByte("f3") + " "+
52 rs
.getLong("f4") + " "+
53 rs
.getFloat("f5") + " "+
54 rs
.getString("f6") + " "+
55 rs
.getDate("f7") + " "+
56 rs
.getTime("f7") + " "+
57 rs
.getTimestamp("f9") + " "
62 System
.out
.println("");
63 selStmt
=con
.prepareStatement("SELECT * FROM T1 ;");
66 selStmt
.setShort(2,(short)3);
67 selStmt
.setByte(3,(byte)4);
68 rs
=selStmt
.executeQuery();
71 System
.out
.println("Tuple value is " + rs
.getInt(1) + " "+
76 rs
.getString(6) + " "+
79 rs
.getTimestamp(9) + " "
85 cStmt
.executeUpdate("Drop table T1;");
88 System
.out
.println("Exception in Test: "+e
);