addrbook_dialog.java

java课程设计的的许多源代码以及数据库联接

package psa;

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

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

public class AddrBook_Dialog extends JDialog {
  JPanel panel1 = new JPanel();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  XYLayout xYLayout2 = new XYLayout();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton1 = new JButton();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JPanel jPanel2 = new JPanel();
  XYLayout xYLayout3 = new XYLayout();
  JLabel jLabel3 = new JLabel();
  JdbTextField jdbTextField1 = new JdbTextField();
  JdbTextField jdbTextField2 = new JdbTextField();
  JLabel jLabel4 = new JLabel();
  JdbTextField jdbTextField3 = new JdbTextField();
  JLabel jLabel5 = new JLabel();
  JdbTextField jdbTextField4 = new JdbTextField();
  JLabel jLabel6 = new JLabel();
  JdbTextField jdbTextField5 = new JdbTextField();
  JLabel jLabel7 = new JLabel();
  JdbTextField jdbTextField6 = new JdbTextField();
  JLabel jLabel8 = new JLabel();
  JdbTextField jdbTextField7 = new JdbTextField();
  JLabel jLabel9 = new JLabel();
  JdbTextField jdbTextField8 = new JdbTextField();
  JLabel jLabel10 = new JLabel();
  JdbTextField jdbTextField9 = new JdbTextField();
  JLabel jLabel11 = new JLabel();
  JdbTextField jdbTextField10 = new JdbTextField();
  JLabel jLabel12 = new JLabel();
  JLabel jLabel13 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JdbTextArea jdbTextArea1 = new JdbTextArea();
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  Column column8 = new Column();
  Column column9 = new Column();
  Column column10 = new Column();
  Column column11 = new Column();
  Column column12 = new Column();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  GridBagLayout gridBagLayout1 = new GridBagLayout();

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

  public AddrBook_Dialog() {
    this(null, "", false);
  }

  private void jbInit() throws Exception {
    panel1.setLayout(gridBagLayout1);
    this.setResizable(false);
    this.setTitle("地址簿");
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setLayout(xYLayout2);
    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel1.setText("查询条件：");
    jComboBox1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel2.setText("查询内容：");
    jTextField1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jTextField1.setText("");
    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));
    jButton1.setText("查询");
    jButton1.addActionListener(new AddrBook_Dialog_jButton1_actionAdapter(this));
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setLayout(xYLayout3);
    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel3.setText("姓   名：");
    jdbTextField1.setText("");
    jdbTextField1.setColumnName("name");
    jdbTextField1.setDataSet(queryDataSet1);
    jdbTextField2.setText("");
    jdbTextField2.setColumnName("sex");
    jdbTextField2.setDataSet(queryDataSet1);
    jLabel4.setText("性   别：");
    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField3.setText("");
    jdbTextField3.setColumnName("type");
    jdbTextField3.setDataSet(queryDataSet1);
    jLabel5.setText("关   系：");
    jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField4.setText("");
    jdbTextField4.setColumnName("fphone");
    jdbTextField4.setDataSet(queryDataSet1);
    jLabel6.setText("住宅电话：");
    jLabel6.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField5.setText("");
    jdbTextField5.setColumnName("ophone");
    jdbTextField5.setDataSet(queryDataSet1);
    jLabel7.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel7.setText("办公电话：");
    jdbTextField6.setText("");
    jdbTextField6.setColumnName("mphone");
    jdbTextField6.setDataSet(queryDataSet1);
    jLabel8.setText("移动电话：");
    jLabel8.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField7.setText("");
    jdbTextField7.setColumnName("email");
    jdbTextField7.setDataSet(queryDataSet1);
    jLabel9.setText("电子邮件：");
    jLabel9.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField8.setText("");
    jdbTextField8.setColumnName("company");
    jdbTextField8.setDataSet(queryDataSet1);
    jLabel10.setText("单   位：");
    jLabel10.setFont(new java.awt.Font("DialogInput", 0, 12));
    jdbTextField9.setText("");
    jdbTextField9.setColumnName("oicq");
    jdbTextField9.setDataSet(queryDataSet1);
    jLabel11.setText("OICQ：");
    jLabel11.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel11.setRequestFocusEnabled(true);
    jdbTextField10.setText("");
    jdbTextField10.setColumnName("address");
    jdbTextField10.setDataSet(queryDataSet1);
    jLabel12.setText("地   址：");
    jLabel12.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel13.setFont(new java.awt.Font("DialogInput", 0, 12));
    jLabel13.setText("备注：");
    jdbTextArea1.setText("");
    jdbTextArea1.setColumnName("comments");
    jdbTextArea1.setDataSet(queryDataSet1);
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:psa", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from addrbook;", null, true, Load.ALL));
    column1.setCaption("编号");
    column1.setColumnName("ID");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setRowId(true);
    column1.setTableName("addrbook");
    column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column1.setServerColumnName("ID");
    column1.setSqlType(4);
    column2.setCaption("姓名");
    column2.setColumnName("name");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(10);
    column2.setTableName("addrbook");
    column2.setServerColumnName("name");
    column2.setSqlType(12);
    column3.setCaption("性别");
    column3.setColumnName("sex");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(2);
    column3.setTableName("addrbook");
    column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column3.setServerColumnName("sex");
    column3.setSqlType(12);
    column4.setCaption("关系");
    column4.setColumnName("type");
    column4.setDataType(com.borland.dx.dataset.Variant.STRING);
    column4.setPrecision(12);
    column4.setTableName("addrbook");
    column4.setServerColumnName("type");
    column4.setSqlType(12);
    column5.setCaption("住宅电话");
    column5.setColumnName("fphone");
    column5.setDataType(com.borland.dx.dataset.Variant.STRING);
    column5.setPrecision(15);
    column5.setTableName("addrbook");
    column5.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column5.setServerColumnName("fphone");
    column5.setSqlType(12);
    column6.setCaption("办公电话");
    column6.setColumnName("ophone");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(15);
    column6.setTableName("addrbook");
    column6.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column6.setServerColumnName("ophone");
    column6.setSqlType(12);
    column7.setCaption("移动电话");
    column7.setColumnName("mphone");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(15);
    column7.setTableName("addrbook");
    column7.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
    column7.setServerColumnName("mphone");
    column7.setSqlType(12);