2 //executequery with ins, upd, del statements which will throw exception
4 import java
.sql
.Connection
;
5 import java
.sql
.DriverManager
;
6 import java
.sql
.PreparedStatement
;
7 import java
.sql
.ResultSet
;
8 import java
.sql
.Statement
;
14 public class TestScript7
{
15 public static void main(String
[] args
)
19 Class
.forName("csql.jdbc.JdbcSqlDriver");
20 Connection con
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
21 Statement cStmt
= con
.createStatement();
22 cStmt
.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
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 ;");
35 rs
= selStmt
.executeQuery();
38 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
43 stmt
= con
.prepareStatement("UPDATE T1 SET f2 = ? WHERE f1 = ?;");
44 for (int i
=0 ; i
< 10 ; i
+=2) {
45 stmt
.setString(1, String
.valueOf(i
+200));
53 System
.out
.println("After update, listing tuples:");
55 rs
= selStmt
.executeQuery();
58 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
63 stmt
= con
.prepareStatement("DELETE FROM T1 WHERE f1 = ?;");
64 for (int i
=0 ; i
< 10 ; i
+=3) {
72 System
.out
.println("After delete, listing tuples:");
74 rs
= selStmt
.executeQuery();
77 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
82 cStmt
.execute("DROP TABLE T1 ;");
85 System
.out
.println("Exception in Test: "+e
);