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 Password_Dialog extends JDialog {  JPanel panel1 = new JPanel();  JPanel jPanel1 = new JPanel();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JLabel jLabel1 = new JLabel();  JdbTextField jdbTextField1 = new JdbTextField();  JdbTextField jdbTextField2 = new JdbTextField();  JLabel jLabel2 = new JLabel();  JLabel jLabel3 = new JLabel();  JScrollPane jScrollPane1 = new JScrollPane();  JdbTextArea jdbTextArea1 = new JdbTextArea();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();  JButton jButton3 = new JButton();  JButton jButton4 = new JButton();  Database database1 = new Database();  QueryDataSet queryDataSet1 = new QueryDataSet();  Column column1 = new Column();  Column column2 = new Column();  Column column3 = new Column();  Column column4 = new Column();  GridBagLayout gridBagLayout1 = new GridBagLayout();  GridBagLayout gridBagLayout2 = new GridBagLayout();  public Password_Dialog(Frame frame, String title, boolean modal) {    super(frame, title, modal);    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  public Password_Dialog() {    this(null, "", false);  }  private void jbInit() throws Exception {    panel1.setLayout(gridBagLayout2);    this.setResizable(false);    this.setTitle("密碼備忘");    jPanel1.setBorder(BorderFactory.createEtchedBorder());    jPanel1.setLayout(gridBagLayout1);    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel1.setText("密碼名稱：");    jdbTextField1.setText("");    jdbTextField1.setColumnName("Name");    jdbTextField1.setDataSet(queryDataSet1);    jdbTextField2.setText("");    jdbTextField2.setColumnName("Pwd");    jdbTextField2.setDataSet(queryDataSet1);    jLabel2.setText("密   碼：");    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel3.setText("備注：");    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextArea1.setText("");    jdbTextArea1.setColumnName("comments");    jdbTextArea1.setDataSet(queryDataSet1);    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton1.setText("添加");    jButton1.addActionListener(new Password_Dialog_jButton1_actionAdapter(this));    jButton2.setText("保存");    jButton2.addActionListener(new Password_Dialog_jButton2_actionAdapter(this));    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton3.setText("刪除");    jButton3.addActionListener(new Password_Dialog_jButton3_actionAdapter(this));    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton4.setText("退出");    jButton4.addActionListener(new Password_Dialog_jButton4_actionAdapter(this));    jButton4.setFont(new java.awt.Font("DialogInput", 0, 12));    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 pwd", null, true, Load.ALL));    column1.setCaption("編號");    column1.setColumnName("Id");    column1.setDataType(com.borland.dx.dataset.Variant.INT);    column1.setRowId(true);    column1.setTableName("pwd");    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(20);    column2.setTableName("pwd");    column2.setServerColumnName("Name");    column2.setSqlType(12);    column3.setCaption("密碼");    column3.setColumnName("Pwd");    column3.setDataType(com.borland.dx.dataset.Variant.STRING);    column3.setPrecision(20);    column3.setTableName("pwd");    column3.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column3.setServerColumnName("Pwd");    column3.setSqlType(12);    column4.setCaption("備注");    column4.setColumnName("comments");    column4.setDataType(com.borland.dx.dataset.Variant.STRING);    column4.setSearchable(false);    column4.setTableName("pwd");    column4.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column4.setServerColumnName("comments");    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4});    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);    jdbTable1.setDataSet(queryDataSet1);    getContentPane().add(panel1);    jPanel1.add(jLabel1,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(19, 15, 0, 0), 0, 0));    jPanel1.add(jdbTextField1,  new GridBagConstraints(1, 0, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(19, 17, 0, 11), 120, 0));    jPanel1.add(jLabel2,  new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(15, 15, 0, 0), 0, 0));    jPanel1.add(jdbTextField2,  new GridBagConstraints(1, 1, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(13, 17, 0, 11), 120, 0));    jPanel1.add(jLabel3,  new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(12, 15, 0, 23), 0, 0));    jPanel1.add(jScrollPane1,  new GridBagConstraints(0, 3, 2, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(0, 15, 15, 11), 0, 80));    jScrollPane1.getViewport().add(jdbTextArea1, null);    panel1.add(jPanel1,  new GridBagConstraints(1, 0, 3, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(22, 11, 0, 21), 0, 1));    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(22, 23, 0, 0), -336, -193));    panel1.add(jButton1,  new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(17, 61, 28, 30), 5, 0));    panel1.add(jButton2,  new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(17, 0, 28, 0), 3, 0));    panel1.add(jButton3,  new GridBagConstraints(2, 1, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(17, 33, 28, 0), 5, 0));    panel1.add(jButton4,  new GridBagConstraints(3, 1, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(17, 33, 28, 52), 5, 0));    tableScrollPane1.getViewport().add(jdbTable1, null);  }  void jButton1_actionPerformed(ActionEvent e) {    queryDataSet1.insertRow(false);  }  void jButton2_actionPerformed(ActionEvent e) {    try{       queryDataSet1.post();       queryDataSet1.saveChanges();       queryDataSet1.refresh();     }catch(Exception ex){       queryDataSet1.refresh();       JOptionPane.showMessageDialog(this,"性別只能是\'男\'\\\'女\'","提示",JOptionPane.ERROR_MESSAGE);     }  }  void jButton3_actionPerformed(ActionEvent e) {    try{      queryDataSet1.deleteRow();      queryDataSet1.post();      queryDataSet1.saveChanges();      queryDataSet1.refresh();    }catch(Exception ex){      queryDataSet1.refresh();      JOptionPane.showMessageDialog(this,ex.toString(),"提示",JOptionPane.ERROR_MESSAGE);    }  }  void jButton4_actionPerformed(ActionEvent e) {    this.dispose();  }}class Password_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {  Password_Dialog adaptee;  Password_Dialog_jButton1_actionAdapter(Password_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class Password_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {  Password_Dialog adaptee;  Password_Dialog_jButton2_actionAdapter(Password_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class Password_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {  Password_Dialog adaptee;  Password_Dialog_jButton3_actionAdapter(Password_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}class Password_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {  Password_Dialog adaptee;  Password_Dialog_jButton4_actionAdapter(Password_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton4_actionPerformed(e);  }}