displaytxun.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 = "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"));
	    if(strPaixu.equals(""))strPaixu = "1";

	//排序用的图片
	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"));
		if(strPersonNo.equals(""))
	{
		strPersonNo = (String)session.getAttribute("zgbh");
	}

	//联系人序号
	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"));
%>
<br><br>
 <TABLE class="tab" align="center" width="100%" border="0" cellspacing="2" cellpadding="0" style="word-break:break-all;">
 <TR bgcolor="#ffffff" height="22">
 <td align="right" valign="top">
    <input type="text" name="txt_search" size="15" value="<%=txtsrch%>" style="border-style: double; border-color: 000000" onchange="document.all.txt_srch.value='';">
    <input type="button" name="search" value="搜索" style="border-style: double; border-color: 000000" onclick="srch();">
    <select name ="sel_search" >	<!--- onchange="onchgss(this);" --->
	<option value="">选择查询字段</option>
	<option value="0" <%if(strSrchZD.equals("0")){%>selected<%}%>>姓名</option>
	<option value="1" <%if(strSrchZD.equals("1")){%>selected<%}%>>移动电话</option>
	<option value="2" <%if(strSrchZD.equals("2")){%>selected<%}%>>邮件</option>
	<option value="3" <%if(strSrchZD.equals("3")){%>selected<%}%>>办公电话</option>
	<option value="4" <%if(strSrchZD.equals("4")){%>selected<%}%>>办公地址</option>
	<option value="5" <%if(strSrchZD.equals("5")){%>selected<%}%>>家庭地址</option>
  </select>
<%if(chkon.equals("ON"))
{%> 
  <input type="checkbox" id="chk_search" name="chk_search" value="ON"  onclick="oncheck(this);" checked>是否精确查询
<%}
else
{%>  
  <input type="checkbox" id="chk_search" name="chk_search"value=""  onclick="oncheck(this);">是否精确查询
<%}%>
  </td>
  </TR>
  </TABLE>

<table class="tab" width="100%" align="center" cellSpacing=1 cellPadding=5 bgColor=#999999 style="word-break:break-all;">
  <!---hr color=yellow--->
  <TR bgcolor="#cc99cc" height="22">
	<td width=20>&nbsp;</td>
    <TD align=center  width=9% title="按姓名排序"><font color="#ffffff" onclick="onpaixuxm()"><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=17%><font color="#ffffff"><B>工作单位</B></font></td>
	<TD align=center  width=17%><font color="#ffffff"><B>家庭地址</B></font></td>
    <TD align=center  width=12%><font color="#ffffff"><B>操作</B></font></td>
  </TR>
  <TR bgColor=#ffffff>
    <TD colSpan=7 height=15></TD>
	<TD title="新增成员"align="center"><FONT color="#FF6600">
	  <A onclick="addPerson()" style="cursor:hand;">新增</A> </FONT></TD>
  </TR>

<%
	myBean.setPersonNo(strPersonNo);
	Vector vect = (Vector)myBean.getData();
	String bgcolor="";
    //strPaixu:0,1按姓名排序;

		if(strPaixu.equals("") || strPaixu.equals("0"))
			vect = (Vector)myBean.getData("LXRXM",false,"","",true);
		if(strPaixu.equals("1"))
			vect = (Vector)myBean.getData("LXRXM",true,"","",true);
	
		if(!strSrchZD.equals("") && chkon.equals("ON"))//精确查询
		{
			if(strSrchZD.equals("0"))//按姓名
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"LXRXM",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"LXRXM",txtsrch,true);
			}
			if(strSrchZD.equals("1"))//按移动电话
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"YDDH",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"YDDH",txtsrch,true);
			}
			if(strSrchZD.equals("2"))//按邮件
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"EMAIL",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"EMAIL",txtsrch,true);
			}
			if(strSrchZD.equals("3"))//按办公电话
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"BGDH",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"BGDH",txtsrch,true);
			}
			if(strSrchZD.equals("4"))//按办公地址
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"GZDW",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"GZDW",txtsrch,true);
			}
			if(strSrchZD.equals("5"))//按家庭地址
			{
				if(strPaixu.equals("0"))
					vect = (Vector)myBean.getData("LXRXM",false,"JTDZ",txtsrch,true);
				if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData("LXRXM",true,"JTDZ",txtsrch,true);
			}
		}
		if(!strSrchZD.equals("") && !chkon.equals("ON"))//模糊查询
		{   
			if(strSrchZD.equals("0"))//按姓名
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"LXRXM",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"LXRXM",txtsrch,false);
			}
			if(strSrchZD.equals("1"))//按移动电话
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"YDDH",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"YDDH",txtsrch,false);
			}
			if(strSrchZD.equals("2"))//按邮件
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"EMAIL",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"EMAIL",txtsrch,false);
			}
			if(strSrchZD.equals("3"))//按办公电话
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"BGDH",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"BGDH",txtsrch,false);
			}
			if(strSrchZD.equals("4"))//按办公地址
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"GZDW",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"GZDW",txtsrch,false);
			}
			if(strSrchZD.equals("5"))//按家庭地址
			{
				if(strPaixu.equals("0"))
				vect = (Vector)myBean.getData("LXRXM",false,"JTDZ",txtsrch,false);
				if(strPaixu.equals("1"))
				vect = (Vector)myBean.getData("LXRXM",true,"JTDZ",txtsrch,false);
			}
		}
%>

<%
	
	Hashtable ht = (Hashtable)vect.get(0);
	String sql = (String)ht.get("sql");

	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(sql,cur,10);
	int sum = Integer.parseInt((String)vect.get(0));
	int j=vect.size();
	for(int i=1;i<j;i++)
	{
		if ((i%2)!=0) { 
			bgcolor="#E7E7E7";
		}else {
			bgcolor="#ffffff";
		}

		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%>" align=center>
  <td><input type=checkbox name=checkboxid value="<%=strXH%>"></td>
  <TD align=center><B><%=strXM%><B></a></TD>
  <TD><%=strYD%></TD>
  <TD align=center><%=strMAIL%></TD>
  <TD><%=strBG%></TD>
  <TD><%=strDW%></TD>
  <TD><%=strDZ%></TD>
  <TD align="center"><FONT color="#338800"><A onclick="modPerson('<%=strXH%>'); "style="cursor:hand;">修改</A>|<A onclick="delPerson('<%=strXH%>'); "style="cursor:hand;">删除</A>
 </FONT>
 </TD>
 </TR>
<%
	}
int t =-1;
int s = -1;
if(j>=2){%>	
	<tr>
		<TD align=left colspan=20>
<%if(j>=3){%>
			<input type=button value="全选" name=selall onclick="selectall();" style="cursor:hand;">&nbsp&nbsp&nbsp
<%}%>
			<input type=button value="删除" onclick="return del();" style="cursor:hand;">&nbsp;&nbsp;
			<input type=button value="清空通讯录" onclick="clearlxr();" style="cursor:hand;"></td>
	</tr>
<%}%>

	<tr height=25>
		<TD align=right colspan=8 bgColor=D0E7FF>
		共有记录数：<%=recsum%>&nbsp;&nbsp;&nbsp;&nbsp;
        <%if(vect.size()>1){%>
		当前<%=cur%>/<%=sum%>页&nbsp&nbsp&nbsp