frame6.java~36~

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

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.*;

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

public class Frame6 extends JFrame {
  JPanel contentPane;
  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();
  JToggleButton jToggleButton1 = new JToggleButton();
  JTextField jTextField1 = new JTextField();
  JToggleButton jToggleButton2 = new JToggleButton();
  JToggleButton jToggleButton3 = 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();
  JToggleButton jToggleButton4 = new JToggleButton();
  JLabel jLabel10 = new JLabel();

  //Construct the frame
  public Frame6() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception {
    contentPane = (JPanel)this.getContentPane();
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 14));
    jLabel1.setText("汽车信息");
    jLabel1.setBounds(new Rectangle(168, 5, 119, 32));
    contentPane.setLayout(null);
    this.setSize(new Dimension(400, 300));
    this.setTitle("Frame Title");
    this.addHierarchyBoundsListener(new Frame6_this_hierarchyBoundsAdapter(this));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("汽车编号");
    jLabel2.setBounds(new Rectangle(6, 45, 57, 26));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("汽车牌子");
    jLabel3.setBounds(new Rectangle(7, 88, 54, 16));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("汽车车型");
    jLabel4.setBounds(new Rectangle(5, 121, 64, 16));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("汽车排量");
    jLabel5.setBounds(new Rectangle(5, 153, 62, 21));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel6.setText("进货价格");
    jLabel6.setBounds(new Rectangle(182, 49, 61, 22));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel7.setText("销售价格");
    jLabel7.setBounds(new Rectangle(184, 87, 61, 24));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel8.setText("性能");
    jLabel8.setBounds(new Rectangle(187, 115, 71, 20));
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel9.setText("库存");
    jLabel9.setBounds(new Rectangle(186, 145, 51, 27));
    jToggleButton1.setBackground(Color.pink);
    jToggleButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jToggleButton1.setText("填加");
    jToggleButton1.setBounds(new Rectangle(34, 195, 86, 25));
    jToggleButton1.addActionListener(new Frame6_jToggleButton1_actionAdapter(this));
    jToggleButton1.addActionListener(new Frame6_jToggleButton1_actionAdapter(this));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(275, 198, 74, 20));
    jToggleButton2.setBackground(Color.pink);
    jToggleButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jToggleButton2.setText("查看");
    jToggleButton2.setBounds(new Rectangle(159, 230, 81, 25));
    jToggleButton2.addFocusListener(new Frame6_jToggleButton2_focusAdapter(this));
    jToggleButton3.setBackground(Color.yellow);
    jToggleButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jToggleButton3.setText("删除");
    jToggleButton3.setBounds(new Rectangle(275, 227, 80, 25));
    jToggleButton3.addActionListener(new Frame6_jToggleButton3_actionAdapter(this));
    jToggleButton3.addAncestorListener(new Frame6_jToggleButton3_ancestorAdapter(this));
    jToggleButton3.addComponentListener(new
                                        Frame6_jToggleButton3_componentAdapter(this));
    jTextArea1.setText("");
    jTextArea1.setBounds(new Rectangle(75, 51, 91, 17));
    jTextArea2.setText("");
    jTextArea2.setBounds(new Rectangle(75, 89, 90, 21));
    jTextArea3.setText("");
    jTextArea3.setBounds(new Rectangle(73, 121, 93, 19));
    jTextArea4.setText("");
    jTextArea4.setBounds(new Rectangle(76, 151, 88, 23));
    jTextArea5.setText("");
    jTextArea5.setBounds(new Rectangle(250, 55, 125, 19));
    jTextArea6.setText("");
    jTextArea6.setBounds(new Rectangle(253, 90, 121, 18));
    jTextArea7.setText("");
    jTextArea7.setBounds(new Rectangle(256, 121, 123, 18));
    jTextArea8.setText("");
    jTextArea8.setBounds(new Rectangle(257, 155, 118, 18));
    jToggleButton4.setBackground(Color.cyan);
    jToggleButton4.setFont(new java.awt.Font("Dialog", 0, 13));
    jToggleButton4.setText("修改");
    jToggleButton4.setBounds(new Rectangle(32, 231, 91, 25));
    jToggleButton4.addActionListener(new Frame6_jToggleButton4_actionAdapter(this));
    jToggleButton4.addAncestorListener(new Frame6_jToggleButton4_ancestorAdapter(this));
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel10.setText("输入汽车编号");
    jLabel10.setBounds(new Rectangle(166, 199, 92, 20));
    contentPane.setBackground(Color.pink);
    contentPane.add(jLabel4, null);
    contentPane.add(jLabel6, null);
    contentPane.add(jLabel5, null);
    contentPane.add(jLabel3, null);
    contentPane.add(jLabel9, null);
    contentPane.add(jTextArea2, null);
    contentPane.add(jTextArea3, null);
    contentPane.add(jLabel7, null);
    contentPane.add(jTextArea4, null);
    contentPane.add(jTextArea5, null);
    contentPane.add(jTextArea6, null);
    contentPane.add(jTextArea8, null);
    contentPane.add(jLabel1, null);
    contentPane.add(jTextArea1, null);
    contentPane.add(jLabel2, null);
    contentPane.add(jLabel8, null);
    contentPane.add(jTextArea7, null);
    contentPane.add(jToggleButton1, null);
    contentPane.add(jToggleButton4, null);
    contentPane.add(jLabel10, null);
    contentPane.add(jTextField1, 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) {
      // System.exit(0);
    }
  }

  void jToggleButton1_actionPerformed(ActionEvent e) {
    Connection connection = null; // 声明Connection接口对象connection
    Statement statement = null; // 定义查询数据库的Statement对象
    String ygxinxi[] = {
        "qichebh", "qichepz", "qichecx", "qichepl", "qichejhjg", "qichexsjg",
        "qichexn", "qichekc"}; // 二维表列名
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
      connection = DriverManager.getConnection("jdbc:odbc:liulei"); // 连接数据库
      // 创建Statement接口对象
      statement = connection.createStatement();
      String sql1 = "insert  into qichexinxi  values ('" + jTextArea1.getText() +
          "','" + jTextArea2.getText() + "','" + jTextArea3.getText() + "','" +
          jTextArea4.getText() + "','" + jTextArea5.getText() + "','" +
          jTextArea6.getText() + "','"
          + jTextArea7.getText() + "','" + jTextArea8.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());
      }
    }

  }

  class Frame6_jToggleButton1_actionAdapter
      implements java.awt.event.ActionListener {
    Frame6 adaptee;