personbean.java

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

				}

				if(value==null)value="";
				hash.put(field,value);
			}
			vect.add(hash);
		}
		}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 vect;
	}
	//取得当前人员的信息
	public Hashtable getOneData()
	{
		Hashtable hash = new Hashtable();
		String sql = "";

		sql = " select * from ZZ_ZGB where ZGBH = '"+strPersonNO+"'";

		ResultSet rs = selectRecord(sql);
		Statement stmt = null;
		try{
		ResultSetMetaData rsmd = rs.getMetaData();
		int cols = rsmd.getColumnCount();
		if (rs.next())
		{
			String bmmc="";
			for(int i=1;i<=cols;i++)
			{
				String field = ds.toString(rsmd.getColumnName(i));
				String value = ds.toString(rs.getString(i));
				if(field.equals("BMBH"))
				{
					setOrgNO(value);
					bmmc = getBmName();
				}
				if(field.equals("ZZZT"))
				{
					if(value.equals("0"))value="正常";
					if(value.equals("1"))value="离职";
					if(value.equals("2"))value="退休";
					if(value.equals("3"))value="挂起";
				}
				if(value==null)value="";
				hash.put(field,value);
			}
			hash.put("BMMC",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 hash;
	}
	public String getApartName(String bmno)//取得某部门的部门名称
	{
		String sql = "";
		String name = "";
		sql = " select BMMC from ZZ_BMB where BMBH = '"+bmno+"'";
		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 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 strCZQX = ds.toString((String)hash.get("CZQX"));
//		String strLCQX = ds.toString((String)hash.get("LCQX"));
		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 strDJGL = ds.toString((String)hash.get("DJGL"));
//		String strFBWZ = ds.toString((String)hash.get("FBWZ"));
//		String strGLYH = ds.toString((String)hash.get("GLYH"));
		String strGRJJ = ds.toString((String)hash.get("GRJJ"));
		String strZNYH = ds.toString((String)hash.get("ZNYH"));

		/*sql = "select * from ZZ_ZGB";
		ResultSet rs = selectRecord(sql);
		while (rs.next())
		{
			intPerson++;
		}
		intPerson++;
		strZGBH = String.valueOf(intPerson);*/

		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("CZQX",strCZQX,"CHAR"));
//		vect.add(addVector("LCQX",strLCQX,"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("DJGL",strDJGL,"CHAR"));
//		vect.add(addVector("FBWZ",strFBWZ,"NUM"));
//		vect.add(addVector("GLYH",strGLYH,"NUM"));
		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 strBMBH = ds.toString((String)hash.get("BMBH"));
		String strXM = ds.toString((String)hash.get("XM"));
		String strGH = ds.toString((String)hash.get("GH"));
//		String strCZQX = ds.toString((String)hash.get("CZQX"));
//		String strLCQX = ds.toString((String)hash.get("LCQX"));
		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 strDJGL = ds.toString((String)hash.get("DJGL"));
//		String strFBWZ = ds.toString((String)hash.get("FBWZ"));
//		String strGLYH = ds.toString((String)hash.get("GLYH"));
		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;