bookframe.java

Java实例入门

package pubinfo;

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

/**
 * Title:        浏览包含主从关系的数据
 * Description:  在本程序中，我们通过定义出版商和书籍信息之间的主从关系，实现了一个数据浏览窗体。
 * Copyright:    Copyright (c) 2001
 * Company:
 * @author
 * @version 1.0
 */

public class BookFrame extends JFrame {
  ResourceBundle sqlRes = ResourceBundle.getBundle("pubinfo.SqlRes");
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  TitledBorder titledBorder1;
  JSplitPane jSplitPane = new JSplitPane();
  JdbStatusLabel StatusBar = new JdbStatusLabel();
  TableScrollPane tableScrollPaneButtom = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JScrollPane jScrollPaneTop = new JScrollPane();
  JPanel jPanelPub = new JPanel();
  JdbTable jdbTableBook = new JdbTable();
  Database db = new Database();
  QueryDataSet queryDataSetPub = new QueryDataSet();
  QueryDataSet queryDataSetBook = new QueryDataSet();
  XYLayout xYLayout1 = new XYLayout();
  JdbLabel jdbLabel1 = new JdbLabel();
  JdbLabel jdbLabel2 = new JdbLabel();
  JdbTextField jdbTextField3 = new JdbTextField();
  JdbLabel jdbLabel3 = new JdbLabel();
  JdbTextField jdbTextField4 = new JdbTextField();
  JdbLabel jdbLabel4 = new JdbLabel();
  JdbLabel jdbLabel5 = new JdbLabel();
  JdbLabel jdbLabel6 = new JdbLabel();
  JdbTextField jdbTextField6 = new JdbTextField();
  JdbTextField jdbTextField7 = new JdbTextField();
  JdbLabel jdbLabel7 = new JdbLabel();
  JdbTextField jdbTextField8 = new JdbTextField();
  JdbLabel jdbLabel8 = new JdbLabel();
  JdbTextField jdbTextField9 = new JdbTextField();
  JdbLabel jdbLabel9 = new JdbLabel();
  JdbLabel jdbLabel10 = new JdbLabel();
  JdbTextField jdbTextField10 = new JdbTextField();
  JdbTextField jdbTextField11 = new JdbTextField();
  JdbTextField jdbTextField12 = new JdbTextField();
  JdbTextArea jdbTextArea1 = new JdbTextArea();

