test/jdbc/DatabaseMetadata/DataMeta1.java

   1 //Show all tables
   2 import java.sql.*;
   3 public class DataMeta1
   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 TABLE t2(f1 integer, f2 char (20),primary key(f2));");
  14            cStmt.execute("CREATE TABLE emp(f1 integer, f2 char (20),primary key(f2));");
  15            cStmt.execute("CREATE TABLE data(f1 integer, f2 char (20),primary key(f2));");
  16            con.commit();
  17 /*
  18            ResultSet rs = null;
  19            rs = cStmt.executeQuery("GetAllTables");
  20            while (rs.next())
  21            {
  22                System.out.println("tables is " + rs.getString(3));
  23            }
  24            rs.close();
  25 */
  26            ResultSet rsColumns = null;
  27            DatabaseMetaData meta = con.getMetaData();
  28            rsColumns = meta.getTables(null, null, null, null);
  29            while (rsColumns.next()) {
  30               String columnName = rsColumns.getString(3);
  31               System.out.println("Table name = " + columnName);
  32            }
  33
  34            cStmt.execute("DROP TABLE t1 ;");
  35            cStmt.execute("DROP TABLE t2 ;");
  36            cStmt.execute("DROP TABLE emp ;");
  37            cStmt.execute("DROP TABLE data ;");
  38            con.close();
  39         }catch(Exception e) {
  40             System.out.println("Exception in Test: "+e);
  41             e.printStackTrace();
  42         }
  43     }
  44 }