eresumelist.java

来自「图书」· Java 代码 · 共 120 行

package thizlinux.linuxhr;

import java.sql.*;
import java.text.*;
import java.util.*;

public class eresumelist {
	private String uid="";
	private String pages="";
	private int institute=0;
	private int lines=20;
	private int records=0;


	private boolean status=false;
	private Vector uidl=new Vector();
	private Vector namel=new Vector();
	private Vector genderl=new Vector();
	private Vector workl=new Vector();
	private Vector schooll=new Vector();
	private Vector majorl=new Vector();
	private Vector degreel=new Vector();
	private Vector languagel=new Vector();
	

	public String getPages(){
		if(((float)records/lines)>((int)records/lines)){
			pages=""+(int)(records/lines+1);
		}else{
			pages=""+(int)records/lines;
		}
		return this.pages;
	}	
	public void setInstitute(int value){
		this.institute=value;
		}
	public int getInstitute(){
		return this.institute;
	}	
	public void setLines(int value){
		this.lines=value;
		}
	public int getLines(){
		return this.lines;
	}	
	public void setUid(String value){
		this.uid=value;
		}
	public String getUid(){
		return this.uid;
	}	

	public Iterator getUidl(){
		return uidl.iterator();
	}
	public Iterator getNamel(){
		return namel.iterator();
	}
	public Iterator getGenderl(){
		return genderl.iterator();
	}
	public Iterator getWorkl(){
		return workl.iterator();
	}
	public Iterator getSchooll(){
		return schooll.iterator();
	}
	public Iterator getMajorl(){
		return majorl.iterator();
	}
	public Iterator getDegreel(){
		return degreel.iterator();
	}
	public Iterator getLanguagel(){
		return languagel.iterator();
	}

	
	public void refreshlist(){
		if(status)return;
		DBconnect dbconn =new DBconnect();
		uidl.clear();
		namel.clear();
		genderl.clear();
		workl.clear();
		schooll.clear();
		majorl.clear();
		degreel.clear();
		languagel.clear();
		ResultSet rs=null;
		String sql="";
		try{
			sql="select uid,name,gender,yearsofwork,school,major,degree,language from tbl_puserinfo";
			rs=dbconn.executeQuery(sql);
			records=0;
			while(rs.next()){
				uidl.add(pub.datachange(rs.getString("uid")));
				namel.add(pub.datachange(rs.getString("name")));
				genderl.add(pub.datachange(rs.getString("gender")));
				workl.add(pub.datachange(rs.getString("yearsofwork")));
				schooll.add(pub.datachange(rs.getString("school")));
				majorl.add(pub.datachange(rs.getString("major")));
				degreel.add(pub.datachange(rs.getString("degree")));
				languagel.add(pub.datachange(rs.getString("language")));
				records=records+1;
			}  
			status=true;
		}catch(Exception e){
			System.out.println(e+",sql="+sql);
		}finally{
			try{
				if(rs!=null)rs.close();
				if(dbconn!=null)dbconn.close();
			}catch(Exception e){
				System.out.println(e);
			}
		}		
	}
}