customer_frame.java

开发源码.java开发项目开发 源码.java开发项目

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