frame3.java~165~

员工管理加销售管理,填加修改删除员工信息,统计员工的销售情况的.非常不错哈

package liulei;
import java.lang.*;
import java.lang.Object.*;
import java.sql.*;
import java.util.*;
import javax.swing.event.*;
import javax.swing.table.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

public class Frame3 extends JFrame {
  JPanel contentPane;
  JToggleButton jToggleButton1 = new JToggleButton();
  JTextArea jTextArea1 = new JTextArea();
  JTextArea jTextArea2 = new JTextArea();
  JTextArea jTextArea3 = new JTextArea();
  JTextArea jTextArea4 = new JTextArea();
  JTextArea jTextArea5 = new JTextArea();
  JTextArea jTextArea6 = new JTextArea();
  JTextArea jTextArea7 = new JTextArea();
  JTextArea jTextArea8 = new JTextArea();
  JTextArea jTextArea9 = new JTextArea();
  JTextArea jTextArea10 = new JTextArea();
  JTextArea jTextArea11 = new JTextArea();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JToggleButton jToggleButton2 = new JToggleButton();
  JTextArea jTextArea12 = new JTextArea();
  JToggleButton jToggleButton3 = new JToggleButton();
  JTextField jTextField1 = new JTextField();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel12 = new JLabel();
  JTextArea jTextArea13 = new JTextArea();

