package app;import java.awt.*;import java.awt.event.*;import javax.swing.*;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import com.borland.jbcl.layout.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author unascribed * @version 1.0 */public class Customer_Frame extends JFrame {  private JPanel contentPane;  private Database DB_Customer = new Database();  private JButton jButton1 = new JButton();  private QueryDataSet queryDataSet_Customer = new QueryDataSet();  private TableScrollPane tableScrollPane1 = new TableScrollPane();  private JdbTable jdbTable1 = new JdbTable();  private JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();  private JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();  private JLabel jLabel1 = new JLabel();  private JdbNavField jdbNavField1 = new JdbNavField();  private JLabel jLabel2 = new JLabel();  private JdbTextField jdbTextField1 = new JdbTextField();  private JLabel jLabel3 = new JLabel();  private JdbTextField jdbTextField2 = new JdbTextField();  private JLabel jLabel4 = new JLabel();  private JdbTextField jdbTextField3 = new JdbTextField();  private JLabel jLabel5 = new JLabel();  private JdbTextField jdbTextField4 = new JdbTextField();  private JLabel jLabel6 = new JLabel();  private JdbTextField jdbTextField5 = new JdbTextField();  private JLabel jLabel7 = new JLabel();  private JdbTextField jdbTextField6 = new JdbTextField();  private JLabel jLabel8 = new JLabel();  private JdbTextField jdbTextField7 = new JdbTextField();  private JLabel jLabel9 = new JLabel();  private JdbTextField jdbTextField8 = new JdbTextField();  private JLabel jLabel10 = new JLabel();  private JLabel jLabel11 = new JLabel();  private JLabel jLabel12 = new JLabel();  private JLabel jLabel13 = new JLabel();  private JLabel jLabel14 = new JLabel();  private JdbTextField jdbTextField9 = new JdbTextField();  private JdbTextField jdbTextField10 = new JdbTextField();  private JdbTextField jdbTextField11 = new JdbTextField();  private JdbTextField jdbTextField12 = new JdbTextField();  private JdbTextField jdbTextField13 = new JdbTextField();  private JButton jButton2 = new JButton();  private JLabel jLabel15 = new JLabel();  private JdbTextField jdbTextField14 = new JdbTextField();  //Construct the frame  public Customer_Frame() {    enableEvents(AWTEvent.WINDOW_EVENT_MASK);    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  //Component initialization  private void jbInit() throws Exception  {    //setIconImage(Toolkit.getDefaultToolkit().createImage(Customer_Frame.class.getResource("[Your Icon]")));    contentPane = (JPanel) this.getContentPane();    DB_Customer.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:grrc", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));    contentPane.setLayout(null);    this.setSize(new Dimension(1022, 725));    this.setTitle("Frame Title");    jButton1.setBounds(new Rectangle(901, 374, 100, 29));    jButton1.setText("保 存 更 改");    jButton1.addActionListener(new java.awt.event.ActionListener() {      public void actionPerformed(ActionEvent e) {        jButton1_actionPerformed(e);      }    });    queryDataSet_Customer.setTableName("");    queryDataSet_Customer.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(DB_Customer, "SELECT * FROM customer", null, true, Load.ALL));    tableScrollPane1.setBounds(new Rectangle(7, 51, 1005, 225));    jdbTable1.setDataSet(queryDataSet_Customer);    jdbNavToolBar1.setDataSet(queryDataSet_Customer);    jdbNavToolBar1.setBounds(new Rectangle(11, 6, 1001, 41));    jdbStatusLabel1.setDataSet(queryDataSet_Customer);    jdbStatusLabel1.setBounds(new Rectangle(2, 698, 320, 20));    jLabel1.setText("查詢姓名：");    jLabel1.setBounds(new Rectangle(12, 295, 60, 25));    jdbNavField1.setText("jdbNavField1");    jdbNavField1.setColumnName("C_NAME");    jdbNavField1.setDataSet(queryDataSet_Customer);    jdbNavField1.setBounds(new Rectangle(93, 293, 113, 29));    jLabel2.setBounds(new Rectangle(14, 340, 68, 25));    jLabel2.setAlignmentY((float) 10.0);    jLabel2.setText("類別：");    jdbTextField1.setColumnName("C_LB");    jdbTextField1.setDataSet(queryDataSet_Customer);    jdbTextField1.setBounds(new Rectangle(95, 337, 111, 31));    jLabel3.setAlignmentY((float) 10.0);    jLabel3.setText("生 日：");    jLabel3.setBounds(new Rectangle(11, 388, 66, 25));    jdbTextField2.setBounds(new Rectangle(95, 385, 110, 31));    jdbTextField2.setDataSet(queryDataSet_Customer);    jdbTextField2.setColumnName("C_BIRTHDAY");    jLabel4.setBounds(new Rectangle(14, 431, 54, 25));    jLabel4.setAlignmentY((float) 10.0);    jLabel4.setText("Email ：");    jdbTextField3.setColumnName("C_EMAIL");    jdbTextField3.setDataSet(queryDataSet_Customer);    jdbTextField3.setBounds(new Rectangle(93, 427, 112, 31));    jLabel5.setAlignmentY((float) 10.0);    jLabel5.setText("家庭地址 ：");    jLabel5.setBounds(new Rectangle(13, 478, 65, 25));    jdbTextField4.setBounds(new Rectangle(92, 477, 113, 31));    jdbTextField4.setDataSet(queryDataSet_Customer);    jdbTextField4.setColumnName("C_HOME");    jLabel6.setBounds(new Rectangle(14, 526, 49, 25));    jLabel6.setAlignmentY((float) 10.0);    jLabel6.setText(" 城市：");    jdbTextField5.setColumnName("C_CITY");    jdbTextField5.setDataSet(queryDataSet_Customer);    jdbTextField5.setBounds(new Rectangle(92, 523, 113, 31));    jLabel7.setAlignmentY((float) 10.0);    jLabel7.setText("省份 ：");    jLabel7.setBounds(new Rectangle(19, 578, 49, 25));    jdbTextField6.setBounds(new Rectangle(92, 575, 173, 31));    jdbTextField6.addActionListener(new java.awt.event.ActionListener() {      public void actionPerformed(ActionEvent e) {     //   jdbTextField6_actionPerformed(e);      }    });    jdbTextField6.setDataSet(queryDataSet_Customer);    jdbTextField6.setColumnName("C_PROVIENCE");    jLabel8.setBounds(new Rectangle(15, 630, 65, 25));    jLabel8.setAlignmentY((float) 10.0);    jLabel8.setText("郵政編碼：");    jdbTextField7.setColumnName("C_ZIP");    jdbTextField7.setDataSet(queryDataSet_Customer);    jdbTextField7.setBounds(new Rectangle(92, 623, 120, 31));    jLabel9.setText("國 家：");    jLabel9.setBounds(new Rectangle(244, 291, 87, 25));    jdbTextField8.setBounds(new Rectangle(310, 289, 95, 31));    jdbTextField8.setDataSet(queryDataSet_Customer);    jdbTextField8.setColumnName("C_NATION");    jLabel10.setToolTipText("");    jLabel10.setText("家庭電話：");    jLabel10.setBounds(new Rectangle(232, 339, 87, 25));    jLabel11.setBounds(new Rectangle(235, 389, 87, 25));    jLabel11.setText("公司電話：");    jLabel12.setBounds(new Rectangle(233, 432, 87, 25));    jLabel12.setText("呼機號碼：");    jLabel13.setBounds(new Rectangle(234, 481, 80, 25));    jLabel13.setText("手機號碼：");    jLabel14.setBounds(new Rectangle(466, 288, 87, 25));    jLabel14.setText("個人詳細資料：");    jdbTextField9.setColumnName("C_HTEL");    jdbTextField9.setDataSet(queryDataSet_Customer);    jdbTextField9.setBounds(new Rectangle(311, 339, 95, 31));    jdbTextField10.setColumnName("C_CTEL");    jdbTextField10.setDataSet(queryDataSet_Customer);    jdbTextField10.setBounds(new Rectangle(310, 384, 95, 31));    jdbTextField11.setColumnName("C_CALL");    jdbTextField11.setDataSet(queryDataSet_Customer);    jdbTextField11.setBounds(new Rectangle(310, 428, 95, 31));    jdbTextField12.setColumnName("C_MOBILE");    jdbTextField12.setDataSet(queryDataSet_Customer);    jdbTextField12.setBounds(new Rectangle(310, 477, 95, 31));    jdbTextField13.setColumnName("C_NATION");    jdbTextField13.setDataSet(queryDataSet_Customer);    jdbTextField13.setBounds(new Rectangle(461, 319, 384, 366));    jButton2.addActionListener(new java.awt.event.ActionListener() {      public void actionPerformed(ActionEvent e) {        jButton2_actionPerformed(e);      }    });    jButton2.setText("退  出");    jButton2.setBounds(new Rectangle(901, 432, 100, 29));    jLabel15.setText("備   注：");    jLabel15.setBounds(new Rectangle(235, 525, 80, 25));    jdbTextField14.setBounds(new Rectangle(310, 520, 95, 31));    jdbTextField14.addActionListener(new java.awt.event.ActionListener() {      public void actionPerformed(ActionEvent e) {  //      jdbTextField14_actionPerformed(e);      }    });    jdbTextField14.setDataSet(queryDataSet_Customer);    jdbTextField14.setColumnName("C_BZ");    contentPane.add(jButton1, null);    contentPane.add(jdbNavToolBar1, null);    contentPane.add(tableScrollPane1, null);    contentPane.add(jdbStatusLabel1, null);    contentPane.add(jLabel1, null);    contentPane.add(jLabel2, null);    contentPane.add(jLabel9, null);    contentPane.add(jLabel14, null);    contentPane.add(jdbTextField13, null);    contentPane.add(jdbTextField4, null);    contentPane.add(jdbTextField1, null);    contentPane.add(jdbTextField2, null);    contentPane.add(jdbTextField3, null);    contentPane.add(jdbTextField5, null);    contentPane.add(jdbTextField6, null);    contentPane.add(jdbTextField7, null);    contentPane.add(jLabel3, null);    contentPane.add(jLabel4, null);    contentPane.add(jLabel5, null);    contentPane.add(jLabel6, null);    contentPane.add(jLabel7, null);    contentPane.add(jLabel8, null);    contentPane.add(jLabel13, null);    contentPane.add(jLabel12, null);    contentPane.add(jLabel11, null);    contentPane.add(jLabel10, null);    contentPane.add(jdbTextField9, null);    contentPane.add(jdbTextField10, null);    contentPane.add(jdbTextField12, null);    contentPane.add(jdbTextField11, null);    contentPane.add(jdbTextField8, null);    contentPane.add(jdbNavField1, null);    contentPane.add(jButton2, null);    contentPane.add(jdbTextField14, null);    contentPane.add(jLabel15, null);    tableScrollPane1.getViewport().add(jdbTable1, null);  }  //Overridden so we can exit when window is closed  protected void processWindowEvent(WindowEvent e) {    super.processWindowEvent(e);    if (e.getID() == WindowEvent.WINDOW_CLOSING) {      System.exit(0);    }  }  void jButton1_actionPerformed(ActionEvent e) {DB_Customer.saveChanges(queryDataSet_Customer);  }  void jButton2_actionPerformed(ActionEvent e) {   System.exit(0);  }}