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 ResultSet indexInformation
= null;
17 DatabaseMetaData meta
= con
.getMetaData();
18 indexInformation
= meta
.getIndexInfo(null, null, "t1", true, true);
19 System
.out
.println("================= INDEXINFO ================");
20 while (indexInformation
.next()) {
21 String dbCatalog
= indexInformation
.getString(1);
22 String dbSchema
= indexInformation
.getString(2);
23 String dbTableName
= indexInformation
.getString(3);
24 //boolean dbNoneUnique = indexInformation.getBoolean(4);
25 String dbIndexName
= indexInformation
.getString(6);
26 short dbType
= indexInformation
.getShort(7);
27 short dbOrdinalPosition
= indexInformation
.getShort(8);
28 String dbColumnName
= indexInformation
.getString(9);
29 System
.out
.println("index name=" + dbIndexName
);
30 System
.out
.println("table=" + dbTableName
);
31 System
.out
.println("column=" + dbColumnName
);
32 System
.out
.println("catalog=" + dbCatalog
);
33 System
.out
.println("schema=" + dbSchema
);
34 //System.out.println("nonUnique=" + dbNoneUnique);
35 System
.out
.println("type=" + dbType
);
36 System
.out
.println("ordinalPosition=" + dbOrdinalPosition
);
37 System
.out
.println("================= @#####@ ================");
39 cStmt
.execute("DROP TABLE t1 ;");
42 System
.out
.println("Exception in Test: "+e
);