  //Construct the frame
  public Frame3() {

    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(null);
    this.setSize(new Dimension(400, 300));
    this.setTitle("Frame Title");
    jToggleButton1.setBackground(Color.green);
    jToggleButton1.setFont(new java.awt.Font("Dialog", 0, 15));
    jToggleButton1.setForeground(Color.blue);
    jToggleButton1.setText("添加");
    jToggleButton1.setBounds(new Rectangle(4, 227, 85, 29));
    jToggleButton1.addActionListener(new Frame3_jToggleButton1_actionAdapter(this));
    jToggleButton1.addActionListener(new Frame3_jToggleButton1_actionAdapter(this));
    jTextArea1.setText("");
    jTextArea1.setColumns(0);
    jTextArea1.setTabSize(8);
    jTextArea1.setBounds(new Rectangle(75, 33, 94, 18));
    jTextArea2.setText("");
    jTextArea2.setBounds(new Rectangle(74, 63, 95, 18));
    jTextArea3.setText("");
    jTextArea3.setBounds(new Rectangle(73, 94, 95, 18));
    jTextArea4.setToolTipText("");
    jTextArea4.setText("");
    jTextArea4.setBounds(new Rectangle(73, 125, 96, 18));
    jTextArea5.setToolTipText("");
    jTextArea5.setText("");
    jTextArea5.setBounds(new Rectangle(74, 157, 96, 18));
    jTextArea6.setText("");
    jTextArea6.setBounds(new Rectangle(73, 190, 99, 18));
    jTextArea7.setText("");
    jTextArea7.setBounds(new Rectangle(262, 32, 102, 18));
    jTextArea8.setText("");
    jTextArea8.setBounds(new Rectangle(262, 68, 104, 18));
    jTextArea9.setText("");
    jTextArea9.setBounds(new Rectangle(261, 157, 107, 31));
    jTextArea10.setText("");
    jTextArea10.setBounds(new Rectangle(262, 97, 103, 18));
    jTextArea11.setToolTipText("");
    jTextArea11.setText("");
    jTextArea11.setBounds(new Rectangle(263, 126, 104, 19));
    contentPane.setBackground(Color.cyan);
    contentPane.setFont(new java.awt.Font("Dialog", 0, 13));
    contentPane.setAlignmentY((float) 0.5);
    contentPane.setMaximumSize(new Dimension(32767, 32767));
    contentPane.setMinimumSize(new Dimension(1, 1));
    contentPane.setOpaque(true);
    contentPane.setPreferredSize(new Dimension(1, 1));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("编号");
    jLabel1.setBounds(new Rectangle(17, 35, 34, 16));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("姓名");
    jLabel2.setBounds(new Rectangle(15, 67, 34, 16));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("学历");
    jLabel3.setBounds(new Rectangle(13, 97, 34, 16));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("年龄");
    jLabel4.setBounds(new Rectangle(18, 129, 34, 16));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("职称");
    jLabel5.setBounds(new Rectangle(13, 160, 34, 16));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel6.setText("籍贯");
    jLabel6.setBounds(new Rectangle(16, 191, 34, 16));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel7.setText("电话");
    jLabel7.setBounds(new Rectangle(209, 34, 34, 16));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel8.setText("亲戚");
    jLabel8.setBounds(new Rectangle(213, 67, 34, 16));
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel9.setText("简历");
    jLabel9.setBounds(new Rectangle(213, 161, 39, 21));
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel10.setVerifyInputWhenFocusTarget(true);
    jLabel10.setText("性别");
    jLabel10.setBounds(new Rectangle(212, 100, 40, 16));
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel11.setText("身高");
    jLabel11.setBounds(new Rectangle(212, 129, 40, 16));
    jToggleButton2.setBackground(Color.orange);
    jToggleButton2.setFont(new java.awt.Font("Dialog", 0, 15));
    jToggleButton2.setAlignmentX((float) 0.0);
    jToggleButton2.setText("删除");
    jToggleButton2.setBounds(new Rectangle(293, 202, 87, 29));
    jToggleButton2.addActionListener(new Frame3_jToggleButton2_actionAdapter(this));
    jToggleButton2.addActionListener(new Frame3_jToggleButton2_actionAdapter(this));
    jTextArea12.setBounds(new Rectangle(134, 232, 66, 18));
    jToggleButton3.setBackground(Color.pink);
    jToggleButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jToggleButton3.setText("查询");
    jToggleButton3.setBounds(new Rectangle(291, 231, 88, 24));
    jToggleButton3.addActionListener(new Frame3_jToggleButton3_actionAdapter(this));
    jToggleButton3.addActionListener(new Frame3_jToggleButton3_actionAdapter(this));
    jTextField1.setBounds(new Rectangle(136, 233, 57, 22));
    jTextField2.setBounds(new Rectangle(189, 230, 85, 22));
    jLabel12.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel12.setText("销售人员基本信息");
    jLabel12.setBounds(new Rectangle(144, 5, 156, 21));
    jTextArea13.setText("请输入编号");
    jTextArea13.setBounds(new Rectangle(94, 230, 90, 24));
    contentPane.add(jTextArea1, null);
    contentPane.add(jLabel1, null);
    contentPane.add(jTextArea2, null);
    contentPane.add(jLabel2, null);
    contentPane.add(jTextArea3, null);
    contentPane.add(jTextArea4, null);
    contentPane.add(jTextArea5, null);
    contentPane.add(jTextArea6, null);
    contentPane.add(jLabel3, null);
    contentPane.add(jLabel6, null);
    contentPane.add(jLabel5, null);
    contentPane.add(jLabel4, null);
    contentPane.add(jTextArea7, null);
    contentPane.add(jLabel7, null);
    contentPane.add(jTextArea8, null);
    contentPane.add(jTextArea10, null);
    contentPane.add(jTextArea11, null);
    contentPane.add(jTextArea9, null);
    contentPane.add(jLabel9, null);
    contentPane.add(jLabel11, null);
    contentPane.add(jLabel10, null);
    contentPane.add(jLabel8, null);
    contentPane.add(jToggleButton1, null);
    contentPane.add(jLabel12, null);
    contentPane.add(jTextArea13, null);
    contentPane.add(jTextField2, null);
    contentPane.add(jToggleButton3, null);
    contentPane.add(jToggleButton2, null);


  }
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {

    }
  }

  void jToggleButton1_actionPerformed(ActionEvent e) {
       Connection connection = null; // 声明Connection接口对象connection
       Statement statement = null; // 定义查询数据库的Statement对象
       String ygxinxi[] = {"bh","xm","xl","nl","zc","jg","dh","qq","jl","xb","sg"};    // 二维表列名
    try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
           connection = DriverManager.getConnection("jdbc:odbc:liulei"); // 连接数据库
            // 创建Statement接口对象
           statement = connection.createStatement();
            String sql1 = "insert  into ygxinxi  values ('" + jTextArea1.getText() +
                "','" + jTextArea2.getText() + "','" + jTextArea3.getText() + "','" +
                jTextArea4.getText() + "','" + jTextArea5.getText() + "','" + jTextArea6.getText() + "','"
                + jTextArea7.getText() + "','" + jTextArea8.getText() + "','" + jTextArea9.getText() + "','" + jTextArea10.getText() + "','" + jTextArea11.getText() + "')";
            if (jTextArea1.getText().length() == 0) {
           //  jTextPane1.setText("不能修改，请先输入学号！");
              // 清空信息框
              jTextArea1.setText("");
              jTextArea2.setText("");
              jTextArea3.setText("");
              jTextArea4.setText("");
              jTextArea5.setText("");
              jTextArea6.setText("");
              jTextArea7.setText("");
              jTextArea8.setText("");
              jTextArea9.setText("");
              jTextArea10.setText("");
              jTextArea11.setText("");
            }
            else {
              statement.executeUpdate(sql1); // stu_info表中添加记录
           //  jTextPane1.setText("记录添加成功!");
              // 清空信息框
              jTextArea1.setText("");
             jTextArea2.setText("");
             jTextArea3.setText("");
             jTextArea4.setText("");
             jTextArea5.setText("");
             jTextArea6.setText("");
             jTextArea7.setText("");
             jTextArea8.setText("");
             jTextArea9.setText("");
             jTextArea10.setText("");
             jTextArea11.setText("");

            }
          }
          catch (SQLException ex) { // 捕捉异常
            //jTextPane1.setText(ex.getMessage());
            System.out.println("\nERROR:----- SQLException -----\n");
            while (ex != null) {
              System.out.println("Message:   " + ex.getMessage());
              System.out.println("SQLState:  " + ex.getSQLState());
              System.out.println("ErrorCode: " + ex.getErrorCode());
              ex = ex.getNextException();
            }
          }
          catch (Exception ex) {
            ex.printStackTrace();
          }
          finally {
            try {
              if (statement != null) {
                statement.close(); // 关闭Statement接口实例
              }
              if (connection != null) {
                connection.close(); // 关闭Connection接口实例
              }
            }
            catch (SQLException ex) {
              System.out.println("\nERROR:----- SQLException -----\n");
              System.out.println("Message:   " + ex.getMessage());
              System.out.println("SQLState:  " + ex.getSQLState());
              System.out.println("ErrorCode: " + ex.getErrorCode());