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 INDEX IDX ON t1 ( f1);");
16 DatabaseMetaData meta
= con
.getMetaData();
17 rs
= meta
.getPrimaryKeys(null, null, "t1");
20 String columnName
= rs
.getString(4);
21 System
.out
.println("getPrimaryKeys(): columnName=" + columnName
);
22 short pos
=rs
.getShort(5);
23 System
.out
.println("getPrimaryKeys(): position = " + pos
);
26 cStmt
.execute("DROP TABLE t1 ;");
29 System
.out
.println("Exception in Test: "+e
);