frame6.java~36~

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

    Frame6_jToggleButton1_actionAdapter(Frame6 adaptee) {
      this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
      adaptee.jToggleButton1_actionPerformed(e);
    }
  }

  void this_ancestorMoved(HierarchyEvent e) {

  }

  //void jToggleButton3_componentShown(ComponentEvent e) {

    //}
  //}

  void jToggleButton2_focusGained(FocusEvent e) {
    Connection connection = null; // 声明Connection接口对象connection
    Statement statement = null; // 定义查询数据库的Statement对象
    ResultSet rSet = null;

    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
      connection = DriverManager.getConnection("jdbc:odbc:liulei");
      //   //  String data_driver="sun.jdbc.odbc.JdbcOdbcDriver";
      //  Class.forName(data_driver);
      //   String connectionStr="jdbc:odbc:liulei";
      //   Connection con=DriverManager.getConnection(connectionStr, "", "");   //没有配置用户名和密码就用空代替
      Statement stmt = connection.createStatement();
      ResultSet rs = stmt.executeQuery(
          "select * from qichexinxi where qichebh='" +
          Integer.parseInt(jTextField1.getText()) + "'");
      jTextField1.setText("");
      //	ResultSet rs=stmt.executeQuery("select * From cost where an and jCostMonth="+Integer.parseInt(textMonth.getText())+"");
      int i = 0;
      while (rs.next()) {
        i++;
        jTextArea1.setText(rs.getString("qichebh"));
        jTextArea2.setText(rs.getString("qichepz"));
        jTextArea3.setText(rs.getString("qichecx"));
        jTextArea4.setText(rs.getString("qichepl"));
        jTextArea5.setText(rs.getString("qichejhjg"));
        jTextArea6.setText(rs.getString("qichexsjg"));
        jTextArea7.setText(rs.getString("qichexn"));
        jTextArea8.setText(rs.getString("qichekc"));
        // jTextArea9.setText(rs.getString("jl"));
        // jTextArea10.setText(rs.getString("xb"));
        //jTextArea11.setText(rs.getString("sg"));
        //jTextField2.setText(rSet.getString(2));
        //   jTextField3.setText(rSet.getString(3));
        //  jTextField4.setText(rSet.getString(4));

        /*   int waterPrice=Integer.parseInt(rs.getString("bh"));
            int waterQua= Integer.parseInt(rs.getString("xm"));
            int ePrice=Integer.parseInt(rs.getString("xl"));
            int eQua=Integer.parseInt(rs.getString("nl"));
            int areaPrice=Integer.parseInt(rs.getString("zc"));
          int areaPrice1=Integer.parseInt(rs.getString("jg"));
         int areaPrice2=Integer.parseInt(rs.getString("dh"));
          int areaPrice3=Integer.parseInt(rs.getString("qq"));
             int areaPrice4=Integer.parseInt(rs.getString("jl"));
                           int areaPrice5=Integer.parseInt(rs.getString("xb"));
          int areaPrice6=Integer.parseInt(rs.getString("sg"));
                //*area;
                  jTextArea1.setText(String.valueOf(waterPrice));
                  jTextArea2.setText(String.valueOf(waterQua));
                   jTextArea3.setText(String.valueOf(ePrice));
                   jTextArea4.setText(String.valueOf(eQua));
                   jTextArea5.setText(String.valueOf(areaPrice));
                   jTextArea6.setText(String.valueOf(areaPrice1));
                   jTextArea7.setText(String.valueOf(areaPrice2));
                   jTextArea8.setText(String.valueOf(areaPrice3));
                   jTextArea9.setText(String.valueOf(areaPrice4));
                   jTextArea10.setText(String.valueOf(areaPrice5));
                    jTextArea11.setText(String.valueOf(areaPrice6));*/

         //TextSum.setText(String.valueOf(waterPrice*waterQua+eQua*ePrice+areaPrice));
      }
      //jTextField1.setText("");
      stmt.close();
      connection.close();

    }
    catch (Exception ex) {
    }

  }

  void jToggleButton3_ancestorMoved(AncestorEvent e) {
        Connection connection = null; // 声明Connection接口对象connection
        Statement statement = null; // 定义查询数据库的Statement对象
        ResultSet rSet = null;
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
          connection = DriverManager.getConnection("jdbc:odbc:liulei"); // 连接数据库
          // 创建Statement接口对象
          statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                 ResultSet.CONCUR_UPDATABLE);
          rSet = statement.executeQuery("select qichebh from qichexinxi ");
          if (rSet.next() == false) { // 判断数据库中是否有要删除的记录，如没有则显示提示框
            jTextArea1.setText("");
            //jTextPane1.setText("数据库中没有您要删除的学号!");
          }
          else {
            String sql2 = "delete from qichexinxi where qichebh='" + jTextArea1.getText() + "'";
            statement.executeUpdate(sql2); // 删除stu_info表中对应学号的数据记录
            // 清空信息框
            // jTextArea12.setText("");
            jTextArea1.setText("");
            jTextArea2.setText("");
            jTextArea3.setText("");
            jTextArea4.setText("");
            jTextArea5.setText("");
            jTextArea6.setText("");
            jTextArea7.setText("");
            jTextArea8.setText("");
            //  jTextArea9.setText("");
            // jTextArea10.setText("");
            //  jTextArea11.setText("");

            //jTextPane1.setText("记录已成功删除!");
          }
        }
        catch (SQLException ex) { // 捕捉异常
          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());
          }
        }
  }

  /*void jToggleButton4_ancestorMoved(AncestorEvent e) {
    Connection connection = null; // 声明Connection接口对象connection
        Statement statement = null; // 定义查询数据库的Statement对象
        ResultSet rSet = null;
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
          connection = DriverManager.getConnection("jdbc:odbc:liulei"); // 连接数据库
          // 创建Statement接口对象
          statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                 ResultSet.CONCUR_UPDATABLE);
          rSet = statement.executeQuery("select qichebh from qichexinxi ");
          if (rSet.next() == false) { // 判断数据库中是否有要删除的记录，如没有则显示提示框
            jTextArea1.setText("");
            //jTextPane1.setText("数据库中没有您要删除的学号!");
          }
          else {
            String sql2 = "delete from qichexinxi where qichebh='"+jTextArea1.getText()+ "'";
            statement.executeUpdate(sql2); // 删除stu_info表中对应学号的数据记录
            // 清空信息框
            // jTextArea12.setText("");
            jTextArea1.setText("");
            jTextArea2.setText("");
            jTextArea3.setText("");
            jTextArea4.setText("");
            jTextArea5.setText("");
            jTextArea6.setText("");
            jTextArea7.setText("");
            jTextArea8.setText("");
            //  jTextArea9.setText("");
            // jTextArea10.setText("");
            //  jTextArea11.setText("");

            //jTextPane1.setText("记录已成功删除!");
          }
        }
        catch (SQLException ex) { // 捕捉异常
          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());
          }
        }
  }*/

  void jToggleButton3_actionPerformed(ActionEvent e) {
    Connection connection = null; // 声明Connection接口对象connection
            Statement statement = null; // 定义查询数据库的Statement对象
            ResultSet rSet = null;
            try {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // 实例化JDBC-ODBC桥的驱动
              connection = DriverManager.getConnection("jdbc:odbc:liulei"); // 连接数据库
              // 创建Statement接口对象
              statement = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                     ResultSet.CONCUR_UPDATABLE);
              rSet = statement.executeQuery("select qichebh from qichexinxi ");
              if (rSet.next() == false) { // 判断数据库中是否有要删除的记录，如没有则显示提示框
                jTextArea1.setText("");
                //jTextPane1.setText("数据库中没有您要删除的学号!");
              }
              else {
                String sql2 = "delete from qichexinxi where qichebh='"+jTextArea1.getText()+ "'";
                statement.executeUpdate(sql2); // 删除stu_info表中对应学号的数据记录
                // 清空信息框
                // jTextArea12.setText("");
                jTextArea1.setText("");
                jTextArea2.setText("");
                jTextArea3.setText("");
                jTextArea4.setText("");
                jTextArea5.setText("");
                jTextArea6.setText("");
                jTextArea7.setText("");
                jTextArea8.setText("");
                //  jTextArea9.setText("");
                // jTextArea10.setText("");
                //  jTextArea11.setText("");

                //jTextPane1.setText("记录已成功删除!");