personpage.java

包括从业人员信息录入等功能

package person;
import java.sql.*;
import DB.*;
import java.util.*;
public class PersonPage {
    private Connection conn=null;  //连接
    private Statement stmt = null;
    String sqlstr="";
    private int rowCount=1;//总的记录
    private int pagesize=10;//每页记录数
    private int Showpage=1;//页码数
    private int pagecount=1;//总页数
    public PersonPage(int RecPerPage,String sqlstr) {
        OpenDB op= new OpenDB();
      if(op.openConnect()){
          conn = op.getConnection();
          try{
              stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
          }
          catch(Exception e){};
      }
        setrowCount(QryRcdCount(sqlstr));
        setpagesize(RecPerPage);
        int count = (rowCount % pagesize==0)?(rowCount/pagesize):(rowCount/pagesize+1);
        setpagecount(count);
    }
    public void setSqlstr(String sqlstr)
       {
          this.sqlstr=sqlstr;
      }
    //--------------------------------------------------------------------------
     public int QryRcdCount(String sqlstr){
     int rowcount=0;
     try{
     ResultSet rs = stmt.executeQuery(sqlstr);
     if(rs.next()){
     rs.last();
     rowcount =rs.getRow();
     } rs.close();
     }catch(Exception e){}
     return rowcount;
     }

     /*---------------------------------查询方法------------------------------------*/
    public List QryAll(int CurrentPage, String SqlStr){
        SqlStr="select * from ( select rownum as my_rownum,table_a.* from (" + SqlStr +") table_a ";
                 SqlStr=SqlStr+       " where rownum    <="+ String.valueOf(CurrentPage*pagesize)+") ";
                 SqlStr=SqlStr+ "where my_rownum > "+String.valueOf((CurrentPage-1)*pagesize);
                 List records=new ArrayList();
                 try{
                     ResultSet rs=stmt.executeQuery(SqlStr);
                     if(rs.next()){
                         rs.previous();
                         while (rs.next()) {
                             PersonBean pb = new PersonBean();
                             String PERSONID = rs.getString("PERSONID");
                             if ((PERSONID != null) && (!PERSONID.equals("")))
                                 pb.setPERSONID(PERSONID);

                             String FUNSERVERID = rs.getString("FUNSERVERID");
                             if ((FUNSERVERID != null) &&
                                 (!FUNSERVERID.equals("")))
                                 pb.setFUNSERVERID(FUNSERVERID);

                             String IDCARD = rs.getString("IDCARD");
                             if ((IDCARD != null) && (!IDCARD.equals("")))
                                 pb.setIDCARD(IDCARD);
//System.out.print(pb.getIDCARD());
                             String PERSONNELNAME = rs.getString(
                                     "PERSONNELNAME");
                             if ((PERSONNELNAME != null) &&
                                 (!PERSONNELNAME.equals("")))
                                 pb.setPERSONNELNAME(PERSONNELNAME);

                             String ZANZHUID = rs.getString("ZANZHUID");
                             if ((ZANZHUID != null) && (!ZANZHUID.equals("")))
                                 pb.setZANZHUID(ZANZHUID);

                             String PHONE = rs.getString("PHONE");
                             if ((PHONE != null) && (!PHONE.equals("")))
                                 pb.setPHONE(PHONE);

                             String SEX = rs.getString("SEX");
                             if ((SEX != null) && (!SEX.equals("")))
                                 pb.setSEX(SEX);
//System.out.print(pb.getSEX());
                             String NATIVEPLACE = rs.getString("NATIVEPLACE");
                             if ((NATIVEPLACE != null) &&
                                 (!NATIVEPLACE.equals("")))
                                 pb.setNATIVEPLACE(NATIVEPLACE);

                             String NATION = rs.getString("NATION");
                             if ((NATION != null) && (!NATION.equals("")))
                                 pb.setNATION(NATION);

                             String WORKINGTYPE = rs.getString("WORKINGTYPE");
                             if ((WORKINGTYPE != null) &&
                                 (!WORKINGTYPE.equals("")))
                                 pb.setWORKINGTYPE(WORKINGTYPE);

                             String PERSONNELLEVEL = rs.getString(
                                     "PERSONNELLEVEL");
                             if ((PERSONNELLEVEL != null) &&
                                 (!PERSONNELLEVEL.equals("")))
                                 pb.setPERSONNELLEVEL(PERSONNELLEVEL);

                             String SUBAREA = rs.getString("SUBAREA");
                             if ((SUBAREA != null) && (!SUBAREA.equals("")))
                                 pb.setSUBAREA(SUBAREA);

                             String REGISTERTIME = rs.getString("REGISTERTIME");
                             if ((REGISTERTIME != null) &&
                                 (!REGISTERTIME.equals("")))
                                 pb.setREGISTERTIME(REGISTERTIME);

                             String STATUS = rs.getString("STATUS");
                             if ((STATUS != null) && (!STATUS.equals("")))
                                 pb.setSTATUS(STATUS);

                             String OPDATE = rs.getString("OPDATE");
                             if ((OPDATE != null) && (!OPDATE.equals("")))
                                 pb.setOPDATE(OPDATE);

                             String PTYPE = rs.getString("PTYPE");
                             if ((PTYPE != null) && (!PTYPE.equals("")))
                                 pb.setPTYPE(PTYPE);

                             String HOME = rs.getString("HOME");
                             if ((HOME != null) && (!HOME.equals("")))
                                 pb.setHOME(HOME);

                             String NOWPLACE = rs.getString("NOWPLACE");
                             if ((NOWPLACE != null) && (!NOWPLACE.equals("")))
                                 pb.setNOWPLACE(NOWPLACE);

                             records.add(pb);
                         }
                     }
                 }catch(Exception e){System.out.print(e);}
                 return records;
    }
//----------------------------------------------------------------------------
     private void setrowCount(int n){
     this.rowCount=n;
     }
     public void setpagesize(int n){
       this.pagesize=n;
     }
     public void setShowpage(int n){
          this.Showpage=n;
     }
     public void setpagecount(int n){
             this.pagecount=n;
     }

     public String getSqlStr(){
             return sqlstr;
          }
     public int getrowCount(){return pagecount;}
     public int getpagesize(){return pagesize;}
     public int getShowpage(){return Showpage;}
     public int getpagecount(){return pagecount;}
//----------------------------
}