test/jdbc/DatabaseMetadata/DataMeta4.java

   1 //Primaykeyinfo
   2 import java.sql.*;
   3 public class DataMeta4
   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           ResultSet rs = null;
  16           DatabaseMetaData meta = con.getMetaData();
  17           rs = meta.getPrimaryKeys(null, null, "t1");
  18
  19           while (rs.next()) {
  20               String columnName = rs.getString(4);
  21               System.out.println("getPrimaryKeys(): columnName=" + columnName);
  22               short pos=rs.getShort(5);
  23               System.out.println("getPrimaryKeys(): position = " + pos);
  24           }
  25            rs.close();
  26            cStmt.execute("DROP TABLE t1 ;");
  27            con.close();
  28         }catch(Exception e) {
  29             System.out.println("Exception in Test: "+e);
  30             e.printStackTrace();
  31         }
  32     }
  33 }