2 //1. Donot run csqlserver
3 //Then do (INSERT/UPDATE/DELETE/SELECT) with params statement using gateway statement
5 import java
.sql
.Connection
;
6 import java
.sql
.DriverManager
;
7 import java
.sql
.PreparedStatement
;
8 import java
.sql
.ResultSet
;
9 import java
.sql
.Statement
;
16 public class GwTest10
{
17 public static void main(String
[] args
)
21 Class
.forName("csql.jdbc.JdbcSqlDriver");
22 Connection con
= DriverManager
.getConnection("jdbc:gateway", "root", "manager");
23 Statement cStmt
= con
.createStatement();
24 PreparedStatement stmt
= null, selStmt
= null;
25 stmt
= con
.prepareStatement("INSERT INTO t1 VALUES (?, ?);");
26 for (int i
=0 ; i
< 10 ; i
++) {
28 stmt
.setString(2, String
.valueOf(i
+100));
33 selStmt
= con
.prepareStatement("SELECT * from t1 where f1 = ?;");
35 for (int i
=0 ; i
< 10 ; i
++) {
37 rs
= selStmt
.executeQuery();
40 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
45 stmt
= con
.prepareStatement("UPDATE t1 SET f2 = ? WHERE f1 = ?;");
46 for (int i
=0 ; i
< 10 ; i
+=2) {
47 stmt
.setString(1, String
.valueOf(i
+200));
49 ret
= stmt
.executeUpdate();
54 System
.out
.println("After update, listing tuples:");
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));
65 stmt
= con
.prepareStatement("DELETE FROM t1 WHERE f1 = ?;");
66 for (int i
=0 ; i
< 10 ; i
+=3) {
68 ret
= stmt
.executeUpdate();
74 System
.out
.println("After delete, listing tuples:");
75 for (int i
=0 ; i
< 10 ; i
++) {
77 rs
= selStmt
.executeQuery();
80 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
87 System
.out
.println("Exception in Test: "+e
);