dbframe.java~1~

本系统是利用JBUILDER实现一个数据库浏览器

package dbview;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.*;
import com.borland.dx.dataset.*;
import com.borland.jbcl.control.*;
import java.util.*;

/**
 * Title:        数据库浏览器
 * Description:  这是一个使用dbSwing组件设计完成的数据库浏览程序
 * Copyright:    Copyright (c) 2001
 * Company:
 * @author
 * @version 1.0
 */

public class dbFrame extends JFrame {
  ResourceBundle sqlRes = ResourceBundle.getBundle("dbview.SqlRes");
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  Database dbSet = new Database();
  JPanel jPanelMain = new JPanel();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanelChange = new JPanel();
  JButton saveChange = new JButton();
  QueryDataSet queryDataSet = new QueryDataSet();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  JdbTable dbTablePub = new JdbTable();
  TableScrollPane tableScrollPane = new TableScrollPane();

  /**Construct the frame*/
  public dbFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  /**Component initialization*/
  private void jbInit() throws Exception  {
    //setIconImage(Toolkit.getDefaultToolkit().createImage(dbFrame.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    dbSet.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:JavaTest", "sa", "java", false, "sun.jdbc.odbc.JdbcOdbcDriver"));

    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("数据库浏览器");
    jPanelMain.setLayout(borderLayout2);
    saveChange.setText("Save Change");
    saveChange.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        saveChange_actionPerformed(e);
      }
    });

    queryDataSet.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(dbSet, sqlRes.getString("Publishers"), null, true, Load.ALL));
    queryDataSet.addOpenListener(new com.borland.dx.dataset.OpenAdapter() {
      public void opened(DataSet dataSet) {
        queryDataSet_opened(dataSet);
      }
    });
    jdbNavToolBar1.setDataSet(queryDataSet);
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jdbStatusLabel1.setDataSet(queryDataSet);
    dbTablePub.setDataSet(queryDataSet);
    contentPane.add(jPanelMain,  BorderLayout.CENTER);
    jPanelMain.add(jdbNavToolBar1, BorderLayout.NORTH);
    jPanelMain.add(jPanelChange,  BorderLayout.SOUTH);
    jPanelChange.add(saveChange, null);
    jPanelMain.add(tableScrollPane,  BorderLayout.CENTER);
    tableScrollPane.add(dbTablePub, null);
    contentPane.add(jdbStatusLabel1, BorderLayout.SOUTH);
  }
  /**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);
    }
  }


  void queryDataSet_opened(DataSet dataSet) {
    queryDataSet.first();
  }

  void saveChange_actionPerformed(ActionEvent e) {
    dbSet.saveChanges(queryDataSet);
  }
}