frame1.java

java程序4.4.1--数据库综合实例样板（连接Access数据库）

package connaccessdb;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Frame1 extends JFrame {
  JPanel contentPane;
  Database database1 = new Database();
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  QueryDataSet queryDataSet2 = new QueryDataSet();
  QueryDataSet queryDataSet3 = new QueryDataSet();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  TableScrollPane tableScrollPane2 = new TableScrollPane();
  TableScrollPane tableScrollPane3 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JdbTable jdbTable2 = new JdbTable();
  JdbTable jdbTable3 = new JdbTable();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
  JdbNavToolBar jdbNavToolBar2 = new JdbNavToolBar();
  JdbStatusLabel jdbStatusLabel2 = new JdbStatusLabel();
  JdbNavToolBar jdbNavToolBar3 = new JdbNavToolBar();
  JdbStatusLabel jdbStatusLabel3 = new JdbStatusLabel();

  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    jPanel1.setDebugGraphicsOptions(0);
    jPanel1.setMinimumSize(new Dimension(1, 1));
    jPanel1.setToolTipText("");
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jdbNavToolBar1.setBounds(new Rectangle(20, 11, 286, 30));
    jdbStatusLabel1.setText("jdbStatusLabel1");
    jdbStatusLabel1.setDataSet(queryDataSet1);
    jdbStatusLabel1.setBounds(new Rectangle(28, 196, 216, 21));
    jdbNavToolBar2.setDataSet(queryDataSet2);
    jdbNavToolBar2.setBounds(new Rectangle(29, 9, 280, 25));
    jdbStatusLabel2.setText("jdbStatusLabel2");
    jdbStatusLabel2.setDataSet(queryDataSet2);
    jdbStatusLabel2.setBounds(new Rectangle(34, 193, 254, 21));
    jdbNavToolBar3.setDataSet(queryDataSet3);
    jdbNavToolBar3.setBounds(new Rectangle(16, 6, 280, 29));
    jdbStatusLabel3.setText("jdbStatusLabel3");
    jdbStatusLabel3.setDataSet(queryDataSet3);
    jdbStatusLabel3.setBounds(new Rectangle(20, 197, 270, 21));
    jTabbedPane1.add(jPanel1,  "student");
    jPanel1.add(tableScrollPane1, null);
    jPanel1.add(jdbNavToolBar1, null);
    jPanel1.add(jdbStatusLabel1, null);
    tableScrollPane1.getViewport().add(jdbTable1, null);
    jTabbedPane1.add(jPanel2,  "grade");
    jPanel2.add(tableScrollPane2, null);
    jPanel2.add(jdbStatusLabel2, null);
    jPanel2.add(jdbNavToolBar2, null);
    tableScrollPane2.getViewport().add(jdbTable2, null);
    jTabbedPane1.add(jPanel3,  "teacher");
    jPanel3.add(tableScrollPane3, null);
    jPanel3.add(jdbStatusLabel3, null);
    jPanel3.add(jdbNavToolBar3, null);
    tableScrollPane3.getViewport().add(jdbTable3, null);
    contentPane = (JPanel) this.getContentPane();
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:student", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    contentPane.setLayout(null);
    this.setSize(new Dimension(384, 318));
    this.setTitle("连接Access数据库");
    jTabbedPane1.setBounds(new Rectangle(27, 19, 326, 250));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student.\"学号\",student.\"姓名\",student.\"性别\",student.\"生日\",student.\"籍贯\" " +
      "FROM \"E:\\Java实例\\student\".student", null, true, Load.ALL));
    jPanel1.setLayout(null);
    jPanel2.setLayout(null);
    jPanel3.setLayout(null);
    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT grade.\"学号\",grade.\"课程\",grade.\"成绩\" FROM \"E:\\Java实例\\student\".grade", null, true, Load.ALL));
    queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT teacher.\"教师号\",teacher.\"姓名\",teacher.\"课程\" FROM \"E:\\Java实例\\student\".teacher", null, true, Load.ALL));
    tableScrollPane1.setBounds(new Rectangle(26, 44, 277, 142));
    tableScrollPane2.setBounds(new Rectangle(32, 44, 277, 142));
    tableScrollPane3.setBounds(new Rectangle(22, 44, 277, 142));
    jdbTable1.setDataSet(queryDataSet1);
    jdbTable2.setDataSet(queryDataSet2);
    jdbTable3.setDataSet(queryDataSet3);
    contentPane.add(jTabbedPane1, null);
  }
  //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);
    }
  }
}