displayalltableframe.java

java灵感设计

package displayalltable;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dbswing.*;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.*;
import java.sql.*;
import java.util.*;
import javax.swing.border.*;
/**
 * <p>Title: displayAllTable Demo</p>
 * <p>Description: This is a displayAllTable demo</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: d6-125</p>
 * @author Liujun
 * @version 1.0
 */

public class displayAllTableFrame extends JFrame {
  JPanel contentPane;
  XYLayout xYLayout1 = new XYLayout();
  JList jList1 = new JList();
  Database database1 = new Database();
  Border border1;

  //Construct the frame
  public displayAllTableFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    //setIconImage(Toolkit.getDefaultToolkit().createImage(displayAllTableFrame.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    border1 = BorderFactory.createBevelBorder(BevelBorder.RAISED,Color.white,Color.white,new Color(178, 178, 178),new Color(124, 124, 124));
    contentPane.setLayout(xYLayout1);
    this.setResizable(false);
    this.setSize(new Dimension(160, 180));
    this.setTitle("displayAllTable Frame Demo");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:borland:dslocal:L:\\jb6exam\\displayAllTable\\displayAllTable\\display.jds", "SYSDBA", "password", false, "com.borland.datastore.jdbc.DataStoreDriver"));
    database1.setDatabaseName("");
    //在此添加代码
      try
      {  DatabaseMetaData metadata = database1.getMetaData();//得到元数据
         ResultSet mrs = metadata.getTables(null, null, null,
            new String[] { "TABLE" });//从元数据中分解取得表名列表
            Vector vector1 =new Vector();//定义一个对象阵列
        while (mrs.next())//将表名列表添加到对象阵列中
              vector1.addElement(mrs.getString(3));
          mrs.close();
         jList1= new JList(vector1);//添加对象阵列到列表框
      }
      catch(Exception ei)
      {  JOptionPane.showMessageDialog(this, ei);//例外，显示出错信息。
      }
  //添加代码结束
    jList1.setBackground(Color.gray);
    jList1.setBorder(BorderFactory.createLoweredBevelBorder());
    contentPane.add(jList1,    new XYConstraints(12, 12, 135, 140));
 }
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }
}