checkoperate.java

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 CheckIn";
        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 Employees";
    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;
  }
//添加考勤信息
  public boolean DepartmentAdd(CheckIn objD){
      boolean success = false;
      Connection con = null;
      PreparedStatement ptmt = null;
      String strSQL = "insert into CheckIn values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
      try {
        DBGet objG = new DBGet();
        con =objG.getConnection();
        ptmt = con.prepareStatement(strSQL);
        ptmt.setString(1,objD.getCheckinMonth());
        ptmt.setInt(2,objD.getEmp_id());
        ptmt.setInt(3,objD.getDaysOfMonth());
        ptmt.setInt(4,objD.getQqDays());
        ptmt.setInt(5,objD.getBjDays());
        ptmt.setInt(6,objD.getSjDays());
        ptmt.setInt(7,objD.getKgDays());
        ptmt.setInt(8,objD.getFdxjDays());
        ptmt.setInt(9,objD.getNxjDays());
        ptmt.setInt(10,objD.getDxjDays());
        ptmt.setInt(11,objD.getCxDays());
        ptmt.setInt(12,objD.getCdDays());
        ptmt.setInt(13,objD.getZtDays());
        ptmt.setInt(14,objD.getOt1Days());
        ptmt.setInt(15,objD.getOt2Days());
        ptmt.setInt(16,objD.getOt3Days());
        ptmt.executeUpdate();
        objG.clossConnection(con);
        success = true;
      }
      catch (Exception ex) {
        ex.printStackTrace();
        success = false;
      }
      return success;
  }

//删除教训信息
  public boolean deleteCheckEmp_ID(int id) {
    DBGet objD = new DBGet();
    boolean success = false;
    Connection con= null;
    PreparedStatement ptmt = null;
    String strSQL = "delete from CheckIn where Emp_Id=?";
    try {
      con = objD.getConnection();
      ptmt = con.prepareStatement(strSQL);
      ptmt.setInt(1, id);
      ptmt.executeUpdate();
      ptmt.close();
      con.close();
      success = true;
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return success;
  }
}