1 //Test Script for getColumnDisplaySize,getColumnLabel,getColumnName,getColumnType,getColumnTypeName,getColumnClassName,getTableName,isNullable Taking 9 different type of field
3 public class RSMetadata2
5 public static void main(String
[] arg
)
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 smallint, f3 tinyint, f4 bigint, f5 float, f6 char(10), f7 date, f8 time, f9 timestamp);");
14 PreparedStatement stmt
=null,selStmt
=null;
15 stmt
=con
.prepareStatement("INSERT INTO T1 VALUES(?,?,?,?,?,?,?,?,?);");
20 stmt
.setShort(2,(short)(i
+1));
21 stmt
.setByte(3,(byte)(i
+2));
22 stmt
.setLong(4,(long)i
);
23 stmt
.setFloat(5,(float)1000+i
);
24 stmt
.setString(6, String
.valueOf("BIJAYA"+i
));
25 stmt
.setDate(7,Date
.valueOf("2008-03-21"));
26 stmt
.setTime(8,Time
.valueOf("18:00:00"));
27 stmt
.setTimestamp(9,Timestamp
.valueOf("2008-03-21 18:00:00"));
28 ret
=stmt
.executeUpdate();
33 selStmt
=con
.prepareStatement("Select * from T1");
35 rs
=selStmt
.executeQuery();
37 System
.out
.println("SELECT * from T1 ;");
40 ResultSetMetaData rsMetaData
= rs
.getMetaData();
42 int numberOfColumns
= rsMetaData
.getColumnCount();
43 System
.out
.println("resultSet MetaData column Count=" + numberOfColumns
);
45 for (int i
= 1; i
<= numberOfColumns
; i
++)
48 System
.out
.println("=============================== ");
49 System
.out
.println("RESULT SET METADATA ");
50 System
.out
.println("=============================== ");
51 System
.out
.println("column number = " + i
);
52 System
.out
.println("DisplaySize = "+rsMetaData
.getColumnDisplaySize(i
));
53 System
.out
.println("ColumnLabel = "+rsMetaData
.getColumnLabel(i
));
54 System
.out
.println("ColumnName = "+rsMetaData
.getColumnName(i
));
55 System
.out
.println("ColumnType = "+rsMetaData
.getColumnType(i
));
56 System
.out
.println("TypeName = "+rsMetaData
.getColumnTypeName(i
));
57 System
.out
.println("ClassName = "+rsMetaData
.getColumnClassName(i
));
58 System
.out
.println("TableName = "+rsMetaData
.getTableName(i
));
59 System
.out
.println("sNullable = "+rsMetaData
.isNullable(i
));
60 System
.out
.println("=============================== ");
67 System
.out
.println("Tuple value is " + rs
.getInt(1) + " "+
72 rs
.getString(6) + " "+
75 rs
.getTimestamp(9) + " "
82 selStmt
=con
.prepareStatement("Select f9,f2,f4,f5,f7,f1,f8,f6,f3 from T1");
84 rs
=selStmt
.executeQuery();
87 System
.out
.println("SELECT f9,f2,f4,f5,f7,f1,f8,f6,f3 from T1 ;");
90 rsMetaData
= rs
.getMetaData();
92 numberOfColumns
= rsMetaData
.getColumnCount();
93 System
.out
.println("resultSet MetaData column Count=" + numberOfColumns
);
95 for (int i
= 1; i
<= numberOfColumns
; i
++)
98 System
.out
.println("=============================== ");
99 System
.out
.println("RESULT SET METADATA ");
100 System
.out
.println("=============================== ");
101 System
.out
.println("column number = " + i
);
102 System
.out
.println("DisplaySize = "+rsMetaData
.getColumnDisplaySize(i
));
103 System
.out
.println("ColumnLabel = "+rsMetaData
.getColumnLabel(i
));
104 System
.out
.println("ColumnName = "+rsMetaData
.getColumnName(i
));
105 System
.out
.println("ColumnType = "+rsMetaData
.getColumnType(i
));
106 System
.out
.println("TypeName = "+rsMetaData
.getColumnTypeName(i
));
107 System
.out
.println("ClassName = "+rsMetaData
.getColumnClassName(i
));
108 System
.out
.println("TableName = "+rsMetaData
.getTableName(i
));
109 System
.out
.println("sNullable = "+rsMetaData
.isNullable(i
));
110 System
.out
.println("=============================== ");
115 System
.out
.println("Tuple value is " + rs
.getInt(6) + " "+
116 rs
.getShort(2) + " "+
119 rs
.getFloat(4) + " "+
120 rs
.getString(8) + " "+
123 rs
.getTimestamp(1) + " "
129 cStmt
.executeUpdate("Drop table T1;");
131 }catch(Exception e
) {
132 System
.out
.println("Exception in Test: "+e
);