⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 displaytxun.jsp

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

<%
/**********************************************************
Copyright (C),2003-10-25, Beijing  USTB.
All rights reserved.
Filename: displayTxun.jsp
Author: 贾之勇
Version 1.0
Date:2003-10-25
Description:显示个人通讯录主页面
Other:
Variable List:

Function List:

History:
***********************************************************/
%>
<%@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 = "0";

	//增删改类型
	String strEdit = ds.toString((String)request.getParameter("txt_edit"));
	
	//错误码
	String errcode = ds.toString((String)request.getParameter("errcode"));
	if(errcode.equals(""))errcode = "0";
	if(!errcode.equals("0"))response.sendRedirect("../err.jsp?ip=person/displayTxun.jsp&txt_type="+strType+"&errcode="+errcode);
	//按什么字段排序
	String strPaixu = ds.toString((String)request.getParameter("txt_paixu"));
	
	//排序用的图片
	String imgname0 = ds.toString((String)request.getParameter("imgname0"));
	if(imgname0.equals("") || imgname0==null)
	    imgname0 = "../images/arrowup.gif";

	
	//取得职工编号
	String strPersonNo = ds.toString((String)request.getParameter("txt_personno"));
	
	//联系人序号
	String strOrderNo = ds.toString((String)request.getParameter("txt_lxrxh"));
	
	//搜索框的内容
	String txtsrch = ds.toGBK((String)request.getParameter("txt_search"));
	if(txtsrch==null)
	    txtsrch = "";
	
	//checkbox 状态
	String chkon = ds.toString((String)request.getParameter("chk_search"));
	
	//按什么字段搜索hidden
	String strSrchZD = ds.toString((String)request.getParameter("txt_srch"));
%>

<TABLE class="tab" width="100%" border="0" cellspacing="0" cellpadding="0"  >

  <TR align=middle  bgcolor="#ffffff" height="22" bgcolor=#003399>
    <TD width="50%" height="22" align="left"><FONT color=#0000FF>我的通讯录</FONT></TD>
 <td align="center"><input type="text" name="txt_search" size="20" value="<%=txtsrch%>"style="border-style: double; border-color: D0E7FF" ></td>
  <td WIDTH="6%"><input type="submit" name="search" value="搜索" class=fashion onclick="return srch();"></td>
     <td align="center"><select name ="sel_search" onchange="onchgss(this);" >
	<option value="">选择查询字段</option>

	<option value="0">姓名</option>

   </select>
  
  </td>
  <td align="left">
<%	if(chkon.equals("ON")){
%> 
  <input type="checkbox" id="chk_search" name="chk_search" value="ON" class=fashion onclick="oncheck(this);" checked>是否精确查询
<%}
else{
%>  
  <input type="checkbox" id="chk_search" name="chk_search"value="" class=fashion onclick="oncheck(this);">是否精确查询
<%}%>
  </td>
  </TR>
</TABLE>
<table class="tab" width="100%" align="center" cellSpacing=1 cellPadding=5 bgColor=#999999>
<hr color=yellow>
  <tr bgcolor="#2969b5" height="22">
    <TD align=center width="15%" ><font color="#ffffff" onclick="onpaixuxm()"><B>姓名<img src="<%=imgname0%>"></B></font></td>
    <TD align=center width="12%" ><font color="#ffffff"><B>移动电话</B></font></td>    
    <TD align=center width="15%"><font color="#ffffff"><B>邮件</B></font></td>
    <TD align=center width="15%"><font color="#ffffff"><B>办公电话</B></font></td>
    <TD align=center width="15%"><font color="#ffffff"><B>工作单位</B></font></td>
	<TD align=center width="15%"><font color="#ffffff"><B>家庭地址</B></font></td>
    <TD align=center width="13%" colspan=2><font color="#ffffff"><B>操作</B></font></td>
  </TR>
  <TR bgColor=#ffffff>
    <TD colSpan=6 height=15></TD>
	<TD title="新增成员"align="center"><FONT color="#99cc00">
	  <A onclick="addPerson()" style="cursor:hand;">[新增]</A> </FONT></TD>
  </TR>
<%
	myBean.setPersonNo("1");
	Vector vect = (Vector)myBean.getData();
	String bgcolor="";

	String bm = (String)request.getParameter("bm");
	if(bm==null || bm.equals("")) bm = "1";
	int cur = Integer.parseInt(bm);
    int recsum = ((Integer)vect.get(vect.size()-1)).intValue();

	vect = (Vector)myBean.getOnePage(cur,5);
	int sum = Integer.parseInt((String)vect.get(0));

	for(int i=1;i<vect.size();i++)
	{
		if ((i%2)==0) { 
			bgcolor="#d0e7ff";
		}else {
			bgcolor="#ffffff";
		}//end if else

		Hashtable hash = (Hashtable)vect.get(i);
		String strPerson="1";
	    String strXM = ds.toString((String)hash.get("LXRXM"));
	  	String strXH = ds.toString((String)hash.get("LXRXH"));
		String strYD = ds.toString((String)hash.get("YDDH"));
		String strMAIL = ds.toString((String)hash.get("EMAIL"));
		String strBG = ds.toString((String)hash.get("BGDH"));
		String strDW = ds.toString((String)hash.get("GZDW"));
		String strDZ = ds.toString((String)hash.get("JTDZ"));
%>
<TR  bgcolor="<%=bgcolor%>">
  <TD align=center><B><%=strXM%><B></a></TD>
  <TD align=center><%=strYD%></TD>
  <TD align=center><%=strMAIL%></TD>
  <TD align=center><%=strBG%></TD>
  <TD align=center><%=strDW%></TD>
  <TD align=center><%=strDZ%></TD>
  <TD align="center"><FONT color="#99cc00">
	 <A onclick="modPerson('<%=strXH%>'); "style="cursor:hand;">[修改]&nbsp;</A> 
	<A onclick="delPerson('<%=strXH%>'); "style="cursor:hand;">[删除]</A>
      </FONT>
 </TD>
 </TR>
<%
	}
