frame3.java~167~

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

           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");
       //   //  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 ygxinxi where bh='"+Integer.parseInt(jTextField2.getText())+"'");
           jTextField2.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("bh"));
               jTextArea2.setText(rs.getString("xm"));
               jTextArea3.setText(rs.getString("xl"));
               jTextArea4.setText(rs.getString("nl"));
               jTextArea5.setText(rs.getString("zc"));
               jTextArea6.setText(rs.getString("jg"));
               jTextArea7.setText(rs.getString("dh"));
               jTextArea8.setText(rs.getString("qq"));
               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));
                                   }
                                   jTextField2.setText("");
                                       stmt.close();
                                    connection.close();

                               }
                               catch(Exception ex){
                               }

  }





class Frame3_jToggleButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton1_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton1_actionPerformed(e);
  }
}

class Frame3_jToggleButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton2_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton2_actionPerformed(e);
  }
}

class Frame3_jToggleButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton3_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton3_actionPerformed(e);
  }
}

  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 ygxinxi set xm='" +
                                        jTextArea2.getText() + "' where bh='" +

                                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
              if (jTextArea3.getText().length() != 0)
                statement.executeUpdate("update ygxinxi set xl='" +
                                        jTextArea3.getText() + "' where bh='" +
                                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
              if (jTextArea4.getText().length() != 0)
                             statement.executeUpdate("update ygxinxi set nl='" +
                                                     jTextArea4.getText() + "' where bh='" +
                                                     jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
               if (jTextArea5.getText().length() != 0)
                statement.executeUpdate("update ygxinxi set zc='" +
                    jTextArea5.getText() + "' where bh='" +
                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
           if (jTextArea6.getText().length() != 0)
                     statement.executeUpdate("update ygxinxi set jg='" +
                          jTextArea6.getText() + "' where bh='" +
                                 jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
                   if (jTextArea7.getText().length() != 0)
                              statement.executeUpdate("update ygxinxi set dh='" +
                                   jTextArea7.getText() + "' where bh='" +
                                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
                            if (jTextArea8.getText().length() != 0)
                                     statement.executeUpdate("update ygxinxi set qq='" +
                                          jTextArea8.getText() + "' where bh='" +
                                                jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
                if (jTextArea9.getText().length() != 0)
                   statement.executeUpdate("update ygxinxi set xb='" +
                                        jTextArea9.getText() + "' where bh='" +
                                                        jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录
                     if (jTextArea10.getText().length() != 0)
                                statement.executeUpdate("update ygxinxi set sg='" +
                                            jTextArea10.getText() + "' where bh='" +
                                                            jTextArea1.getText() + "'"); // 更新stu_info表中学号相关的记录

              if (jTextArea11.getText().length() != 0)
                statement.executeUpdate("update ygxinxi set jl='" +
                                        jTextArea11.getText() + "' where bh='" +
                                        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 &
                  jTextArea11.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());
            }
          }
        }



 /* void jToggleButton4_actionPerformed(ActionEvent e) {
    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:driver={Microsoft Access liulei (*.mdb)};DBQ=./ygxinxi.mdb";
              Connection con=DriverManager.getConnection(connectionStr, "", "");   //没有配置用户名和密码就用空代替
               Statement stmt=con.createStatement();
                ResultSet rs=stmt.executeQuery("select * From ygxinxi where 编号='"+jTextArea1.getText()+"'");
               // jTextField2.setText("");

               while(rs.next())
                  {
                      //int waterPrice=Integer.parseInt(rs.getString("编号"));
                       int waterQua= Integer.parseInt(rs.getString("姓名"));
                       int ePrice=Integer.parseInt(rs.getString("学历"));
                       int eQua=Integer.parseInt(rs.getString("年龄"));
                       int areaPrice=Integer.parseInt(rs.getString("职称"));
                     int areaPrice1=Integer.parseInt(rs.getString("籍贯"));
                    int areaPrice2=Integer.parseInt(rs.getString("电话"));
                     int areaPrice3=Integer.parseInt(rs.getString("亲戚"));
                   int areaPrice4=Integer.parseInt(rs.getString("简历"));
                  int areaPrice5=Integer.parseInt(rs.getString("性别"));
                     int areaPrice6=Integer.parseInt(rs.getString("身高"));
                           //*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));
                                      }
                                          stmt.close();
                                       con.close();

                                  }
                                  catch(Exception ex){
                                  }

  }*/}

class Frame3_jToggleButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton3_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton3_actionPerformed(e);
  }
}

class Frame3_jToggleButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton2_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton2_actionPerformed(e);
  }
}

class Frame3_jToggleButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton1_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton1_actionPerformed(e);
  }
}

class Frame3_jToggleButton4_actionAdapter implements java.awt.event.ActionListener {
  Frame3 adaptee;

  Frame3_jToggleButton4_actionAdapter(Frame3 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jToggleButton4_actionPerformed(e);
  }
}