personbean.java

本书主要介绍了从基础开始建立Portal的快速应用开发过程（RAD）的方法。通过本书你可以了解到关于Oracle 9iAS Portal产品的主要特性、入口的开发和组织、网络开发和管理、实际的关系型数

		}
		return name;
	}

	public String getPsBmName()//取得当前人员的部门名称
	{
		
		return toName("zz_bmb","BMBH","BMMC",toName("zz_zgb","ZGBH","BMBH",strPersonNO));
	}

	public String getZgName(String str)//取得某人员的名字
	{
		return toName("ZZ_ZGB","ZGBH","XM",str);
	}

	public String getBmName()//取得当前部门的部门名称
	{
		String sql = "";
		String name = "";
		sql = " select BMMC from ZZ_BMB where BMBH = '"+strOrgNO+"'";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(rs.next())
			name = ds.toString(rs.getString("BMMC"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return name;
	}

	public String getBgColor()//取得需要必填项目之背景色  new  chen
    {
		String sql = "";
		String color = "#ffffff";
		sql = " select xmmc from CODE_ZDB where ZDMC ='表单元素背景色' and xmbh='1' and syzt=0";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		if(rs.next())
				color = ds.toString(rs.getString("xmmc"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return color;
	}

	public String getMaxzgNo()//取得最大职工编号+1
	{
		String sql = "",zgNo="";
		long lzgNo=0,lmaxNo = 0;
		sql = " select ZGBH from ZZ_ZGB ";//where BMBH = '"+strOrgNO+"'"
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		while(rs.next())
		{
			zgNo = ds.toString(rs.getString("ZGBH"));
			lzgNo = Long.parseLong(zgNo);
			if (lzgNo > lmaxNo) {
				lmaxNo = lzgNo;
				//maxNo = zgNo;
			}
		}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		lmaxNo = lmaxNo + 1;
		return String.valueOf(lmaxNo);
	}
	public Vector getMZ()//从字典表取得民族
	{
		String sql = "";
		sql = "select XMMC from CODE_ZDB where ZDMC='民族' and SYZT=0 order by jbxh";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		Vector vt = new Vector();
		try{
			while(rs.next())
				vt.add(ds.toString(rs.getString("XMMC")));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vt;
	}

	public Vector getZzmm()//从字典表取得政治面目
	{
		String sql = "";
		sql = "select XMMC from CODE_ZDB where ZDMC='政治面貌' and SYZT=0 order by jbxh";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		Vector vt = new Vector();
		try{
			while(rs.next())
				vt.add(ds.toString(rs.getString("XMMC")));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vt;
	}
	public Vector getXL()//从字典表取得学历
	{
		String sql = "";
		sql = "select XMMC from CODE_ZDB where ZDMC='学历' and SYZT=0 order by jbxh";
		ResultSet rs = selectRecord(sql);
		Vector vt = new Vector();
		Statement stmt = null;
		try{
			while(rs.next())
				vt.add(ds.toString(rs.getString("XMMC")));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vt;
	}
	public Vector getZC()//从字典表取得职称
	{
		String sql = "";
		sql = "select XMMC from CODE_ZDB where ZDMC='职称' and SYZT=0 order by jbxh";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		Vector vt = new Vector();
		try{
			while(rs.next())
				vt.add(ds.toString(rs.getString("XMMC")));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return vt;
	}
	//增加人员数据记录
	public int addPerson(Hashtable hash)
	{
		String sql="";
		long intPerson = 0;
		String strBMBH = ds.toString((String)hash.get("BMBH"));
		String strZGBH = ds.toString((String)hash.get("ZGBH"));
		String strXM = ds.toString((String)hash.get("XM"));

		String strGH = ds.toString((String)hash.get("GH"));

		String strPZCS = ds.toString((String)hash.get("PZCS"));
		String strMMWT = ds.toString((String)hash.get("MMWT"));
		String strMMDA = ds.toString((String)hash.get("MMDA"));
		String strMM = ds.toString((String)hash.get("MM"));
		strMM =(new MD5()).toMD5(strMM);
		String strXB = ds.toString((String)hash.get("XB"));
		String strCSNY = ds.toString((String)hash.get("CSNY"));
		String strMZ = ds.toString((String)hash.get("MZ"));
		String strZZMM = ds.toString((String)hash.get("ZZMM"));
		String strXL = ds.toString((String)hash.get("XL"));
		String strZC = ds.toString((String)hash.get("ZC"));
		String strQQ = ds.toString((String)hash.get("QQ"));
		String strBGDH = ds.toString((String)hash.get("BGDH"));
		String strFJDH = ds.toString((String)hash.get("FJDH"));
		String strYZBM = ds.toString((String)hash.get("YZBM"));
		String strJTDZ = ds.toString((String)hash.get("JTDZ"));
		String strJTDH = ds.toString((String)hash.get("JTDH"));
		String strYDDH = ds.toString((String)hash.get("YDDH"));
		String stremail = ds.toString((String)hash.get("EMAIL"));
		String strZZZT = ds.toString((String)hash.get("ZZZT"));
		String strYHM = ds.toString((String)hash.get("YHM"));
		String strZCRQ = ds.toString((String)hash.get("ZCRQ"));
		String strGRJJ = ds.toString((String)hash.get("GRJJ"));
		String strZNYH = ds.toString((String)hash.get("ZNYH"));

		Vector vect = new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("BMBH",strBMBH,"CHAR"));
		vect.add(addVector("ZGBH",strZGBH,"CHAR"));
		vect.add(addVector("XM",strXM,"CHAR"));
		vect.add(addVector("GH",strGH,"CHAR"));
		vect.add(addVector("PZCS",strPZCS,"CHAR"));
		vect.add(addVector("MMWT",strMMWT,"CHAR"));
		vect.add(addVector("MMDA",strMMDA,"CHAR"));
		vect.add(addVector("MM",strMM,"CHAR"));
		vect.add(addVector("XB",strXB,"CHAR"));
		vect.add(addVector("CSNY",strCSNY,"CHAR"));
		vect.add(addVector("MZ",strMZ,"CHAR"));
		vect.add(addVector("ZZMM",strZZMM,"CHAR"));
		vect.add(addVector("XL",strXL,"CHAR"));
		vect.add(addVector("ZC",strZC,"CHAR"));
		vect.add(addVector("QQ",strQQ,"CHAR"));
		vect.add(addVector("BGDH",strBGDH,"CHAR"));
		vect.add(addVector("FJDH",strFJDH,"CHAR"));
		vect.add(addVector("YZBM",strYZBM,"CHAR"));
		vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
		vect.add(addVector("JTDH",strJTDH,"CHAR"));
		vect.add(addVector("YDDH",strYDDH,"CHAR"));
		vect.add(addVector("EMAIL",stremail,"CHAR"));
		vect.add(addVector("ZZZT",strZZZT,"NUM"));

		vect.add(addVector("YHM",strYHM,"CHAR"));
		vect.add(addVector("ZCRQ",strZCRQ,"CHAR"));
		vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
		vect.add(addVector("ZNYH",strZNYH,"NUM"));
		
		int jbxh=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strBMBH,"0",false,true);
		String jbNo=""+jbxh;
		vect.add(addVector("JBXH",jbNo,"NUM"));

        //检验工号是否已经存在
		sql = "select GH from ZZ_ZGB where GH='"+strGH+"' and ZZZT=0";
		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
			if(rs.next())
				return 5;
			else  //检验用户名是否已经存在
			{
				sql = "select YHM from ZZ_ZGB where YHM='"+ strYHM + "'";// and ZZZT=0";  
				stmt = rs.getStatement(); rs.close();	stmt.close();
				rs = selectRecord(sql);
				if(rs.next())
					return 6;
			}		
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		return insertRecord(vect);
	}

	//修改人员数据记录
	public int modPerson(Hashtable hash)
	{
		String strXM = ds.toString((String)hash.get("XM"));
		String strGH = ds.toString((String)hash.get("GH"));
		String strPZCS = ds.toString((String)hash.get("PZCS"));
		String strMMWT = ds.toString((String)hash.get("MMWT"));
		String strMMDA = ds.toString((String)hash.get("MMDA"));
		String strMM = ds.toString((String)hash.get("MM"));
		String strXB = ds.toString((String)hash.get("XB"));
		String strCSNY = ds.toString((String)hash.get("CSNY"));
		String strMZ = ds.toString((String)hash.get("MZ"));
		String strZZMM = ds.toString((String)hash.get("ZZMM"));
		String strXL = ds.toString((String)hash.get("XL"));
		String strZC = ds.toString((String)hash.get("ZC"));
		String strQQ = ds.toString((String)hash.get("QQ"));
		String strBGDH = ds.toString((String)hash.get("BGDH"));
		String strFJDH = ds.toString((String)hash.get("FJDH"));
		String strYZBM = ds.toString((String)hash.get("YZBM"));
		String strJTDZ = ds.toString((String)hash.get("JTDZ"));
		String strJTDH = ds.toString((String)hash.get("JTDH"));
		String strYDDH = ds.toString((String)hash.get("YDDH"));
		String stremail = ds.toString((String)hash.get("EMAIL"));
		String strZZZT = ds.toString((String)hash.get("ZZZT"));
		String strYHM = ds.toString((String)hash.get("YHM"));
		String strZCRQ = ds.toString((String)hash.get("ZCRQ"));
		String strGRJJ = ds.toString((String)hash.get("GRJJ"));
		String strJBXH = ds.toString((String)hash.get("JBXH"));
		String strZNYH = ds.toString((String)hash.get("ZNYH"));
		String strBMNO=getBMBH();
		ResultSet rs1 = selectRecord(
			"select JBXH from ZZ_ZGB where BMBH='"	+ strBMNO +"' and ZGBH='"
					+ strPersonNO + "' and ZZZT=0 and ZGBH <> '1'");
		int yjbxh=999;
		Statement stmt = null;
		try{
			if(rs1.next())
				yjbxh=Integer.parseInt(rs1.getString("JBXH"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		int jbxh=0;
		int maxjbNo=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strBMNO,"0",false,true);
		if(!strJBXH.equals(""))
			jbxh=Integer.parseInt(strJBXH);
		if(strPersonNO.equals("1")) {//系统管理员,令其级别序号总为0
			jbxh=0;strJBXH=""+jbxh;
		}
		else if(strBMNO.equals(ds.toString(strOrgNO)))//部门未改变,更新级别序号
		{
			if(jbxh==0||jbxh>=maxjbNo)
				{ jbxh=maxjbNo-1;strJBXH=""+jbxh;}
			if(jbxh < yjbxh){
				String sql1="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"
							+ strOrgNO	
							+ "' and ZZZT=0 and JBXH >=" 
							+ jbxh
							+ "  and  JBXH<"
							+ yjbxh;
				deleteRecord(sql1);
			}
			else if(jbxh > yjbxh && yjbxh!=0){
				String sql2="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
							+ strOrgNO	
							+ "' and ZZZT=0 and JBXH <=" 
							+ jbxh
							+ "  and  JBXH>"
							+ yjbxh;
				deleteRecord(sql2);
			}
		}
		else//部门发生改变,更新级别序号
		{///修改原部门内人员级别序号
			String sql3="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"
						+ strBMNO	
						+ "' and ZZZT=0 and JBXH >" 
						+ yjbxh;
			deleteRecord(sql3);
			////修改新部门内人员级别序号
			maxjbNo=makeID("ZZ_ZGB","BMBH","ZZZT","JBXH",strOrgNO,"0",false,true);
			if(!strJBXH.equals(""))
				jbxh=Integer.parseInt(strJBXH);
			if(jbxh==0||jbxh>maxjbNo)
				{ jbxh=maxjbNo;strJBXH=""+jbxh;}
			String sql4="update ZZ_ZGB set JBXH=JBXH+1 where BMBH='"+ strOrgNO + "' and ZZZT=0 and JBXH >=" + jbxh ;
			deleteRecord(sql4);
		}
		Vector vect = new Vector();
		vect.add("ZZ_ZGB");
		vect.add(addVector("BMBH",strOrgNO,"CHAR"));
		vect.add(addVector("XM",strXM,"CHAR"));
		vect.add(addVector("GH",strGH,"CHAR"));
		vect.add(addVector("PZCS",strPZCS,"CHAR"));
		vect.add(addVector("MMWT",strMMWT,"CHAR"));
		vect.add(addVector("MMDA",strMMDA,"CHAR"));
		if(strMM!=null && !strMM.equals(""))
		{
			strMM = (new MD5()).toMD5(strMM);
			vect.add(addVector("MM",strMM,"CHAR"));
		}
		vect.add(addVector("XB",strXB,"CHAR"));
		vect.add(addVector("CSNY",strCSNY,"CHAR"));
		vect.add(addVector("MZ",strMZ,"CHAR"));
		vect.add(addVector("ZZMM",strZZMM,"CHAR"));
		vect.add(addVector("XL",strXL,"CHAR"));
		vect.add(addVector("ZC",strZC,"CHAR"));
		vect.add(addVector("QQ",strQQ,"CHAR"));
		vect.add(addVector("BGDH",strBGDH,"CHAR"));
		vect.add(addVector("FJDH",strFJDH,"CHAR"));
		vect.add(addVector("YZBM",strYZBM,"CHAR"));
		vect.add(addVector("JTDZ",strJTDZ,"CHAR"));
		vect.add(addVector("JTDH",strJTDH,"CHAR"));
		vect.add(addVector("YDDH",strYDDH,"CHAR"));
		vect.add(addVector("EMAIL",stremail,"CHAR"));
		vect.add(addVector("ZZZT",strZZZT,"NUM"));
		vect.add(addVector("YHM",strYHM,"CHAR"));
		vect.add(addVector("ZCRQ",strZCRQ,"CHAR"));
		vect.add(addVector("GRJJ",strGRJJ,"CHAR"));
		vect.add(addVector("JBXH",strJBXH,"NUM"));
		vect.add(addVector("ZNYH",strZNYH,"NUM"));
		vect.add("ZGBH = "+strPersonNO+"");

		//检验工号是否已经存在
		String sql = "select GH from ZZ_ZGB where GH='"+ strGH + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
		ResultSet rs =selectRecord(sql);
		try{
			if (rs.next())
				return 5;
			else  //检验用户名是否已经存在
			{
				stmt = rs.getStatement();rs.close();stmt.close();
				sql = "select YHM from ZZ_ZGB where YHM='"+ strYHM + "' and ZZZT=0 and ZGBH<>'"+ strPersonNO +"'";
				rs = selectRecord(sql);
				if(rs.next())
					return 6;
			}
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		updateRecord(vect);
		return 0;
	}

	//删除当前人员数据记录
	public int delPerson()
	{
		String sql=""; 
		ResultSet rst = selectRecord("select JBXH from ZZ_ZGB where ZGBH='"	
			+ strPersonNO + "' and ZZZT=0");
		Statement stmt = null;
		int yjbxh=999;
		try{
			if(rst.next())
				yjbxh=Integer.parseInt(rst.getString("JBXH"));
		}catch(Exception e){System.out.println("运行时出错："+e);}
		finally{
			if(rst!=null)try{ stmt = rst.getStatement(); rst.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}		
		}
		sql="update ZZ_ZGB set JBXH=JBXH-1 where BMBH='"