test/jdbc/DatabaseMetadata/DataMeta3.java

   1 //Index Information
   2 import java.sql.*;
   3 public class DataMeta3
   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", "root", "manager");
  11            Statement cStmt = con.createStatement();
  12            cStmt.execute("CREATE TABLE t1 (f1 integer, f2 char (20),primary key(f2));");
  13            cStmt.execute("CREATE INDEX IDX ON t1 ( f1);");
  14            con.commit();
  15
  16           ResultSet indexInformation = null;
  17           DatabaseMetaData meta = con.getMetaData();
  18           indexInformation = meta.getIndexInfo(null, null, "t1", true, true);
  19           System.out.println("================= INDEXINFO ================");
  20           while (indexInformation.next()) {
  21           String dbCatalog = indexInformation.getString(1);
  22           String dbSchema = indexInformation.getString(2);
  23           String dbTableName = indexInformation.getString(3);
  24           //boolean dbNoneUnique = indexInformation.getBoolean(4);
  25           String dbIndexName = indexInformation.getString(6);
  26           short dbType = indexInformation.getShort(7);
  27           short dbOrdinalPosition = indexInformation.getShort(8);
  28           String dbColumnName = indexInformation.getString(9);
  29           System.out.println("index name=" + dbIndexName);
  30           System.out.println("table=" + dbTableName);
  31           System.out.println("column=" + dbColumnName);
  32           System.out.println("catalog=" + dbCatalog);
  33           System.out.println("schema=" + dbSchema);
  34           //System.out.println("nonUnique=" + dbNoneUnique);
  35           System.out.println("type=" + dbType);
  36           System.out.println("ordinalPosition=" + dbOrdinalPosition);
  37           System.out.println("================= @#####@ ================");
  38         }
  39            cStmt.execute("DROP TABLE t1 ;");
  40            con.close();
  41         }catch(Exception e) {
  42             System.out.println("Exception in Test: "+e);
  43             e.printStackTrace();
  44         }
  45     }
  46 }