commoninfo.java

图书

package thizlinux.linuxhr;
import java.sql.*;
import java.util.*;
import java.io.*;

public class commoninfo {
	private ResultSet rs=null;
	private String sql="";
	private Vector health=new Vector();
	private Vector idtype=new Vector();
	private Vector gender=new Vector();
	private Vector nation=new Vector();
	private Vector industry=new Vector();
	private Vector typeofcompany=new Vector();
	private Vector language=new Vector();
	private Vector level=new Vector();
	private Vector institute=new Vector();
	private Vector instituteid=new Vector();
	private Vector martialstatus=new Vector();
	private Vector currency=new Vector();
	private Vector scale=new Vector();
	private Vector skill=new Vector();
	private Vector degree=new Vector();
	
	private String read="0";
	private String write="0";

	public Iterator getIdtype(){
		return idtype.iterator();
	}
	public Iterator getHealth(){
		return health.iterator();
	}
	public Iterator getGender(){
		return gender.iterator();
	}
	public Iterator getNation(){
		return nation.iterator();
	}
	public Iterator getIndustry(){
		return industry.iterator();
	}
	public Iterator getTypeofcompany(){
		return typeofcompany.iterator();
	}
	public Iterator getLanguage(){
		return language.iterator();
	}
public Iterator getLevel(){
		return level.iterator();
	}
	public Iterator getInstitute(){
		return institute.iterator();
	}
	public Iterator getInstituteid(){
		return instituteid.iterator();
	}
	public Iterator getMartialstatus(){
		return martialstatus.iterator();
	}
	public Iterator getCurrency(){
		return currency.iterator();
	}
	public void getScale(){
	}
	public Iterator getSkill(){
		return skill.iterator();
	}
	public Iterator getDegree(){
		return degree.iterator();
	}
	public commoninfo(){

		DBconnect dbconn =new DBconnect();		
		try{
			sql = "select name from tbl_health";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){          
				health.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_industry";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){          
					industry.add(pub.datachange(rs.getString("name")));
}

			sql = "select name from tbl_typeofcompany";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				typeofcompany.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_idtype";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				idtype.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_language";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				language.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_level";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				level.add(pub.datachange(rs.getString("name")));
			}

			sql = "select id,name from tbl_institute";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				instituteid.add(pub.datachange(rs.getString("id")));
				institute.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_gender";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				gender.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_nation";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				nation.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_martialstatus";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				martialstatus.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_currency";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				currency.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_scale";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){                    
				scale.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_skill";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){
				skill.add(pub.datachange(rs.getString("name")));
			}

			sql = "select name from tbl_degree";
			rs=dbconn.executeQuery(sql);
			while(rs.next()){
				degree.add(pub.datachange(rs.getString("name")));
			}
		}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);
			}
		}
	}
}