test/jdbc/ResultSetMetaData/RSMetadata1.java

   1 //Test DML statement
   2 //Test Script for getColumnDisplaySize,getColumnLabel,getColumnName,getColumnType,getColumnTypeName,getColumnClassName,getTableName,isNullable takeing two Field
   3 import java.sql.*;
   4 public class RSMetadata1
   5 {
   6     public static void main(String[] args)
   7     {
   8        try
   9        {
  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);");
  15            con.commit();
  16            PreparedStatement stmt = null, selStmt= null;
  17            stmt = con.prepareStatement("INSERT INTO T1 VALUES (?, ?);");
  18            for (int j =0 ; j< 10 ; j++) {
  19              stmt.setInt(1, j);
  20              stmt.setString(2, String.valueOf(j+100));
  21              stmt.executeUpdate();
  22            }
  23            stmt.close();
  24            con.commit();
  25            selStmt = con.prepareStatement("SELECT f2,f1 from T1 ;");
  26            ResultSet rs = null;
  27            rs = selStmt.executeQuery();
  28
  29            System.out.println("SELECT f2,f1 from T1 ;");
  30            System.out.println();
  31            ResultSetMetaData rsMetaData = rs.getMetaData();
  32
  33            int numberOfColumns = rsMetaData.getColumnCount();
  34            System.out.println("resultSet MetaData column Count=" + numberOfColumns);
  35
  36            for (int i = 1; i <= numberOfColumns; i++)
  37            {
  38
  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("=============================== ");
  52           }
  53           while (rs.next())
  54           {
  55               System.out.println("Tuple value is " + rs.getInt(2)+ " "+ rs.getString(1));
  56           }
  57           rs.close();
  58
  59            selStmt = con.prepareStatement("SELECT * from T1 ;");
  60            rs = selStmt.executeQuery();
  61            System.out.println("SELECT * from T1 ;");
  62            System.out.println();
  63
  64            rsMetaData = rs.getMetaData();
  65
  66            numberOfColumns = rsMetaData.getColumnCount();
  67            System.out.println("resultSet MetaData column Count=" + numberOfColumns);
  68
  69            for (int i = 1; i <= numberOfColumns; i++)
  70            {
  71
  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("=============================== ");
  85           }
  86           while (rs.next())
  87           {
  88               System.out.println("Tuple value is " + rs.getInt(1)+ " "+ rs.getString(2));
  89           }
  90           rs.close();
  91
  92           cStmt.execute("DROP TABLE T1 ;");
  93           con.close();
  94         }catch(Exception e) {
  95              System.out.println("Exception in Test: "+e);
  96              e.printStackTrace();
  97         }
  98     }
  99 }