  /**Construct the frame*/
  public BookFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  /**Component initialization*/
  private void jbInit() throws Exception  {
    //setIconImage(Toolkit.getDefaultToolkit().createImage(BookFrame.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    titledBorder1 = new TitledBorder("");
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(477, 431));
    this.setTitle("出版商和书籍信息");
    jSplitPane.setOrientation(JSplitPane.VERTICAL_SPLIT);
    jSplitPane.setBottomComponent(tableScrollPaneButtom);
    jSplitPane.setContinuousLayout(true);
    jSplitPane.setLeftComponent(null);
    jSplitPane.setTopComponent(jScrollPaneTop);
    db.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:JavaTest", "sa", "java", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    StatusBar.setText("   ");
    queryDataSetBook.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db, sqlRes.getString("publishers"), null, true, Load.ALL));
    queryDataSetPub.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db, sqlRes.getString("publishers1"), null, true, Load.ALL));
    jdbTableBook.setDataSet(queryDataSetBook);
    jPanelPub.setLayout(xYLayout1);
    jdbLabel1.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel1.setText("PubID");
    jdbLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel2.setText("Name");
    jdbTextField3.setText("jdbTextField1");
    jdbTextField3.setColumnName("Company Name");
    jdbTextField3.setDataSet(queryDataSetPub);
    jdbLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel3.setText("Company_Name");
    jdbTextField4.setText("jdbTextField1");
    jdbTextField4.setColumnName("Address");
    jdbTextField4.setDataSet(queryDataSetPub);
    jdbLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel4.setText("Address");
    jdbLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel5.setText("City");
    jdbLabel6.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel6.setText("State");
    jdbTextField6.setText("jdbTextField6");
    jdbTextField6.setColumnName("State");
    jdbTextField6.setDataSet(queryDataSetPub);
    jdbTextField7.setText("jdbTextField6");
    jdbTextField7.setColumnName("Zip");
    jdbTextField7.setDataSet(queryDataSetPub);
    jdbLabel7.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel7.setText("Zip");
    jdbTextField8.setText("jdbTextField6");
    jdbTextField8.setColumnName("Telephone");
    jdbTextField8.setDataSet(queryDataSetPub);
    jdbLabel8.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel8.setText("Telephone");
    jdbTextField9.setText("jdbTextField6");
    jdbTextField9.setColumnName("Fax");
    jdbTextField9.setDataSet(queryDataSetPub);
    jdbLabel9.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel9.setText("Fax");
    jdbLabel10.setHorizontalAlignment(SwingConstants.RIGHT);
    jdbLabel10.setText("Comments");
    jdbTextField10.setText("jdbTextField6");
    jdbTextField10.setColumnName("PubID");
    jdbTextField10.setDataSet(queryDataSetPub);
    jdbTextField11.setText("jdbTextField6");
    jdbTextField11.setColumnName("Name");
    jdbTextField11.setDataSet(queryDataSetPub);
    jdbTextField12.setText("jdbTextField6");
    jdbTextField12.setColumnName("City");
    jdbTextField12.setDataSet(queryDataSetPub);
    jdbTextArea1.setBorder(BorderFactory.createLoweredBevelBorder());
    jdbTextArea1.setText("jdbTextArea1");
    jdbTextArea1.setColumnName("Comments");
    jdbTextArea1.setDataSet(queryDataSetPub);
    jdbNavToolBar1.setDataSet(queryDataSetPub);
    contentPane.add(jdbNavToolBar1, BorderLayout.NORTH);
    contentPane.add(jSplitPane, BorderLayout.CENTER);
    jSplitPane.add(tableScrollPaneButtom, JSplitPane.RIGHT);
    tableScrollPaneButtom.getViewport().add(jdbTableBook, null);
    jSplitPane.add(jScrollPaneTop, JSplitPane.LEFT);
    jScrollPaneTop.getViewport().add(jPanelPub, null);
    jPanelPub.add(jdbLabel2,  new XYConstraints(239, 21, -1, 18));
    jPanelPub.add(jdbTextField3,        new XYConstraints(112, 61, 298, -1));
    jPanelPub.add(jdbTextField4,      new XYConstraints(112, 102, 110, 23));
    jPanelPub.add(jdbLabel5,     new XYConstraints(253, 105, -1, 18));
    jPanelPub.add(jdbTextField9,  new XYConstraints(284, 184, 88, 23));
    jPanelPub.add(jdbLabel9,   new XYConstraints(204, 184, 69, 18));
    jPanelPub.add(jdbTextField8,  new XYConstraints(112, 186, 88, 23));
    jPanelPub.add(jdbTextField10,    new XYConstraints(112, 19, 88, 23));
    jPanelPub.add(jdbTextField11,   new XYConstraints(284, 20, 88, 23));
    jPanelPub.add(jdbTextField12,     new XYConstraints(284, 102, 88, 23));
    jPanelPub.add(jdbTextField6,     new XYConstraints(112, 144, 88, 23));
    jPanelPub.add(jdbTextField7,   new XYConstraints(284, 143, 88, 23));
    jPanelPub.add(jdbLabel7,      new XYConstraints(235, 144, 38, 18));
    jPanelPub.add(jdbLabel4,  new XYConstraints(56, 100, -1, -1));
    jPanelPub.add(jdbLabel1, new XYConstraints(68, 20, -1, -1));
    jPanelPub.add(jdbLabel3,  new XYConstraints(8, 60, -1, -1));
    jPanelPub.add(jdbLabel6,  new XYConstraints(69, 139, 33, -1));
    jPanelPub.add(jdbLabel8,  new XYConstraints(33, 179, 69, -1));
    jPanelPub.add(jdbLabel10, new XYConstraints(27, 219, 75, -1));
    jPanelPub.add(jdbTextArea1,  new XYConstraints(112, 221, 272, 98));
    contentPane.add(StatusBar, BorderLayout.SOUTH);
    jSplitPane.setDividerLocation(200);
    queryDataSetBook.setMasterLink(new com.borland.dx.dataset.MasterLinkDescriptor(queryDataSetPub, new String[] {"PubID"}, new String[] {"PubID"}, false, true, true));
  }
  /**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);
    }
  }
}