checkoperate.java~2~

来自「java+sql2000企业人力管理系统」· JAVA~2~ 代码 · 共 50 行

package managersystem.Check;

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

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;

  }
}