test/jdbc/ResultSetMetaData/RSMetadata2.java

   1 //Test Script for getColumnDisplaySize,getColumnLabel,getColumnName,getColumnType,getColumnTypeName,getColumnClassName,getTableName,isNullable Taking 9 different type of field
   2 import java.sql.*;
   3 public class RSMetadata2
   4 {
   5     public static void main(String[] arg)
   6     {
   7         try
   8         {
   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);");
  13             con.commit();
  14             PreparedStatement stmt=null,selStmt=null;
  15             stmt=con.prepareStatement("INSERT INTO T1 VALUES(?,?,?,?,?,?,?,?,?);");
  16             int ret=0;
  17             for(int i=0;i<10;i++)
  18             {
  19                 stmt.setInt(1,i);
  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();
  29                 if(ret!=1) break;
  30             }
  31             stmt.close();
  32             con.commit();
  33             selStmt=con.prepareStatement("Select * from T1");
  34             ResultSet rs=null;
  35             rs=selStmt.executeQuery();
  36
  37            System.out.println("SELECT * from T1 ;");
  38            System.out.println();
  39
  40            ResultSetMetaData rsMetaData = rs.getMetaData();
  41
  42            int numberOfColumns = rsMetaData.getColumnCount();
  43            System.out.println("resultSet MetaData column Count=" + numberOfColumns);
  44
  45            for (int i = 1; i <= numberOfColumns; i++)
  46            {
  47
  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("=============================== ");
  61           }
  62
  63
  64
  65             while(rs.next())
  66             {
  67                 System.out.println("Tuple value is " + rs.getInt(1) + " "+
  68                                                         rs.getShort(2) + " "+
  69                                                         rs.getByte(3) + " "+
  70                                                         rs.getLong(4) + " "+
  71                                                         rs.getFloat(5) + " "+
  72                                                         rs.getString(6) + " "+
  73                                                         rs.getDate(7) + " "+
  74                                                         rs.getTime(8) + " "+
  75                                                         rs.getTimestamp(9) + " "
  76                                                         );
  77
  78             }
  79             rs.close();
  80             con.commit();
  81             ret=0;
  82             selStmt=con.prepareStatement("Select f9,f2,f4,f5,f7,f1,f8,f6,f3 from T1");
  83             rs=null;
  84             rs=selStmt.executeQuery();
  85             System.out.println();
  86
  87            System.out.println("SELECT f9,f2,f4,f5,f7,f1,f8,f6,f3 from T1 ;");
  88            System.out.println();
  89
  90            rsMetaData = rs.getMetaData();
  91
  92            numberOfColumns = rsMetaData.getColumnCount();
  93            System.out.println("resultSet MetaData column Count=" + numberOfColumns);
  94
  95            for (int i = 1; i <= numberOfColumns; i++)
  96            {
  97
  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("=============================== ");
 111           }
 112
 113             while(rs.next())
 114             {
 115                 System.out.println("Tuple value is " + rs.getInt(6) + " "+
 116                                                         rs.getShort(2) + " "+
 117                                                         rs.getByte(9) + " "+
 118                                                         rs.getLong(3) + " "+
 119                                                         rs.getFloat(4) + " "+
 120                                                         rs.getString(8) + " "+
 121                                                         rs.getDate(5) + " "+
 122                                                         rs.getTime(7) + " "+
 123                                                         rs.getTimestamp(1) + " "
 124                                                         );
 125
 126             }
 127             rs.close();
 128             con.commit();
 129             cStmt.executeUpdate("Drop table T1;");
 130             con.close();
 131        }catch(Exception e) {
 132             System.out.println("Exception in Test: "+e);
 133             e.printStackTrace();
 134         }
 135     }
 136 }
 137