test/jdbc/network/DatabaseMetadata/DataMeta2.java

   1 //Columns information
   2 import java.sql.*;
   3 public class DataMeta2
   4 {
   5     public static void main(String[] args)
   6     {
   7        try
   8        {
   9            Class.forName("csql.jdbc.JdbcSqlDriver");
  10            Connection con = DriverManager.getConnection("jdbc:csql://localhost:5678", "root", "manager");
  11            Statement cStmt = con.createStatement();
  12            cStmt.execute("CREATE TABLE t1 (f1 integer, f2 char (20),primary key(f2));");
  13            con.commit();
  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)
  26               {
  27                 System.out.println("nullable true");
  28               } else {
  29                 System.out.println("nullable false");
  30               }
  31               int position = rsColumns.getInt(17);
  32               System.out.println("position:" + position);
  33
  34         }
  35
  36            cStmt.execute("DROP TABLE t1 ;");
  37            con.close();
  38         }catch(Exception e) {
  39             System.out.println("Exception in Test: "+e);
  40             e.printStackTrace();
  41         }
  42     }
  43 }