orgservlet.java

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

				String sfjc		 = ds.toGBK(request.getParameter("txt_sfjc")); //是否继承
				//zwczRight = dutybn.toOperNo(zwczRight);
				zwlcRight = dutybn.toFlowNo(zwlcRight);
				//zwpzPara = dutybn.toConfNo(zwpzPara);
				if(zwStatus.equals("正常"))
					zwStatus = "0";
				if(zwStatus.equals("挂起"))
					zwStatus = "1";
				if(sfjc.equals("不可继承"))
					sfjc = "1";
				else
					sfjc = "0";

				if(zwczRight == null) zwczRight = "";
				if(zwlcRight == null) zwlcRight = "";
				if(zwpzPara  == null) zwpzPara = "";
				if(jbNo		 == null) jbNo = "";

				Hashtable ht = new Hashtable();
				//ht.put("BMBH",bmNo);
				ht.put("ZWMC",zwName);
				ht.put("CZQX",zwczRight);
				ht.put("LCQX",zwlcRight);
				ht.put("PZCS",zwpzPara);

				if(jbNo.equals("") || jbNo==null)
				{
					jbNo = dutybn.getJBNo();//dbean
				}
				ht.put("JBXH",jbNo);
				ht.put("ZWZT",zwStatus);
				ht.put("SFJC",sfjc);
				errcode = dutybn.modDuty(ht);
				response.sendRedirect("oa/organization/index.jsp?txt_type=2&txt_orgno="+strOrgNO+"&errcode="+errcode);
			}

//...........................可添加其他页面操作....................................//
//新增人员信息
			if(strType!=null && strType.equals("3") && strEdit.equals("1") && strPage.equals("1"))
			{
				//psbean.setOrgNO(strOrgNO);
				String bmNo = strOrgNO;
				String zzZt = "0";
				String zgNo = psbean.getMaxzgNo();
				String zgName = ds.toGBK(request.getParameter("txt_xm"));
				String zgGH = ds.toGBK(request.getParameter("txt_gh"));
				String psWord = ds.toGBK(request.getParameter("password_check"));
				String pswQuestion = ds.toGBK(request.getParameter("txt_mmwt"));
				String pswKey = ds.toGBK(request.getParameter("txt_mmda"));
				String Sex = ds.toGBK(request.getParameter("txt_xb"));
				String birthDay = ds.toGBK(request.getParameter("txt_csny"));
				String mz = ds.toGBK(request.getParameter("txt_mz"));
				String zzmm = ds.toGBK(request.getParameter("txt_zzmm"));
				String xli = ds.toGBK(request.getParameter("txt_xl"));
				String zhich = ds.toGBK(request.getParameter("txt_zc"));
				String bgphone = ds.toGBK(request.getParameter("txt_bgdh"));
				String fjphone = ds.toGBK(request.getParameter("txt_fjdh"));
				String jtphone = ds.toGBK(request.getParameter("txt_jtdh"));
				String mobile = ds.toGBK(request.getParameter("txt_mobile"));
				String address = ds.toGBK(request.getParameter("txt_address"));
				String code = ds.toGBK(request.getParameter("txt_yzbm"));
				String qqNo = ds.toGBK(request.getParameter("txt_qq"));
				String email = ds.toGBK(request.getParameter("txt_email"));
				String username = ds.toGBK(request.getParameter("txt_username")).toLowerCase();
				String regdate = ds.toGBK(request.getParameter("txt_regdate"));
				String grjj = ds.toGBK(request.getParameter("txt_grjj"));
				String confPara = ds.toString(request.getParameter("txt_confpara"));

				String znyh = ds.toString(request.getParameter("txt_znyh"));


				if(confPara == null) confPara = "";

				Hashtable ht = new Hashtable();
				ht.put("BMBH",bmNo);
				ht.put("ZGBH",zgNo);
				ht.put("XM",zgName);
				ht.put("GH",zgGH);
				ht.put("PZCS",confPara);
				ht.put("MMWT",pswQuestion);
				ht.put("MMDA",pswKey);
				ht.put("MM",psWord);
				ht.put("XB",Sex);
				ht.put("CSNY",birthDay);
				ht.put("MZ",mz);
				ht.put("ZZMM",zzmm);
				ht.put("XL",xli);
				ht.put("ZC",zhich);
				ht.put("QQ",qqNo);
				ht.put("BGDH",bgphone);
				ht.put("FJDH",fjphone);
				ht.put("YZBM",code);
				ht.put("JTDZ",address);
				ht.put("JTDH",jtphone);
				ht.put("YDDH",mobile);
				ht.put("EMAIL",email);
				ht.put("ZZZT",zzZt);
				ht.put("YHM",username);
				ht.put("ZCRQ",regdate);
			//	ht.put("DJGL",);
//				ht.put("FBWZ","0");
//				ht.put("GLYH","1");
				ht.put("GRJJ",grjj);
				ht.put("ZNYH",znyh);

				errcode = psbean.addPerson(ht);
/*				//给新增人员分配职务
				String bmNo = ds.toGBK(request.getParameter("hid_dutybmno"));
				String zwname = ds.toGBK(request.getParameter("txt_dutyName"));
				if(!bmNo.equals("") && !zwname.equals(""))
				{
					psdbn.setDutyOrgNo(bmNo);
					String zwno = psdbn.getDutyNo(zwname);
					psdbn.addRec(zgNo,bmNo,zwno);
				}//返回到查看某部门人员列表的界面
*/

				//给新增人员分配一般员工的职务
				String zwNo = dutybn.getOrdinaryZWBH(bmNo,"一般员工");
				if(zwNo.equals("")){
					Hashtable dutyhash = new Hashtable();
					dutyhash.put("BMBH",bmNo);
					dutyhash.put("ZWMC","一般员工");
					dutyhash.put("CZQX","");
					dutyhash.put("LCQX","");
					dutyhash.put("PZCS","");
					dutyhash.put("JBXH","");
					dutyhash.put("ZWZT","0");
					dutybn.addDuty(dutyhash);
					zwNo = dutybn.getOrdinaryZWBH(bmNo,"一般员工");
				}
				psdbn.addRec(zgNo,bmNo,zwNo,"","");//addRec(String personno,String dutyOrgno,String dutyno,String czqx,String lcqx)
				response.sendRedirect("oa/organization/index.jsp?txt_type=3&txt_edit="+strEdit+"&txt_page=2&txt_personno="+zgNo+"&txt_orgno="+strOrgNO+"&errcode="+errcode);
			}
