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);