package family;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 Estate_Dialog extends JDialog {  JPanel panel1 = new JPanel();  TableScrollPane tableScrollPane1 = new TableScrollPane();  JdbTable jdbTable1 = new JdbTable();  JLabel jLabel1 = new JLabel();  JdbTextField jdbTextField1 = new JdbTextField();  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();  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();  JLabel jLabel6 = new JLabel();  JdbTextField jdbTextField6 = new JdbTextField();  JButton jButton1 = new JButton();  JButton jButton2 = new JButton();  JButton jButton3 = new JButton();  JButton jButton4 = new JButton();  QueryDataSet queryDataSet2 = new QueryDataSet();  GridBagLayout gridBagLayout1 = new GridBagLayout();  public Estate_Dialog(Frame frame, String title, boolean modal) {    super(frame, title, modal);    try {      jbInit();      pack();    }    catch(Exception ex) {      ex.printStackTrace();    }  }  public Estate_Dialog() {    this(null, "", false);  }  private void jbInit() throws Exception {    panel1.setLayout(gridBagLayout1);    this.setTitle("資產管理");    jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel1.setText("資產合計：");    jdbTextField1.setEditable(false);    jdbTextField1.setText("");    jdbTextField1.setColumnName("total");    jdbTextField1.setDataSet(queryDataSet2);    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:family", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from estate;", null, true, Load.ALL));    column1.setCaption("編號");    column1.setColumnName("Id");    column1.setDataType(com.borland.dx.dataset.Variant.INT);    column1.setEditable(false);    column1.setRowId(true);    column1.setTableName("estate");    column1.setServerColumnName("Id");    column1.setSqlType(4);    column2.setCaption("資產名稱");    column2.setColumnName("Name");    column2.setDataType(com.borland.dx.dataset.Variant.STRING);    column2.setPrecision(50);    column2.setTableName("estate");    column2.setServerColumnName("Name");    column2.setSqlType(12);    column3.setCaption("購買日期");    column3.setColumnName("BuyDate");    column3.setDataType(com.borland.dx.dataset.Variant.DATE);    column3.setTableName("estate");    column3.setServerColumnName("BuyDate");    column3.setSqlType(93);    column4.setCaption("購買價格");    column4.setColumnName("BuyPrice");    column4.setDataType(com.borland.dx.dataset.Variant.DOUBLE);    column4.setTableName("estate");    column4.setServerColumnName("BuyPrice");    column4.setSqlType(8);    column5.setCaption("數量");    column5.setColumnName("Qty");    column5.setDataType(com.borland.dx.dataset.Variant.DOUBLE);    column5.setTableName("estate");    column5.setServerColumnName("Qty");    column5.setSqlType(8);    column6.setCaption("備注");    column6.setColumnName("Remarks");    column6.setDataType(com.borland.dx.dataset.Variant.STRING);    column6.setSearchable(false);    column6.setTableName("estate");    column6.setServerColumnName("Remarks");    queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});    jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);    jdbTable1.setDataSet(queryDataSet1);    jLabel2.setText("資產名稱：");    jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField2.setEditable(true);    jdbTextField2.setText("");    jdbTextField2.setColumnName("Name");    jdbTextField2.setDataSet(queryDataSet1);    jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12));    jLabel3.setText("購買日期：");    jdbTextField3.setText("");    jdbTextField3.setColumnName("BuyDate");    jdbTextField3.setDataSet(queryDataSet1);    jdbTextField3.setEditable(true);    jLabel4.setText("購買價格：");    jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField4.setEditable(true);    jdbTextField4.setText("");    jdbTextField4.setColumnName("BuyPrice");    jdbTextField4.setDataSet(queryDataSet1);    jLabel5.setText("購買數量：");    jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField5.setEditable(true);    jdbTextField5.setText("");    jdbTextField5.setColumnName("Qty");    jdbTextField5.setDataSet(queryDataSet1);    jLabel6.setText("備注：");    jLabel6.setFont(new java.awt.Font("DialogInput", 0, 12));    jdbTextField6.setEditable(true);    jdbTextField6.setText("");    jdbTextField6.setColumnName("Remarks");    jdbTextField6.setDataSet(queryDataSet1);    jButton1.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton1.setText("新增");    jButton1.addActionListener(new Estate_Dialog_jButton1_actionAdapter(this));    jButton2.setText("保存");    jButton2.addActionListener(new Estate_Dialog_jButton2_actionAdapter(this));    jButton2.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton3.setText("刪除");    jButton3.addActionListener(new Estate_Dialog_jButton3_actionAdapter(this));    jButton3.setFont(new java.awt.Font("DialogInput", 0, 12));    jButton4.setText("返回");    jButton4.addActionListener(new Estate_Dialog_jButton4_actionAdapter(this));    jButton4.setFont(new java.awt.Font("DialogInput", 0, 12));    queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select sum(buyprice*qty) as total from estate;", null, true, Load.ALL));    getContentPane().add(panel1);    panel1.add(tableScrollPane1,  new GridBagConstraints(0, 1, 7, 1, 1.0, 1.0            ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(18, 4, 0, 7), 186, -190));    panel1.add(jLabel1,  new GridBagConstraints(0, 0, 2, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(23, 37, 0, 126), 0, 0));    panel1.add(jdbTextField1,  new GridBagConstraints(1, 0, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(23, 36, 0, 0), 87, 0));    panel1.add(jLabel2,  new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(22, 32, 0, 0), 0, 0));    panel1.add(jdbTextField2,  new GridBagConstraints(1, 2, 2, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(20, 19, 0, 0), 155, 0));    panel1.add(jLabel3,  new GridBagConstraints(3, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(22, 21, 0, 0), 0, 0));    panel1.add(jdbTextField3,  new GridBagConstraints(4, 2, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(20, 15, 0, 0), 75, 0));    panel1.add(jLabel4,  new GridBagConstraints(5, 2, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(21, 30, 0, 0), 0, 0));    panel1.add(jdbTextField4,  new GridBagConstraints(6, 2, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(19, 15, 0, 23), 75, 0));    panel1.add(jLabel5,  new GridBagConstraints(0, 3, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(22, 32, 0, 0), 0, 0));    panel1.add(jdbTextField5,  new GridBagConstraints(1, 3, 1, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(20, 18, 0, 30), 75, 0));    panel1.add(jdbTextField6,  new GridBagConstraints(3, 3, 4, 1, 1.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(19, 15, 0, 23), 344, 0));    panel1.add(jLabel6,  new GridBagConstraints(2, 3, 1, 1, 0.0, 0.0            ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(22, 12, 0, 0), 0, 0));    panel1.add(jButton1,  new GridBagConstraints(0, 4, 2, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(27, 69, 23, 71), 25, 0));    panel1.add(jButton4,  new GridBagConstraints(5, 4, 2, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(28, 59, 23, 69), 25, 0));    panel1.add(jButton3,  new GridBagConstraints(4, 4, 1, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(28, 18, 23, 0), 25, 0));    panel1.add(jButton2,  new GridBagConstraints(2, 4, 2, 1, 0.0, 0.0            ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(28, 0, 23, 54), 25, 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);     }     queryDataSet2.refresh();  }  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);     }     queryDataSet2.refresh();  }  void jButton4_actionPerformed(ActionEvent e) {    this.dispose();  }}class Estate_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener {  Estate_Dialog adaptee;  Estate_Dialog_jButton1_actionAdapter(Estate_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class Estate_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener {  Estate_Dialog adaptee;  Estate_Dialog_jButton2_actionAdapter(Estate_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class Estate_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener {  Estate_Dialog adaptee;  Estate_Dialog_jButton3_actionAdapter(Estate_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}class Estate_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener {  Estate_Dialog adaptee;  Estate_Dialog_jButton4_actionAdapter(Estate_Dialog adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton4_actionPerformed(e);  }}