resumes.java

图书

package thizlinux.linuxhr;

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

public class resumes {
	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();
	
	private Vector uidl1=new Vector();
	private Vector namel1=new Vector();
	private Vector genderl1=new Vector();
	private Vector workl1=new Vector();
	private Vector schooll1=new Vector();
	private Vector majorl1=new Vector();
	private Vector degreel1=new Vector();
	private Vector languagel1=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 Iterator getUidl1(){
		return uidl1.iterator();
	}
	public Iterator getNamel1(){
		return namel1.iterator();
	}
	public Iterator getGenderl1(){
		return genderl1.iterator();
	}
	public Iterator getWorkl1(){
		return workl1.iterator();
	}
	public Iterator getSchooll1(){
		return schooll1.iterator();
	}
	public Iterator getMajorl1(){
		return majorl1.iterator();
	}
	public Iterator getDegreel1(){
		return degreel1.iterator();
	}
	public Iterator getLanguagel1(){
		return languagel1.iterator();
	}


	public void refresh(){
		DBconnect dbconn =new DBconnect();
		uidl1.clear();
		namel1.clear();
		genderl1.clear();
		workl1.clear();
		schooll1.clear();
		majorl1.clear();
		degreel1.clear();
		languagel1.clear();
		ResultSet rs=null;
		String sql="";

		try{
			sql="select uid,name,gender,yearsofwork,school,major,degree,language from tbl_puserinfo where institute="+this.institute;
			rs=dbconn.executeQuery(sql);
			records=0;
			while(rs.next()){
				uidl1.add(pub.datachange(rs.getString("uid")));
				namel1.add(pub.datachange(rs.getString("name")));
				genderl1.add(pub.datachange(rs.getString("gender")));
				workl1.add(pub.datachange(rs.getString("yearsofwork")));
				schooll1.add(pub.datachange(rs.getString("school")));
				majorl1.add(pub.datachange(rs.getString("major")));
				degreel1.add(pub.datachange(rs.getString("degree")));
				languagel1.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);
			}
		}		
	}
}