modbaseinf.jsp

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

<%@page language="java"  import="java.sql.*,java.text.*, java.util.*,java.lang.*,java.io.*,java.sql.*, oa.main.*"  contentType="text/html; charset=GBK"%>
<%
oa.bean.PersonBean myBean = null;
try{
	myBean = new oa.bean.PersonBean();

	if(myBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}

  	DealString ds = new DealString();
	//取得菜单类别
	String strType = ds.toString((String)request.getParameter("txt_type"));
	if(strType.equals(""))strType = "1";

	//组织机构编号
	String strOrgNO = ds.toString((String)request.getParameter("txt_orgno"));

	//职务编号
	String strDutyNO = ds.toString((String)request.getParameter("txt_dutyno"));

	//增删改类型
	String strEdit = ds.toString((String)request.getParameter("txt_edit"));

	//if(strType.equals(""))strType = "3";
	//取得当前人员编号
	String strPersonNo = ds.toString((String)request.getParameter("txt_personno"));
%>
<%	
	myBean.setOrgNO(strOrgNO);
	myBean.setPersonNO(strPersonNo);
    String  str[] = new String[30];
	if(strType.equals("3"))
	{
		Hashtable hash = myBean.getOneData();
		str[0] = (String)hash.get("BMMC");
		//str[1] = (String)hash.get("ZZZT");
		str[2] = (String)hash.get("XM");
		//str[3] = (String)hash.get("MM");//修改个人信息时用的原密码
		str[4] = (String)hash.get("MMWT");
		str[5] = (String)hash.get("MMDA");
	    str[6] = (String)hash.get("XB");
		str[7] = (String)hash.get("CSNY");
		str[8] = (String)hash.get("MZ");
		str[9] = (String)hash.get("ZZMM");
		str[10] = (String)hash.get("XL");
		str[11] = (String)hash.get("ZC");
		str[12] = (String)hash.get("BGDH");
	    str[13] = (String)hash.get("FJDH");
		str[14] = (String)hash.get("JTDH");
		str[15] = (String)hash.get("YDDH");
		str[16] = (String)hash.get("JTDZ");
		str[17] = (String)hash.get("YZBM");
		str[18] = (String)hash.get("QQ");
		str[19] = (String)hash.get("EMAIL");
		str[20] = (String)hash.get("YHM");
		//str[21] = (String)hash.get("ZCRQ");
		str[22] = (String)hash.get("GRJJ");
		str[23] = (String)hash.get("GH");
		str[24] = (String)hash.get("ZNYH");
	}
%>
<br>
<table class="tab" cellSpacing="1" cellPadding="0" width="100%" border="0"ALIGN=CENTER>
  <tbody>
    <tr align="left" bgColor="#cc99cc" height="22">
      <td height="22"><font color="#ffffff">修改个人基本信息(加*的为必填项)</font></td>  
    </tr>
  </tbody>
</table>
<table class="tab" cellSpacing="3" width="100%" ALIGN=CENTER>
  <tbody>
    <tr bgColor="#E7E7E7" height="20">
      <td align="right"  width="20%">部门名称：</td>
	  <td align=left  width="25%"><%=str[0]%></td>
      <td align="right"  width="20%">工&nbsp;&nbsp;&nbsp;&nbsp;号：</td>
	  <td align=left  width="25%"><%=str[23]%>
		<input type="hidden" name="txt_znyh" value="<%=str[24]%>"></td>
    </tr>

    <tr bgColor="#ffffff" height="20">
      <td align="right">*姓&nbsp;&nbsp;&nbsp;&nbsp;名：</td>
      <td><%=str[2]%><input type="hidden" name="txt_xm" size="20" value="<%=str[2]%>"></td>
      <td align="right">*原&nbsp;密&nbsp;码：</td>
      <td ><input class="text" type="password" value="" name="old_psw" size="20"></td> 
    </tr>

    <tr >
      <!--td align="right">*新&nbsp;密&nbsp;码：</td-->
      <td ><input type="hidden"class="text" type="password" value="" name="password_check" size="20"></td> 
      <!--td align="right">*确认密码：</td-->
      <td ><input type="hidden"class="text" type="password" value="" name="pass_checkagain" size="20"></td>
    </tr>
    <tr >
      <!--td align="right">密码问题：</td-->
      <td><input type="hidden"class="text" name="txt_mmwt" size="20"value="<%=str[4]%>"></td>
      <!--td align="right">密码答案：</td-->
      <td><input type="hidden"class="text" name="txt_mmda" size="20"value="<%=str[5]%>"></td>
    </tr>

    <tr bgColor="#E7E7E7" height="22">
      <td align="right">性&nbsp;&nbsp;&nbsp;&nbsp;别：</td>
      <td><input class="text" name="txt_xb" size="13"readonly value="<%=str[6]%>">
      <select class="text" name="sel_xb" onchange="onchg(this,document.all.txt_xb)">
          <option value="" selected></option>
          <option value="男" >男</option>
          <option value="女">女</option>
        </select></td>
      <td align="right">出生年月：</td>
      <td><input class="text" value="<%=str[7]%>" name="txt_csny" size="20"></a>
	  </td>
	</tr>
    <tr bgColor="#ffffff" height="22">
      <td align="right">民&nbsp;&nbsp;&nbsp;&nbsp;族：</td>
      <td><input class="text" name="txt_mz" size="13" readonly value="<%=str[8]%>">
	      <select class="text" name="sel_mz" onchange="onchg(this,document.all.txt_mz)" size=1>
          <option value="" selected></option>
<%
	Vector vt = myBean.getMZ();
	String xmmc = "";
	for(int i=0;i<vt.size();i++)
	{
		xmmc = (String)vt.get(i);
%>
          <option value="<%=xmmc%>"><%=xmmc%></option><!--从字典查-->
<%
	}
%>
		 </select></td>
	  </td>

      <td align="right">政治面貌：</td>
      <td><input class="text" name="txt_zzmm" size="11"readonly value="<%=str[9]%>">   <select class="text" name="sel_zzmm" onchange="onchg(this,document.all.txt_zzmm)" size=1>
          <option value="" selected></option>
<%
	vt = myBean.getZzmm();
	for(int i=0;i<vt.size();i++)
	{
		xmmc = (String)vt.get(i);
%>
          <option value="<%=xmmc%>"><%=xmmc%></option><!--从字典查-->
<%
	}
%>
		 </select>
	  </td>
    </tr>

    <tr bgColor="#E7E7E7" height="22">
      <td align="right">学&nbsp;&nbsp;&nbsp;&nbsp;历：</td>
      <td><input class="text" name="txt_xl" size="11"readonly value="<%=str[10]%>">
	    <select class="text" name="sel_xl" onchange="onchg(this,document.all.txt_xl)" size=1>
          <option value="" selected></option>
<%
	vt = myBean.getXL();
	for(int i=0;i<vt.size();i++)
	{
		xmmc = (String)vt.get(i);
%>
          <option value="<%=xmmc%>"><%=xmmc%></option><!--从字典查-->
<%
	}
%>
		 </select></td>
      <td align="right">职&nbsp;&nbsp;&nbsp;&nbsp;称：</td>
      <td><input class="text" name="txt_zc" size="20"readonly value="<%=str[11]%>">
	    <select class="text" name="sel_zc" onchange="onchg(this,document.all.txt_zc)" size=1>
          <option value="" selected></option>
<%
	vt = myBean.getZC();
	for(int i=0;i<vt.size();i++)
	{
		xmmc = (String)vt.get(i);
%>
          <option value="<%=xmmc%>"><%=xmmc%></option><!--从字典查-->
<%
	}
%>
		 </select></td>
    </tr>
    <tr bgColor="#ffffff" height="22">
	  <td align="right">办公电话：</td>
      <td><input class="text" name="txt_bgdh" size="20" value="<%=str[12]%>"></td>
	  <td align="right">分机电话：</td>
      <td><input class="text" name="txt_fjdh" size="20" value="<%=str[13]%>"></td>
	</tr>
    <tr bgColor="#E7E7E7" height="22">
      <td align="right">家庭电话：</td>
      <td><input class="text" value="<%=str[14]%>" name="txt_jtdh" size="20"></td>
	  <td align="right">移动电话：</td>
      <td><input class="text" name="txt_mobile" size="20" value="<%=str[15]%>"></td>
	</tr>
    <tr bgColor="#ffffff" height="22">
	  <td align="right">家庭地址：</td>
      <td><input class="text" name="txt_address" size="20" value="<%=str[16]%>"></td>
	  <td align="right">邮政编码：</td>
      <td><input class="text" value="<%=str[17]%>" name="txt_yzbm" size="20"></td>
	</tr>
    <tr bgColor="#E7E7E7" height="22">
      <td align="right">&nbsp;&nbsp;QQ&nbsp;&nbsp;：</td>
      <td><input class="text" name="txt_qq" size="20" value="<%=str[18]%>"></td>
      <td align="right">E-mail&nbsp;&nbsp;：</td>
      <td><input class="text" name="txt_email" size="20" value="<%=str[19]%>"></td>
    </tr>
<!---->
    <tr bgColor="#ffffff" height="20">
      <td align="right">*用户名&nbsp;：</td>
      <td><input class="text" name="txt_username" size="20" value="<%=str[20]%>" style="text-transform:lowercase;"></td>
      <td align="right"></td>
      <td><input class="text" name="txt_pic" size="20" style="text-transform:lowercase;display:none;" readonly >
	  </td>
	</tr>
<!----->
	<tr bgColor="#E7E7E7">
	 <td align=right valign="top">个人简介 ：</td>
	 <td align=left colspan="3">
	 <textarea rows="5" cols="66" name="txt_grjj"><%=str[22]%></textarea>
	 </td>
	</tr>
    <tr bgColor="#ffffff" >
      <td align="center" colspan=4>
		<input type="button" value="提交" name="B2"class=fashion onclick="return oncheckdata()">
		<input type="reset" value="重置" name="B1"class=fashion ></p>
	  </td>
    </tr>
	</tbody>
</table>
<script>
	function oncheckdata()
	{
		if(document.all.txt_xm.value=="")
		{
			alert("请填写您的姓名!");
			return false;
		}
		else if(document.all.old_psw.value=="")
		{
			alert("请正确填写您原来的密码!");
			return false;
		}
		else if(document.all.txt_qq.value!="" && !isDig(document.all.txt_qq.value))
		{
			alert("QQ必须为数字!");
			return false;
		}
		else if(document.all.txt_bgdh.value!="" && !isPhonenumger(document.all.txt_bgdh.value))
		{
			alert("请正确输入电话号码!");
			return false;
		}
		else if(document.all.txt_fjdh.value!="" && !isPhonenumger(document.all.txt_fjdh.value))
		{
			alert("请正确输入分机电话号码!");
			return false;
		}
		else if(document.all.txt_yzbm.value!="" && !isDig(document.all.txt_yzbm.value))
		{
			alert("邮政编码必须为数字!");
			return false;
		}
		else if(document.all.txt_jtdh.value!="" && !isPhonenumger(document.all.txt_jtdh.value))
		{
			alert("请正确输入家庭电话号码!");
			return false;
		}
		else if(document.all.txt_mobile.value!="" && !isDig(document.all.txt_mobile.value))
		{
			alert("移动电话必须为数字!");
			return false;
		}
		else if(document.all.txt_username.value=="")
		{
			alert("用户名不能为空!");
			return false;
		}
		else
		{
			document.all.txt_type.value = "3";
			document.all.txt_orgno.value = "<%=strOrgNO%>";
			document.all.txt_dutyno.value = "<%=strDutyNO%>";
			document.all.txt_personno.value = "<%=strPersonNo%>";
			document.all.txt_edit.value = "<%=strEdit%>";
			document.all.form1.action = "../../Org";
			document.all.form1.submit();
		}
		return true;
	}
	function isDig(str)
	{
		var bool = true;
		for(var i=0;i<str.length;i++)
		{
			if(!(str.charAt(i)>=0&&str.charAt(i)<=9))
			{
				bool = false;
				break;
			}
		}
		return bool;
	}
	function isPhonenumger(str)
	{
		var bool = true;
		for(var i=0;i<str.length;i++)
		{
			if(!( (str.charAt(i)>=0&&str.charAt(i)<=9) || str.charAt(i)=="-" ))
			{
				bool = false;
				break;
			}
		}
		return bool;
	}
	function onchg(selobj,kjname)
	{
		var choice = selobj.selectedIndex;
		kjname.value = selobj.options[choice].value;
	}
	function upload()
	{	
		var go = "upload.jsp?yhm=<%=str[20]%>";
		var oawin = window.open(go,"_blank","toolbar=0,location=0,status=0,menubar=0,scrollbars=no,resizable=0,width=400,height=150");
		oawin.focus();
		oawin.opener=window;
	}

</script>
<%}catch(Exception e){oa.main.Logger.log("ERROR:oa.organization.modbaseinf.jsp=>");e.printStackTrace(oa.main.Logger.log);}
finally{if(myBean!=null)myBean.closeConn();}%>