2 //execute with ins,upd,del and getUpdateCount(). getResultSet() should return null.
4 import java
.sql
.Connection
;
5 import java
.sql
.DriverManager
;
6 import java
.sql
.ResultSet
;
7 import java
.sql
.Statement
;
13 public class TestScript8
{
14 public static void main(String
[] args
)
18 Class
.forName("csql.jdbc.JdbcSqlDriver");
19 Connection con
= DriverManager
.getConnection("jdbc:csql://localhost:5678", "root", "manager");
20 Statement cStmt
= con
.createStatement();
21 cStmt
.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
24 for(int i
=0;i
<10;i
++){
25 cStmt
.execute("INSERT INTO T1 VALUES (1, 'FIRST');");
28 rs
=cStmt
.getResultSet();
30 System
.out
.println(" Not return a result set for insert statement");
32 System
.out
.println(" Test Case Failed");
36 rs
= cStmt
.executeQuery("SELECT * from T1 ;");
39 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
43 cStmt
.executeUpdate("UPDATE T1 SET f2 = 'CHANGED' WHERE f1 <4;");
44 int cout
=cStmt
.getUpdateCount();
45 System
.out
.println("Total update: "+cout
);
46 rs
=cStmt
.getResultSet();
48 System
.out
.println(" Not return a result set for update statement");
50 System
.out
.println(" Test Case Failed");
52 cStmt
.execute("SELECT * from T1 ;");
53 rs
= cStmt
.getResultSet();
56 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
61 cStmt
.executeUpdate("DELETE FROM T1 WHERE f1 <5;");
62 cout
=cStmt
.getUpdateCount();
63 System
.out
.println("Total delete: "+cout
);
64 rs
=cStmt
.getResultSet();
66 System
.out
.println(" Not return a result set for delete statement");
68 System
.out
.println(" Test Case Failed");
71 System
.out
.println("After delete, listing tuples:");
72 rs
= cStmt
.executeQuery("SELECT * from T1 ;");
75 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
79 cStmt
.execute("DROP TABLE T1 ;");
82 System
.out
.println("Exception in Test: "+e
);