empoperate.java

java+sql2000企业人力管理系统

package managersystem.Emp;

import java.util.Vector;
import managersystem.CustomTableModule;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Connection;
import managersystem.DBGet;
/**
 * <p>Title: 企业人力资源管理系统</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author 腾龙工作组
 * @version 1.0
 */
public class EmpOperate {
    public EmpOperate() {
    }
    //获取数据库Employees表数据
      public Vector getAllEmployee() {
        Vector data = new Vector();
        Connection con = null;
        PreparedStatement ptmt = null;
        ResultSet rs = null;
        String strSQL = "select * from Employees";
        try {
          DBGet objG = new DBGet();
          con = objG.getConnection();
          ptmt = con.prepareStatement(strSQL);
          rs = ptmt.executeQuery();
          while (rs.next()) {
            data.add(new Integer(rs.getInt(1)));
            for (int i = 2; i <= 22; i++) {
              data.add(rs.getString(i));
            }
            data.add(new Integer(rs.getInt(23)));
            data.add(new Integer(rs.getInt(24)));
            data.add(rs.getString(25));
            data.add(rs.getString(26));
            data.add(new Integer(rs.getInt(27)));
            data.add(new Integer(rs.getInt(28)));
            data.add(rs.getString(29));
            data.add(new Integer(rs.getInt(30)));
            data.add(new Integer(rs.getInt(31)));
            data.add(rs.getString(32));
            data.add(rs.getString(33));
            data.add(rs.getString(34));
          }
          rs.close();
          ptmt.close();
          con.close();
        }
        catch (Exception ex) {
          ex.printStackTrace();
        }
        return data;
  }
}