//修改人员信息
			if(strType!=null && strType.equals("3") && strEdit.equals("2"))
			{
				strOrgNO=ds.toString((String)request.getParameter("txt_bmno"));
				psbean.setOrgNO(strOrgNO);
				psbean.setPersonNO(strPersonNO);
				//String bmNo = strOrgNO;
				String zzZt = ds.toGBK(request.getParameter("txt_zzzt"));
				if(zzZt.equals("正常"))zzZt = "0";
				if(zzZt.equals("离职"))zzZt = "1";
				if(zzZt.equals("退休"))zzZt = "2";
				if(zzZt.equals("挂起"))zzZt = "3";
				//String zgNo = strPersonNO;
				String zgName = ds.toGBK(request.getParameter("txt_xm"));
				String zgGH = ds.toGBK(request.getParameter("txt_gh"));
				String psWord = ds.toGBK(request.getParameter("password_check"));
				String pswQuestion = ds.toGBK(request.getParameter("txt_mmwt"));
				String pswKey = ds.toGBK(request.getParameter("txt_mmda"));
				String Sex = ds.toGBK(request.getParameter("txt_xb"));
				String birthDay = ds.toGBK(request.getParameter("txt_csny"));
				String mz = ds.toGBK(request.getParameter("txt_mz"));
				String zzmm = ds.toGBK(request.getParameter("txt_zzmm"));
				String xli = ds.toGBK(request.getParameter("txt_xl"));
				String zhich = ds.toGBK(request.getParameter("txt_zc"));
				String bgphone = ds.toGBK(request.getParameter("txt_bgdh"));
				String fjphone = ds.toGBK(request.getParameter("txt_fjdh"));
				String jtphone = ds.toGBK(request.getParameter("txt_jtdh"));
				String mobile = ds.toGBK(request.getParameter("txt_mobile"));
				String address = ds.toGBK(request.getParameter("txt_address"));
				String code = ds.toGBK(request.getParameter("txt_yzbm"));
				String qqNo = ds.toGBK(request.getParameter("txt_qq"));
				String email = ds.toGBK(request.getParameter("txt_email"));
				String username = ds.toGBK(request.getParameter("txt_username")).toLowerCase();
				String regdate = ds.toGBK(request.getParameter("txt_regdate"));
				String grjj = ds.toGBK(request.getParameter("txt_grjj"));
				String jbxh = ds.toGBK(request.getParameter("txt_jbxh"));
				String znyh = ds.toGBK(request.getParameter("txt_znyh"));


//				String czqx = ds.toGBK(request.getParameter("txt_doright"));
//				czqx = psbean.toOperNo(czqx);
//				String lcqx = ds.toGBK(request.getParameter("txt_roadright"));
//				lcqx = psbean.toFlowNo(lcqx);

				String confPara = ds.toGBK(request.getParameter("txt_confpara"));

				if(confPara == null) confPara = "";

				Hashtable ht = new Hashtable();
				//ht.put("BMBH",bmNo);
				//ht.put("ZGBH",zgNo);
				ht.put("XM",zgName);
				ht.put("GH",zgGH);
//				ht.put("CZQX",czqx);
//				ht.put("LCQX",lcqx);
				ht.put("PZCS",confPara);
				ht.put("MMWT",pswQuestion);
				ht.put("MMDA",pswKey);
				ht.put("MM",psWord);
				ht.put("XB",Sex);
				ht.put("CSNY",birthDay);
				ht.put("MZ",mz);
				ht.put("ZZMM",zzmm);
				ht.put("XL",xli);
				ht.put("ZC",zhich);
				ht.put("QQ",qqNo);
				ht.put("BGDH",bgphone);
				ht.put("FJDH",fjphone);
				ht.put("YZBM",code);
				ht.put("JTDZ",address);
				ht.put("JTDH",jtphone);
				ht.put("YDDH",mobile);
				ht.put("EMAIL",email);
				ht.put("ZZZT",zzZt);
				ht.put("YHM",username);
				ht.put("ZCRQ",regdate);
			//	ht.put("DJGL",);
//				ht.put("FBWZ","0");
//				ht.put("GLYH","1");
				ht.put("GRJJ",grjj);
				ht.put("JBXH",jbxh);
				ht.put("ZNYH",znyh);
				errcode = psbean.modPerson(ht);
				//返回到查看某部门人员列表的界面    "+strEdit+"

				if(strPage.equals("2")||strPage.equals("4")||strPage.equals("5")) response.sendRedirect("oa/organization/index.jsp?txt_type=3&txt_edit=1&txt_page="+strPage+"&txt_personno="+strPersonNO+"&txt_orgno="+strOrgNO+"&errcode="+errcode);

				else	response.sendRedirect("oa/organization/index.jsp?txt_type=3&txt_page="+strPage+"&txt_personno="+strPersonNO+"&txt_orgno="+strOrgNO+"&errcode="+errcode);
			}

