frame3.java~165~

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

            }
          }

  }

  void jToggleButton2_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 bh from ygxinxi ");
         if (rSet.next()==false)                        // 判断数据库中是否有要删除的记录，如没有则显示提示框
         {
           jTextArea12.setText("");
           jTextArea13.setText("编号不存在");
           //jTextPane1.setText("数据库中没有您要删除的学号!");
         }
         else
         {
           String sql2="delete from ygxinxi where bh='"+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");
       //   //  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) {
    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);
  }
}