4 public static void main(String
[] args
)
8 Class
.forName("csql.jdbc.JdbcSqlDriver");
9 Connection con
= DriverManager
.getConnection("jdbc:gateway", "root", "manager");
10 Statement cStmt
= con
.createStatement();
12 PreparedStatement stmt
= null, selStmt
= null;
13 stmt
= con
.prepareStatement("INSERT INTO t1 (f1, f2) VALUES (?, ?);");
16 for (int i
=0 ; i
< 10 ; i
++) {
18 stmt
.setString(2, String
.valueOf(i
+100));
19 ret
= stmt
.executeUpdate();
20 if (ret
!= 1) break; //error
25 System
.out
.println("Total Rows inserted " + count
);
28 stmt
= con
.prepareStatement("UPDATE t1 SET f2 = ? WHERE f1 = ?;");
29 for (int i
=0 ; i
< 10 ; i
+=2) {
30 stmt
.setString(1, String
.valueOf(i
+200));
32 ret
= stmt
.executeUpdate();
33 if (ret
!= 1) break; //error
38 System
.out
.println("Total Rows updated " + count
);
41 stmt
= con
.prepareStatement("DELETE FROM t1 WHERE f1 = ?;");
42 for (int i
=0 ; i
< 10 ; i
+=3) {
44 ret
= stmt
.executeUpdate();
45 if (ret
!= 1) break; //error
50 System
.out
.println("Total Rows deleted " + count
);
53 selStmt
= con
.prepareStatement("SELECT * from t1 where f1 = ?;");
55 for (int i
=0 ; i
< 10 ; i
++) {
57 rs
= selStmt
.executeQuery();
60 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
67 System
.out
.println("Total Rows selected " + count
);
71 System
.out
.println("Exception in Test: "+e
);