package person;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 Change_Dialog extends JDialog {  JPanel panel1 = new JPanel();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JPanel jPanel1 = new JPanel();  XYLayout xYLayout2 = new XYLayout();  JLabel jLabel1 = new JLabel();  JdbTextField jdbTextField1 = new JdbTextField();  JLabel jLabel2 = new JLabel();  JdbTextField jdbTextField2 = new JdbTextField();  JLabel jLabel3 = new JLabel();  JdbTextField jdbTextField3 = new JdbTextField();  JLabel jLabel4 = new JLabel();  JdbTextField jdbTextField4 = new JdbTextField();  JLabel jLabel5 = new JLabel();  JdbTextField jdbTextField5 = new JdbTextField();  JPanel jPanel2 = new JPanel();  XYLayout xYLayout3 = new XYLayout();  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();  Column column5 = new Column();  Column column6 = new Column();  Column column7 = new Column();  GridBagLayout gridBagLayout1 = new GridBagLayout();  public Change_Dialog(Frame frame, String title, boolean modal) {    super(frame, title, modal);    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  public Change_Dialog() {    this(null, "", false);  }  private void jbInit() throws Exception {    panel1.setLayout(gridBagLayout1);    jPanel1.setBorder(BorderFactory.createEtchedBorder());    jPanel1.setLayout(xYLayout2);    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel1.setText("員工號：");    jdbTextField1.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField1.setText("");    jdbTextField1.setColumnName("sid");    jdbTextField1.setDataSet(queryDataSet1);    jLabel2.setText("原部門：");    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField2.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField2.setText("");    jdbTextField2.setColumnName("sDep");    jdbTextField2.setDataSet(queryDataSet1);    jLabel3.setText("新部門：");    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField3.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField3.setText("");    jdbTextField3.setColumnName("dDep");    jdbTextField3.setDataSet(queryDataSet1);    jLabel4.setText("變更時間：");    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField4.setText("");    jdbTextField4.setColumnName("cDate");    jdbTextField4.setDataSet(queryDataSet1);    jLabel5.setText("變更原因：");    jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField5.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField5.setText("");    jdbTextField5.setColumnName("reason");    jdbTextField5.setDataSet(queryDataSet1);    jPanel2.setLayout(xYLayout3);    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton1.setText("添加");    jButton1.addActionListener(new Change_Dialog_jButton1_actionAdapter(this));    jButton2.setText("保存");    jButton2.addActionListener(new Change_Dialog_jButton2_actionAdapter(this));    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton3.setText("刪除");    jButton3.addActionListener(new Change_Dialog_jButton3_actionAdapter(this));    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton4.setText("退出");    jButton4.addActionListener(new Change_Dialog_jButton4_actionAdapter(this));    jButton4.setFont(new java.awt.Font("DialogInput", 0, 12));    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:person", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from change;", null, true, Load.ALL));    column1.setCaption("編號");    column1.setColumnName("id");    column1.setDataType(com.borland.dx.dataset.Variant.INT);    column1.setRowId(true);    column1.setTableName("change");    column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column1.setServerColumnName("id");    column1.setSqlType(4);    column2.setCaption("員工號");    column2.setColumnName("sid");    column2.setDataType(com.borland.dx.dataset.Variant.STRING);    column2.setPrecision(50);    column2.setTableName("change");    column2.setServerColumnName("sid");    column2.setSqlType(12);    column3.setCaption("原部門");    column3.setColumnName("sDep");    column3.setDataType(com.borland.dx.dataset.Variant.STRING);    column3.setPrecision(50);    column3.setTableName("change");    column3.setServerColumnName("sDep");    column3.setSqlType(12);    column4.setCaption("新部門");    column4.setColumnName("dDep");    column4.setDataType(com.borland.dx.dataset.Variant.STRING);    column4.setPrecision(50);    column4.setTableName("change");    column4.setServerColumnName("dDep");    column4.setSqlType(12);    column5.setCaption("變更日期");    column5.setColumnName("cDate");    column5.setDataType(com.borland.dx.dataset.Variant.STRING);    column5.setPrecision(50);    column5.setTableName("change");    column5.setServerColumnName("cDate");    column5.setSqlType(12);    column6.setCaption("變更原因");    column6.setColumnName("reason");    column6.setDataType(com.borland.dx.dataset.Variant.STRING);    column6.setPrecision(50);    column6.setTableName("change");    column6.setServerColumnName("reason");    column6.setSqlType(12);    column7.setCaption("操作時間");    column7.setColumnName("mDate");    column7.setDataType(com.borland.dx.dataset.Variant.STRING);    column7.setPrecision(50);    column7.setTableName("change");    column7.setVisible(com.borland.jb.util.TriStateProperty.FALSE);    column7.setServerColumnName("mDate");    column7.setSqlType(12);    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7});    jdbTable1.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);    jdbTable1.setDataSet(queryDataSet1);    tableScrollPane1.setFont(new java.awt.Font("DialogInput", 0, 12));    this.setResizable(false);    this.setTitle("人事變更管理");    getContentPane().add(panel1);    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(19, 16, 0, 15), 111, -239));    panel1.add(jPanel1,  new GridBagConstraints(0, 1, 1, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(8, 16, 0, 15), 6, 11));    jPanel1.add(jLabel1,   new XYConstraints(13, 14, -1, -1));    jPanel1.add(jdbTextField1,   new XYConstraints(89, 12, 97, -1));    jPanel1.add(jLabel3, new XYConstraints(395, 12, -1, -1));    jPanel1.add(jdbTextField3, new XYConstraints(471, 10, 97, -1));    jPanel1.add(jLabel2, new XYConstraints(201, 13, -1, -1));    jPanel1.add(jdbTextField2, new XYConstraints(277, 11, 97, -1));    jPanel1.add(jLabel4, new XYConstraints(13, 50, -1, -1));    jPanel1.add(jdbTextField4, new XYConstraints(89, 48, 97, -1));    jPanel1.add(jLabel5, new XYConstraints(201, 47, -1, -1));    jPanel1.add(jdbTextField5,  new XYConstraints(277, 45, 290, -1));    panel1.add(jPanel2,  new GridBagConstraints(0, 2, 1, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(10, 16, 10, 15), 88, 16));    jPanel2.add(jButton2, new XYConstraints(188, 14, 68, -1));    jPanel2.add(jButton4, new XYConstraints(422, 14, 68, -1));    jPanel2.add(jButton1, new XYConstraints(71, 14, 68, -1));    jPanel2.add(jButton3, new XYConstraints(307, 14, 68, -1));    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,"刪除失敗","提示",JOptionPane.ERROR_MESSAGE);    }  }  void jButton4_actionPerformed(ActionEvent e) {    this.dispose();  }}class Change_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {  Change_Dialog adaptee;  Change_Dialog_jButton1_actionAdapter(Change_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class Change_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {  Change_Dialog adaptee;  Change_Dialog_jButton2_actionAdapter(Change_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class Change_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {  Change_Dialog adaptee;  Change_Dialog_jButton3_actionAdapter(Change_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}class Change_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {  Change_Dialog adaptee;  Change_Dialog_jButton4_actionAdapter(Change_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton4_actionPerformed(e);  }}