frame6.java~29~

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

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