2 //Test Script for getColumnDisplaySize,getColumnLabel,getColumnName,getColumnType,getColumnTypeName,getColumnClassName,getTableName,isNullable takeing two Field
4 public class RSMetadata1
6 public static void main(String
[] args
)
10 Class
.forName("csql.jdbc.JdbcSqlDriver");
11 Connection con
= DriverManager
.getConnection("jdbc:csql", "root", "manager");
12 Statement cStmt
= con
.createStatement();
13 cStmt
.execute("CREATE TABLE T1 (f1 integer, f2 char (20));");
14 cStmt
.execute("CREATE INDEX IDX ON T1 ( f1);");
16 PreparedStatement stmt
= null, selStmt
= null;
17 stmt
= con
.prepareStatement("INSERT INTO T1 VALUES (?, ?);");
18 for (int j
=0 ; j
< 10 ; j
++) {
20 stmt
.setString(2, String
.valueOf(j
+100));
25 selStmt
= con
.prepareStatement("SELECT f2,f1 from T1 ;");
27 rs
= selStmt
.executeQuery();
29 System
.out
.println("SELECT f2,f1 from T1 ;");
31 ResultSetMetaData rsMetaData
= rs
.getMetaData();
33 int numberOfColumns
= rsMetaData
.getColumnCount();
34 System
.out
.println("resultSet MetaData column Count=" + numberOfColumns
);
36 for (int i
= 1; i
<= numberOfColumns
; i
++)
39 System
.out
.println("=============================== ");
40 System
.out
.println("RESULT SET METADATA ");
41 System
.out
.println("=============================== ");
42 System
.out
.println("column number = " + i
);
43 System
.out
.println("DisplaySize = "+rsMetaData
.getColumnDisplaySize(i
));
44 System
.out
.println("ColumnLabel = "+rsMetaData
.getColumnLabel(i
));
45 System
.out
.println("ColumnName = "+rsMetaData
.getColumnName(i
));
46 System
.out
.println("ColumnType = "+rsMetaData
.getColumnType(i
));
47 System
.out
.println("TypeName = "+rsMetaData
.getColumnTypeName(i
));
48 System
.out
.println("ClassName = "+rsMetaData
.getColumnClassName(i
));
49 System
.out
.println("TableName = "+rsMetaData
.getTableName(i
));
50 System
.out
.println("sNullable = "+rsMetaData
.isNullable(i
));
51 System
.out
.println("=============================== ");
55 System
.out
.println("Tuple value is " + rs
.getInt(2)+ " "+ rs
.getString(1));
59 selStmt
= con
.prepareStatement("SELECT * from T1 ;");
60 rs
= selStmt
.executeQuery();
61 System
.out
.println("SELECT * from T1 ;");
64 rsMetaData
= rs
.getMetaData();
66 numberOfColumns
= rsMetaData
.getColumnCount();
67 System
.out
.println("resultSet MetaData column Count=" + numberOfColumns
);
69 for (int i
= 1; i
<= numberOfColumns
; i
++)
72 System
.out
.println("=============================== ");
73 System
.out
.println("RESULT SET METADATA ");
74 System
.out
.println("=============================== ");
75 System
.out
.println("column number = " + i
);
76 System
.out
.println("DisplaySize = "+rsMetaData
.getColumnDisplaySize(i
));
77 System
.out
.println("ColumnLabel = "+rsMetaData
.getColumnLabel(i
));
78 System
.out
.println("ColumnName = "+rsMetaData
.getColumnName(i
));
79 System
.out
.println("ColumnType = "+rsMetaData
.getColumnType(i
));
80 System
.out
.println("TypeName = "+rsMetaData
.getColumnTypeName(i
));
81 System
.out
.println("ClassName = "+rsMetaData
.getColumnClassName(i
));
82 System
.out
.println("TableName = "+rsMetaData
.getTableName(i
));
83 System
.out
.println("sNullable = "+rsMetaData
.isNullable(i
));
84 System
.out
.println("=============================== ");
88 System
.out
.println("Tuple value is " + rs
.getInt(1)+ " "+ rs
.getString(2));
92 cStmt
.execute("DROP TABLE T1 ;");
95 System
.out
.println("Exception in Test: "+e
);