1 //donot run csql server
2 //update tuple with WHERE clause having param for all fields(UPDATE t1 SET f2=100 WHERE f1=?AND f3=?....)
8 public class GwTest15
{
9 public static void main(String
[] arg
)
13 Class
.forName("csql.jdbc.JdbcSqlDriver");
14 Connection con
=DriverManager
.getConnection("jdbc:gateway","root","manager");
15 Statement cStmt
=con
.createStatement();
16 PreparedStatement stmt
=null,selStmt
=null;
17 stmt
=con
.prepareStatement("INSERT INTO t1 VALUES(?,?,?,?,?,?,?,?,?);");
22 stmt
.setShort(2,(short)(i
+1));
23 stmt
.setByte(3,(byte)(i
+2));
24 stmt
.setLong(4,(long)i
);
25 stmt
.setFloat(5,(float)1000+i
);
26 stmt
.setString(6, String
.valueOf("Cache"+i
));
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 ret
=stmt
.executeUpdate();
35 selStmt
=con
.prepareStatement("Select * from t1");
37 rs
=selStmt
.executeQuery();
40 System
.out
.println("Tuple value is " + rs
.getInt(1) + " "+
45 rs
.getString(6) + " "+
48 rs
.getTimestamp(9) + " "
55 stmt
=con
.prepareStatement("UPDATE t1 SET f2=?, f8=? WHERE f1=?AND f9=?;");
58 stmt
.setShort(1,(short)100);
59 stmt
.setTime(2,Time
.valueOf("19:38:25"));
61 stmt
.setTimestamp(4,Timestamp
.valueOf("2008-03-21 18:00:00"));
62 ret
=stmt
.executeUpdate();
67 selStmt
=con
.prepareStatement("Select * from t1");
69 rs
=selStmt
.executeQuery();
73 System
.out
.println("Tuple value is " + rs
.getInt(1) + " "+
78 rs
.getString(6) + " "+
81 rs
.getTimestamp(9) + " "
89 System
.out
.println("Exception in Test: "+e
);