addtxun.jsp

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

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

	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 strOrderNo = ds.toString((String)request.getParameter("txt_lxrxh"));

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

	//取得职工编号
    String strPersonNo = ds.toString((String)request.getParameter("txt_personno"));
       if(strPersonNo.equals(""))
	   {
		strPersonNo = (String)session.getAttribute("zgbh");
	   }

	//判断不同的操作状态
	String str[] = new String[8];
	myBean.setPersonNo(strPersonNo);
	
	if(!strEdit.equals("") && strEdit.equals("2"))
	{   
		myBean.setOrderNo(strOrderNo);
		
		Hashtable hash = (Hashtable)myBean.getOneData();
		//System.out.println("hash:"+hash);
		str[0] =strPersonNo;
		str[1] =strOrderNo;
		str[2] = (String)hash.get("LXRXM");
		str[3] = (String)hash.get("YDDH");
		str[4] = (String)hash.get("EMAIL");
		str[5] = (String)hash.get("BGDH");
		str[6] = (String)hash.get("GZDW");
		str[7] = (String)hash.get("JTDZ");
	}
	else
	{
		str[0] =strPersonNo;
		str[1] =myBean.getLXRNo();
		str[2] ="";
		str[3] ="";
		str[4] ="";
		str[5] ="";
		str[6] ="";
		str[7] ="";
	}
%>

<br>
<br>
<table class="tab" width="95%" align=center border="0" cellspacing="0" cellpadding="0"                        style="word-break:break-all;">

  <TR align=middle  bgcolor="CC99CC" height="22">
    <TD width="100%" height="22" align="center">
	<FONT color=#ffffff><%if(strEdit.equals("1")){%>添加我的通讯录<%}else{%>修改我的通讯录<%}%></FONT></a>
	</TD>
  </TR>
</table>

<table  class="tab" width="95%" align=center cellSpacing=1 style="word-break:break-all;">
    <tr bgcolor="E7E7E7">
      <td width="40%" align="right">职工编号:</td>
      <td width="60%"><input type="text" name="txt_zgbh" value="<%=str[0]%>"readonly size="40" class="text"></td>
    </tr>

    <tr bgcolor="ffffff">
      <td width="40%" align="right">联系人序号:</td>
      <td  width="60%"><input type="text" name="txt_lxrxh" size="40" value="<%=str[1]%>" readonly></td>
    </tr>

    <tr bgcolor="E7E7E7">
      <td width="40%" align="right">联系人姓名:</td>
      <td  width="60%"><input type="text" name="txt_lxrxm" size="40" value="<%=str[2]%>"                    maxlength="10"></td>
    </tr>

    <tr bgcolor="ffffff">
      <td width="40%" align="right">移动电话:</td>
      <td  colspan=2 width="60%"><input type="text" name="txt_yddh" size="40" value="<%=str[3]%>"           maxlength="15"></td>
    </tr>

    <tr bgcolor="E7E7E7">
      <td width="40%" align="right">E-mail:</td>
      <td  width="60%"><input type="text" name="txt_email" size="40" value="<%=str[4]%>"                    maxlength="40"></td>
    </tr>

    <tr bgcolor="ffffff">
      <td width="40%" align="right">办公电话:</td>
      <td colspan=2 width="60%"><input type="text" name="txt_bgdh" size="40" value="<%=str[5]%>"            maxlength="20"></td>
    </tr>

    <tr bgcolor="E7E7E7">
      <td width="40%" align="right">工作单位:</td>
      <td  width="60%"><input type="text" name="txt_gzdw" size="40" value="<%=str[6]%>"                     maxlength="40"></td>
    </tr>

	<tr bgcolor="ffffff">
      <td width="40%" align="right">家庭地址:</td>
      <td  width="60%"><input type="text" name="txt_jtdz" size="40" value="<%=str[7]%>"                     maxlength="40"></td>
    </tr>

    <tr  bgcolor="E7E7E7">
      <td width="100%" align="center" colspan=2><input type="button" value="提交" name="t1"                 onclick="return toservlet()">&nbsp;&nbsp;&nbsp;&nbsp;
      <input type="button" value="取消" name="B2"                                                           onclick="javascript:history.back();"></td>
    </tr>
  </table>

<script>
function toservlet()
{
		if(document.all.txt_email.value!="" &&!Dig(document.all.txt_email.value))
	    {
		alert("邮件地址中必须含有@!");
       document.all.txt_email.value=""; 
	   document.all.txt_email.focus();
	   return false;
	    }
		if(document.all.txt_lxrxm.value=="" )
		{
			alert("请填写完整您的姓名!");
			document.all.txt_lxrxm.value="";
			document.all.txt_lxrxm.focus();
			return false;
		}
		if(document.all.txt_lxrxm.value!="" && isDig(document.all.txt_lxrxm.value))
		{
			alert("姓名不能为数字!");
			document.all.txt_lxrxm.value="";
			document.all.txt_lxrxm.focus();
			return false;
		}
		if(document.all.txt_bgdh.value!="" && !isDig(document.all.txt_bgdh.value))
		{
			alert("办公电话必须为数字!");
			document.all.txt_bgdh.value="";
			document.all.txt_bgdh.focus();
			return false;
		}
	    if(document.all.txt_yddh.value!="" && !isDig(document.all.txt_yddh.value))
		{
			alert("移动电话必须为数字!");
			document.all.txt_yddh.value="";
			document.all.txt_yddh.focus();
			return false;
		}
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "<%=strEdit%>";
		document.all.form1.action = "../../PerSvlt";
		document.all.form1.submit();
}
function isDig(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 Dig(str)
{
	var bool = false;
	for(var i=0;i<str.length;i++)
	{
		if(str.charAt(i)=="@")
		{
			bool = true;
			break;
		}
	}
	return bool;
}
</script>
<%}catch(Exception e){oa.main.Logger.log("ERROR:oa.person.addIxun.jsp=>");e.printStackTrace(oa.main.Logger.log);}
finally{
	if(myBean!=null)myBean.closeConn();
}%>