newbook_dialog.java

library-manage-system(图书管理系统),很好的学习源码。

package library;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class NewBook_Dialog extends JDialog {
  private JPanel panel1 = new JPanel();
  private TableScrollPane tableScrollPane1 = new TableScrollPane();
  private JdbTable jdbTable1 = new JdbTable();
  private Database database1 = new Database();
  private QueryDataSet queryDataSet1 = new QueryDataSet();
  private Column column1 = new Column();
  private JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  private JButton jButton1 = new JButton();
  private JTextField jTextField1 = new JTextField();
  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel2 = new JLabel();
  private GridBagLayout gridBagLayout1 = new GridBagLayout();
  TitledBorder titledBorder1;

  public NewBook_Dialog(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public NewBook_Dialog() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    panel1.setLayout(gridBagLayout1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:lib", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
    queryDataSet1.setSort(new com.borland.dx.dataset.SortDescriptor("", new String[] {"编号"}, new boolean[] {false, }, null, 0));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select code as 编号,name as 书名 ,type as 类别,press as 出版社,writer as 作者 " +
      "from bookInfo ", null, true, Load.ALL));
    jdbTable1.setColumnSelectionAllowed(true);
    jdbTable1.setDataSet(queryDataSet1);
    column1.setColumnName("编号");
    column1.setDataType(com.borland.dx.dataset.Variant.STRING);
    column1.setPrecision(10);
    column1.setRowId(true);
    column1.setServerColumnName("编号");
    column1.setSqlType(12);
    jdbNavToolBar1.setBorder(BorderFactory.createEtchedBorder());
    jdbNavToolBar1.setBorderPainted(true);
    jdbNavToolBar1.setButtonStateSave(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setButtonStateRefresh(JdbNavToolBar.HIDDEN);
    jdbNavToolBar1.setDataSet(queryDataSet1);
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setText("返回");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("图书编号：");
    jTextField1.addKeyListener(new java.awt.event.KeyAdapter() {
      public void keyReleased(KeyEvent e) {
        jTextField1_keyReleased(e);
      }
    });
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel2.setText("例如：1001");
    this.setTitle("书库管理");
    getContentPane().add(panel1);
    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 1, 4, 1, 1.0, 1.0
            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(16, 17, 0, 19), 196, -217));
    panel1.add(jLabel1,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(24, 34, 0, 0), 0, 0));
    panel1.add(jTextField1,  new GridBagConstraints(1, 0, 1, 1, 1.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(24, 34, 0, 0), 108, 0));
    panel1.add(jLabel2,  new GridBagConstraints(2, 0, 1, 1, 0.0, 0.0
            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(24, 42, 0, 208), 0, 0));
    panel1.add(jdbNavToolBar1,  new GridBagConstraints(0, 2, 3, 1, 1.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.HORIZONTAL, new Insets(23, 53, 27, 0), 140, -2));
    panel1.add(jButton1,  new GridBagConstraints(3, 2, 1, 1, 0.0, 0.0
            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(28, 37, 34, 54), 0, 0));
    tableScrollPane1.getViewport().add(jdbTable1, null);
    queryDataSet1.setMasterLink(new com.borland.dx.dataset.MasterLinkDescriptor(null, (String[]) null, (String[]) null, true, false, false));
    queryDataSet1.setColumns(new Column[] {column1});
  }



  void jButton1_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  void jTextField1_keyReleased(KeyEvent e) {
    if(queryDataSet1.isOpen()) queryDataSet1.close();
    if(jTextField1.getText().length()==0)
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select code as 编号,name as 书名 ,type as 类别,press as 出版社,writer as 作者 " +
                 "from bookInfo ", null, true, Load.ALL));
    else
      queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select code as 编号,name as 书名 ,type as 类别,press as 出版社,writer as 作者 " +
                     "from bookInfo where code = \'"+jTextField1.getText()+"\'", null, true, Load.ALL));
    queryDataSet1.open();
  }
}