5 public static void main(String
[] args
)
9 Class
.forName("csql.jdbc.JdbcSqlDriver");
10 Connection con
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
11 Statement cStmt
= con
.createStatement();
12 cStmt
.execute("CREATE TABLE t1 (f1 integer, f2 char (20),primary key(f2));");
13 cStmt
.execute("CREATE TABLE t2(f1 integer, f2 char (20),primary key(f2));");
14 cStmt
.execute("CREATE TABLE emp(f1 integer, f2 char (20),primary key(f2));");
15 cStmt
.execute("CREATE TABLE data(f1 integer, f2 char (20),primary key(f2));");
19 rs = cStmt.executeQuery("GetAllTables");
22 System.out.println("tables is " + rs.getString(3));
26 ResultSet rsColumns
= null;
27 DatabaseMetaData meta
= con
.getMetaData();
28 rsColumns
= meta
.getTables(null, null, null, null);
29 while (rsColumns
.next()) {
30 String columnName
= rsColumns
.getString(3);
31 System
.out
.println("Table name = " + columnName
);
34 cStmt
.execute("DROP TABLE t1 ;");
35 cStmt
.execute("DROP TABLE t2 ;");
36 cStmt
.execute("DROP TABLE emp ;");
37 cStmt
.execute("DROP TABLE data ;");
40 System
.out
.println("Exception in Test: "+e
);