frame6.java~36~

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

              }
            }
            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_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();
            if (jTextArea1.getText().length() == 0)
            {
              //jTextPane1.setText("不能修改，请先输入学号！");
            }
            else {
              if (jTextArea1.getText().length() != 0)
                statement.executeUpdate("update qichexinxi set qichepz='" +
                      jTextArea2.getText() + "' where qichebh='" +

                     jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
              if (jTextArea3.getText().length() != 0)
                statement.executeUpdate("update qichexinxi set qichecx='" +
                      jTextArea3.getText() + "' where qichebh='" +
                          jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
              if (jTextArea4.getText().length() != 0)
                             statement.executeUpdate("update qichexinxi set qichepl='" +
                                jTextArea4.getText() + "' where qichebh='" +
                                   jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
               if (jTextArea5.getText().length() != 0)
                statement.executeUpdate("update qichexinxi set qichejhjg='" +
                    jTextArea5.getText() + "' where qichebh='" +
                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
           if (jTextArea6.getText().length() != 0)
                     statement.executeUpdate("update qichexinxi set qichexsjg='" +
                          jTextArea6.getText() + "' where qichebh='" +
                           jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
                //表中学号相关的记录
              if (jTextArea7.getText().length() != 0)
                    statement.executeUpdate("update qichexinxi set qichexn='" +
                          jTextArea7.getText() + "' where qichebh='" +
                            jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录

              if (jTextArea8.getText().length() != 0)
                statement.executeUpdate("update qichexinxi set qichekc='" +
                     jTextArea8.getText() + "' where qichebh='" +
                        jTextArea1.getText() + "'"); // 更新stu_info表中输入学号的记录
              if (jTextArea2.getText().length() == 0 &
                  jTextArea3.getText().length() == 0 &
                  jTextArea4.getText().length() == 0 &
                  jTextArea5.getText().length() == 0 &
                  jTextArea6.getText().length() == 0 &
                  jTextArea7.getText().length() == 0 &
                 // jTextArea8.getText().length() == 0 &
                //  jTextArea9.getText().length() == 0 &
                //  jTextArea10.getText().length() == 0 &
                  jTextArea8.getText().length() == 0) {
                //jTextPane1.setText("修改不成功,请重新输入！");
              }
              else {
               // 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_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);
  }
}

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

  Frame6_jToggleButton4_actionAdapter(Frame6 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton4_actionPerformed(e);
  }
}