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));");
14 ResultSet rsColumns
= null;
15 DatabaseMetaData meta
= con
.getMetaData();
16 rsColumns
= meta
.getColumns(null, null, "t1", null);
17 while (rsColumns
.next()) {
18 String columnName
= rsColumns
.getString(4);
19 System
.out
.println("column name=" + columnName
);
20 int columnType
= rsColumns
.getInt(5);
21 System
.out
.println("type:" + columnType
);
22 int size
= rsColumns
.getInt(7);
23 System
.out
.println("size:" + size
);
24 int nullable
= rsColumns
.getInt(11);
25 if (nullable
== DatabaseMetaData
.columnNullable
)
27 System
.out
.println("nullable true");
29 System
.out
.println("nullable false");
31 int position
= rsColumns
.getInt(17);
32 System
.out
.println("position:" + position
);
36 cStmt
.execute("DROP TABLE t1 ;");
39 System
.out
.println("Exception in Test: "+e
);