frame6.java~33~

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

                   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("记录已成功删除!");
              }
            }
            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());
              }
            }
  }
}
  class Frame6_this_hierarchyBoundsAdapter
      extends java.awt.event.HierarchyBoundsAdapter {
    Frame6 adaptee;

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

    public void ancestorMoved(HierarchyEvent e) {
      adaptee.this_ancestorMoved(e);
    }
  }

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

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

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

  class Frame6_jToggleButton2_focusAdapter
      extends java.awt.event.FocusAdapter {
    Frame6 adaptee;

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

    public void focusGained(FocusEvent e) {
      adaptee.jToggleButton2_focusGained(e);
    }
  }

  class Frame6_jToggleButton3_componentAdapter
      extends java.awt.event.ComponentAdapter {
    Frame6 adaptee;

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

    public void componentShown(ComponentEvent e) {
    //  adaptee.jToggleButton3_componentShown(e);
    }
  }

class Frame6_jToggleButton3_ancestorAdapter implements javax.swing.event.AncestorListener {
  Frame6 adaptee;

  Frame6_jToggleButton3_ancestorAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void ancestorAdded(AncestorEvent e) {
  }
  public void ancestorRemoved(AncestorEvent e) {
  }
  public void ancestorMoved(AncestorEvent e) {
    adaptee.jToggleButton3_ancestorMoved(e);
  }
}

class Frame6_jToggleButton4_ancestorAdapter implements javax.swing.event.AncestorListener {
  Frame6 adaptee;

  Frame6_jToggleButton4_ancestorAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void ancestorAdded(AncestorEvent e) {
  }
  public void ancestorRemoved(AncestorEvent e) {
  }
  public void ancestorMoved(AncestorEvent e) {
    //adaptee.jToggleButton4_ancestorMoved(e);
  }
}

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

  Frame6_jToggleButton3_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton3_actionPerformed(e);
  }
}