occupation.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

/**
 * 职业
 */
package com.NCL;
import java.util.*;
import com.sinosoft.common.*;

public class Occupation {
	protected IndexMap propList;
	protected HashSet Property;
	private boolean EOF = false;
	private int COUNT;
	/**
	 * 构造函数
	 *
	 */
	public Occupation(){
		propList = new IndexMap();
		Property = new HashSet();
		Property.add("OCCUPATIONCODE");		//职业代码
		Property.add("OCCUPATIONNAME");		//职业名称
		Property.add("WORKNAME");			//所属部门
		Property.add("OCCUPATIONLEVEL");	//职业类别
	}
	/**
	 * 根据所属部门查询职业代码、职业名称、职业类别
	 * @param occuTypeName	所属部门
	 * @return	List
	 */
	public List findOccus(String occuTypeName){
		String SQL = "SELECT OCCUPATIONCODE,OCCUPATIONNAME,OCCUPATIONLEVEL from WORKCODE where WORKNAME=?";
		DBAccess d  = new DBAccess();
		List l = new ArrayList();
		l.add(occuTypeName);
		return d.mulparseSQL(SQL,l);	
	}
	/**
	 * 根据职业代码查询职业名称
	 * @param occuCode	职业代码
	 * @return String
	 */
	public String getNameByCode(String occuCode){
		String SQL = "SELECT OCCUPATIONNAME from WORKCODE where OCCUPATIONCODE=?";
		this.set("OCCUPATIONCODE",occuCode);		
		DBAccess d  = new DBAccess();
		return d.executeQuery(SQL,propList,0,1);	
	}
	/**
	 * 获取职业类别列表、职业名称
	 * @param operate	操作类型
	 * @return String
	 */
	public String getOccupationList(String operate){
		String result = "";		
		if(operate != null && !operate.equals("")){
			StringBuffer options = new StringBuffer("");
			String[] occuNames = {"机关团体、企事业单位","牧业","农业","渔业","林业","矿物、石油、天然气开采业","陆运业",
					"铁路、地铁运输业","航运业","空运业","餐旅业","建筑工程","铁路、地铁工程","造船业","装潢业","钢铁制造业",
					"电子业","电机业","塑胶橡胶制造业","水泥制造业（包括水泥、石膏、石灰、陶器）","化工业","炸药业","汽车、机车制造业与修理业","纺织业及成衣业","造纸业","家具、五金制造业",
					"手工艺品业","电线电缆业","食品饮料加工业","玻璃制造业","新闻广告业","医疗卫生业","娱乐业","文教、图书、出版业","宗教机构","邮政电信业","水利工程","瓦斯","一般商业",
					"金融服务业（银行、保险、信托、证券）","自由业","一般服务业","军警系统",
					"资讯业","职业运动","木材加工业","其他人员"};
			String[] occuNo = {"J001","M001","N001","Y005","L001","K002","L002","T002","H001","K001","C001","J004","T001","Z001","Z005","G001","D001","D002","S005","S004","H002",
					"Z003","Q001","F001","Z002","J003","S002","D003","S001","B001","X001","Y003","Y006","W001","Z007","Y004","S003","W002","Y002","J005","Z006","Y001","J006",
					"Z008","Z004","M002","Q002"};
			for(int i = 0; i < occuNames.length; i++){			
				options.append("<option value=" + occuNo[i] + ">" + occuNames[i] + "</option>\n");
			}
			if("List".equals(operate)){//获取职业类别列表
				result = options.toString();
			}else{//获取职业类别名称
				for(int i = 0; i < occuNo.length; i++){
					if(operate.equals(occuNo[i])){
						result = occuNames[i];
						break;
					}
				}
			}			
		}
		return result;
	}
	/**
	 * 获取民族列表、民族名称
	 * @param operate	操作类型
	 * @return	String
	 */
	public String getRace(String operate){
		String result = "";
		if(operate != null && !operate.equals("")){
			StringBuffer options = new StringBuffer("");
			String[] raceNames = {"汉族","满族","回族","藏族","维吾尔族","苗族","彝族","壮族","布依族","朝鲜族","蒙古族","侗族",
					"瑶族","白族","土家族","哈尼族","哈萨克族","傣族","黎族","傈僳族","佤族","畲族","高山族","拉祜族","东乡族","纳西族",
					"景颇族","柯尔克孜族","土族","仫佬族","羌族","布朗族","撒拉族","毛难族","仡佬族","阿昌族","普米族","塔吉克族","怒族",
					"乌孜别克族","鄂温克族","崩龙族","保安族","裕固族","京族","塔塔尔族","鄂伦春族","赫哲族","门巴族","珞巴族","基诺族",
					"其它族","入籍族"};
			String[] raceNo = {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20",
					"21","22","23","24","26","27","28","29","30","32","33","34","35","36","37","39","40","41","42","43",
					"45","46","47","48","49","50","52","53","54","55","56","57","58"};
			options.append("<option value=''>请选择</option>\n");
			for(int i = 0; i < raceNames.length; i++){			
				options.append("<option value=" + raceNo[i] + ">" + raceNames[i] + "</option>\n");
			}
			if("List".equals(operate))//获取民族列表
				result = options.toString();
			else{//获取民族名称
				for(int i = 0; i < raceNo.length; i++){
					if(operate.equals(raceNo[i])){
						result = raceNames[i];
						break;
					}
				}
			}
		}
		return result;
	}
	
	/**
	 * 在此映射中关联指定值与指定键
	 * @param name 指定键
	 * @param value 指定值
	 */
	public boolean set(String name, Object value){
		if(Property.contains(name)){
			propList.put(name,value);
			return true;
		}else
			return false;		
	}
	/**
	 * 返回指定键在此映射中所映射的值
	 * @param name 指定键
	 * @return
	 */
	public String get(String name){
		if (Property.contains(name)){
			String value = (String)propList.get(name);
			if(value != null && !value.equals(""))
				return value;
			else
				return "";
		}else 
			return "";
	}
	/**
	 * 返回COUNT
	 * @return int
	 */
	public int getCOUNT() {
		return COUNT;
	}
	/**
	 * 设置COUNT
	 * @param count
	 */
	public void setCOUNT(int count) {
		COUNT = count;
	}
	/**
	 * 返回EOF
	 * @return boolean
	 */
	public boolean isEOF() {
		return EOF;
	}
	/**
	 * 设置EOF
	 * @param eof
	 */
	public void setEOF(boolean eof) {
		EOF = eof;
	}
	/**
	 * 清空propList
	 *
	 */
	public void clear(){
		propList.clear();
	}
}