int t =-1;
int s = -1;
%>
<%
	myBean.setPersonNo("1");
	//Vector vect = new Vector();
		//strPaixu:0,1按姓名排序;

		if(strPaixu.equals("0"))
			vect = (Vector)myBean.getData("XM",false,"","",true);
		if(strPaixu.equals("1"))
			vect = (Vector)myBean.getData("XM",true,"","",true);
		if(!strSrchZD.equals("") && chkon.equals("ON"))//精确查询
		{
			if(strSrchZD.equals("0"))//按姓名
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("XM",false,"XM",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("XM",true,"XM",txtsrch,true);
			}
		}
		if(!strSrchZD.equals("") && !chkon.equals("ON"))//模糊查询
			{
				if(strSrchZD.equals("0"))//按姓名
				{
					if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("XM",false,"XM",txtsrch,false);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("XM",true,"XM",txtsrch,false);
				}
			}
%>
	<tr height=25>
		<TD align=right colspan=8 bgColor=D0E7FF>
		共有记录数:<%=recsum%>&nbsp;&nbsp;&nbsp;&nbsp;
		当前<%=cur%>/<%=sum%>页&nbsp&nbsp&nbsp
        <%if(cur>1){%>
		<a onclick="firsrpg()" style="cursor:hand">第一页&nbsp&nbsp&nbsp </a><%}%>
		<%if(cur>1){ t=cur-1;%>
		<a onclick="lastpg()" style="cursor:hand">上一页&nbsp&nbsp&nbsp </a><%}%>
		<%if(cur<sum){ s=cur+1;%>
		<a onclick="nextpg()" style="cursor:hand">下一页&nbsp&nbsp&nbsp</a><%}%>&nbsp&nbsp
		<%if(cur<sum){%>
		<a onclick="finalpg()" style="cursor:hand">最后页&nbsp&nbsp&nbsp </a><%}%>
		直接<input type=image src="../images/hand.gif" name="gotof" onclick="return chkdata()">
		<input type=text size=5 name=bm class=formcolor>页</TD>
	</tr>
</TABLE>

<script>
	function firsrpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm=1";
		document.all.form1.submit();
	}
	function lastpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=t%>;
		document.all.form1.submit();
	}
	function nextpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=s%>;
		document.all.form1.submit();
	}
	function finalpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=sum%>;
		document.all.form1.submit();
	}

	function onchgss(selobj)
	{
		var choice = selobj.selectedIndex;
		document.all.txt_srch.value = selobj.options[choice].value;
		selobj.options[choice].selected;
	}
		function onpaixuxm()
	{
		document.all.txt_type.value = 1;
		if(document.all.txt_paixu.value !="0" && document.all.txt_paixu.value !="1")
			document.all.txt_paixu.value ="0";
		
		if(document.all.txt_paixu.value =="1")
		{
			document.all.txt_paixu.value ="1";
			imgname = "../images/arrowup.gif";
		}
		else if(document.all.txt_paixu.value =="0")
		{
			document.all.txt_paixu.value ="1";
			imgname = "../images/arrowdown.gif";
		}
		
		document.all.form1.action = "person.jsp?imgname0="+imgname;
		document.all.form1.submit();
	}

		function srch()
	{
		document.all.txt_edit.value = "";
		document.all.txt_personno.value = "";
		if(document.all.txt_srch.value == "")
		{
			alert("请选择搜索主题!");
			return false;
		}
		if(document.all.chk_search.value=="ON" && document.all.txt_search.value == "")
		{
			alert("请输入搜索内容");
			return false;
		}
		document.all.form1.action = "person.jsp";
		document.all.form1.submit();
	}

		function oncheck(myname){
		if(myname.checked)
			myname.value="ON";
		else
			myname.value="";
	}
	function addPerson()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "1";
		//document.all.txt_lxrxh.value = "";
		//document.all.txt_personno.value = personno;
		document.all.form1.action = "person.jsp";
		document.all.form1.submit();
	}
	
	function modPerson(orderno)
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "2";
		document.all.txt_lxrxh.value = orderno;
		//document.all.txt_personno.value = personno;
		document.all.form1.action = "person.jsp";
		document.all.form1.submit();
	}
	function delPerson(orderno)
	{
		if(!confirm("是否真的要删除?"))
		{
		}
		else
		{
			document.all.txt_type.value = "1";
			document.all.txt_edit.value = "3";
			document.all.txt_lxrxh.value = orderno;
			//document.all.txt_personno.value = personno;
			document.all.form1.action = "/PerSvlt";
			document.all.form1.submit();
		}
	}
	function isDigit(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 chkdata()
	{
		if(!isDigit(document.all.bm.value))
        {
			alert("输入的页码不是数字!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		if(document.all.bm.value=="")
		{
			alert("请输入页码!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		else
		{
			var t = document.all.bm.value;
			var cur = <%=cur%>;
			var sum = <%=sum%>;

			while(t.length>cur.length)
            {
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t==cur){return false;}
            
			
			while(t.length>sum.length)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t<1||t>sum)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
		}
		return true;
	}

</script>
<%}finally{
	if(myBean!=null)myBean.closeConn();
}%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -