checkoperate.java~5~

java+sql2000企业人力管理系统

package managersystem.Check;

import java.util.Vector;
import java.sql.*;
import managersystem.DBGet;
import java.util.ArrayList;

public class CheckOperate {
    public CheckOperate() {
    }
    public Vector getChech(){
        Vector data = new Vector();
        Connection con = null;
        PreparedStatement ptmt = null;
        ResultSet rs = null;
        String strSQL = "select * from Employees";
        try {
          DBGet objB = new DBGet();
          con = objB.getConnection();
          ptmt = con.prepareStatement(strSQL);
          rs = ptmt.executeQuery();
          while(rs.next()){
            data.add(rs.getString(1));
            data.add(rs.getString(2));
            data.add(rs.getString(3));
            data.add(rs.getString(4));
            data.add(rs.getString(5));
            data.add(rs.getString(6));
            data.add(rs.getString(7));
            data.add(rs.getString(8));
            data.add(rs.getString(9));
            data.add(rs.getString(10));
            data.add(rs.getString(11));
            data.add(rs.getString(12));
            data.add(rs.getString(13));
            data.add(rs.getString(14));
            data.add(rs.getString(15));
            data.add(rs.getString(16));
          }
          rs.close();
          ptmt.close();
          con.close();
        }
        catch (Exception ex) {
          ex.printStackTrace();
        }
        return data;

  }


  //利用ArrayList来获取员工信息
  //添加用户信息
  public ArrayList ArrayCheck(){
    ArrayList arrayname = new ArrayList();
    Connection con = null;
    PreparedStatement ptmt = null;
    ResultSet rs = null;
    String strSQL = "select * from Users";
    try {
      DBGet objG = new DBGet();
      con = objG.getConnection();
      ptmt = con.prepareStatement(strSQL);
      rs = ptmt.executeQuery();
      while(rs.next()){
        arrayname.add(rs.getString(1));
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return arrayname;
  }

}