//登陆者修改个人的基本信息
			if(strType!=null && strType.equals("3") && strEdit.equals("6"))
			{
				strOrgNO=ds.toString((String)request.getParameter("txt_bmno"));
				psbean.setOrgNO(strOrgNO);
				psbean.setPersonNO(strPersonNO);

				//String zgName = ds.toGBK(request.getParameter("txt_xm"));
				String oldPsw = ds.toGBK(request.getParameter("old_psw"));
				boolean bool = psbean.verifyPwd(oldPsw);
				if(!bool)
				{
					errcode = 7;
					response.sendRedirect("oa/organization/index.jsp?txt_type=3&txt_edit=6&txt_personno="+strPersonNO+"&txt_orgno="+strOrgNO+"&errcode="+errcode);
				}
				else{
					String newPSWord = ds.toGBK(request.getParameter("password_check"));
					String surePSWord = ds.toGBK(request.getParameter("pass_checkagain"));
					String pswQuestion = ds.toGBK(request.getParameter("txt_mmwt"));
					String pswKey = ds.toGBK(request.getParameter("txt_mmda"));
					String Sex = ds.toGBK(request.getParameter("txt_xb"));
					String birthDay = ds.toGBK(request.getParameter("txt_csny"));
					String mz = ds.toGBK(request.getParameter("txt_mz"));
					String zzmm = ds.toGBK(request.getParameter("txt_zzmm"));
					String xli = ds.toGBK(request.getParameter("txt_xl"));
					String zhich = ds.toGBK(request.getParameter("txt_zc"));
					String bgphone = ds.toGBK(request.getParameter("txt_bgdh"));
					String fjphone = ds.toGBK(request.getParameter("txt_fjdh"));
					String jtphone = ds.toGBK(request.getParameter("txt_jtdh"));
					String mobile = ds.toGBK(request.getParameter("txt_mobile"));
					String address = ds.toGBK(request.getParameter("txt_address"));
					String code = ds.toGBK(request.getParameter("txt_yzbm"));
					String qqNo = ds.toGBK(request.getParameter("txt_qq"));
					String email = ds.toGBK(request.getParameter("txt_email"));
					String username = ds.toGBK(request.getParameter("txt_username")).toLowerCase();
					String photo = ds.toGBK(request.getParameter("txt_pic"));
					String znyh = ds.toGBK(request.getParameter("txt_znyh"));
					if(photo==null || photo.equals(""))photo="0";
					String grjj = ds.toGBK(request.getParameter("txt_grjj"));

					Hashtable ht = new Hashtable();
					//ht.put("XM",zgName);
					if(newPSWord==null || newPSWord.equals(""))
						ht.put("MM",oldPsw);
					else