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

📄 display.jsp

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

<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString"%>

<%
oa.bean.PersonBean myBean =null;
try{
	myBean = new oa.bean.PersonBean();
  	DealString ds = new DealString();
	//取得菜单类别
	String strType = ds.toString((String)request.getParameter("txt_type"));

	//组织机构编号
	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"));
	//按什么字段排序
	String strPaixu = ds.toString((String)request.getParameter("txt_paixu"));
	//排序用的图片
	
	String imgname1 = ds.toString((String)request.getParameter("imgname1"));
	if(imgname1.equals("") || imgname1==null)
	    imgname1 = "../images/arrowup.gif";
	String imgname2 = ds.toString((String)request.getParameter("imgname2"));
	if(imgname2.equals("") || imgname2==null)
	    imgname2 = "../images/arrowup.gif";
	String imgname3 = ds.toString((String)request.getParameter("imgname3"));
	if(imgname3.equals("") || imgname3==null)
	    imgname3 = "../images/arrowup.gif";
	//搜索框的内容
	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"));
	
	//下拉框定位
	//String strSrchIndex = ds.toString((String)request.getParameter("sel_search"));
%>
<%
String userid = (String)session.getAttribute("zgbh");//从session取出来  
if(userid==null || userid.equals(""))
{
	System.out.println("session过期,请重新登陆!");
}
%>	
<br>

<div align=center>
<font style='font-size: 24px;font-weight: bold;font-family: "楷体_GB2312";'><b>查看人员信息列表<b></font>
<hr align="center" width="95%" size="2" noshade>
</div>
<script>

	function srch()
	{
		onchgss(document.all.sel_search);
		document.all.txt_edit.value = "";
		document.all.txt_personno.value = "";
		if(document.all.txt_search.value == "")
		{
			alert("请输入搜索内容!");
			return false;
		}
		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 = "index.jsp";
		document.all.form1.submit();
	}
	function oncheck(myname){
		if(myname.checked)
			myname.value="ON";
		else
			myname.value="";
	}
	function dispall()
	{
		document.all.txt_type.value = 3;
		document.all.txt_paixu.value = 0;
		document.all.txt_srch.value = "";
		document.all.txt_edit.value = "";
		document.all.txt_personno.value = "";
		document.all.form1.action = "index.jsp";
		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 clrsrch()
	{
		document.all.txt_srch.value="";
	}
	function tiredps()
	{
		document.all.txt_type.value = 3;
		//document.all.txt_paixu.value = "";
		//document.all.txt_srch.value = "";
		document.all.txt_edit.value = 5;
		//document.all.txt_personno.value = "";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}
</script>
<br>
<input type=hidden name="txt_cont" value="">
<TABLE WIDTH="95%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center style="table-layout:fixed;word-break:break-all">
<tr>
  <td><input type="button" name="all" value="显示全部" class=fashion_1  style='cursor:hand' onclick="dispall();"></td>
  <td width=165><input type="button" name="all"  value="离退休及已挂起人员" class=fashion_1  style='cursor:hand' onclick="tiredps();"></td>
  <td align="center"><input type="text" name="txt_search" size="20" value="<%=txtsrch%>"style="border-style: double; border-color: #000000" onchange="clrsrch();"></td>
  <td WIDTH="6%"><input type="button" name="search" value="搜索" class=fashion_1  style='cursor:hand' onclick="return srch();"></td>
   
   <td align="center"><select name ="sel_search"  ><!---onchange="onchgss(this);"---->
	<option value="" <%if(strSrchZD.equals("")){%>selected<%}%>>选择查询字段</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>
   </select>

  </td>
  <td align="left">
<%	if(chkon.equals("ON")){
%> 
  <input type="checkbox" id="chk_search" name="chk_search" value="ON" class=fashion_1 onclick="oncheck(this);" checked><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'>是否精确查询</font>
<%}
else{
%>  
  <input type="checkbox" id="chk_search" name="chk_search"value="" class=fashion_1 onclick="oncheck(this);"><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'>是否精确查询</font>
<%}%>
  </td>
</tr>
</table>
<br>

<TABLE cellSpacing=1 cellPadding=0 width="95%" align=center bgColor=#000000 style="word-break;break-all;">
  <TBODY>

  <TR bgColor=#FFFFFF height=20>
    <!--TD title="按部门编号排序">
      <CENTER><B><font color="#9933CC"><a style="cursor:hand;"onclick="onpaixubm()">部门<img src="<%//=imgname0%>"></a></font></B></CENTER></TD-->
	<TD title="按职工编号排序">
      <CENTER><B><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'><a style="cursor:hand;"onclick="onpaixuno()">工号<img src="<%=imgname1%>"></a></font></B></CENTER></TD>
   
	<TD title="按姓名排序">
      <CENTER><B><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'><a style="cursor:hand;"onclick="onpaixuxm()">姓名<img src="<%=imgname2%>"></a></font></B></CENTER></TD>
	<TD title="按性别排序">
      <CENTER><B><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'><a style="cursor:hand;"onclick="onpaixuxb()">性别<img src="<%=imgname3%>"></a></font></B></CENTER></TD>
  <%
 boolean 
  right1 = true,//rtBean.isRightModelbh("人员信息","浏览人员信息"),
  right2 = false,
  right3 = false,
  right4 = false,
  right5 = true,//rtBean.isRightModelbh("人员信息","修改"),
  right6 = false,
  right7 = true,//rtBean.isRightModelbh("人员信息","删除"),
  right8 = true;//rtBean.isRightModelbh("人员信息","新增人员");
 
  if(right8 || right5 || right6 || right7)
  {
  %>
    <TD>
      <CENTER><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'><B>操作</B></font></CENTER></TD>
<%}%>
	</TR>
  <%
  if(right8)
  {
  %>
    <TR bgColor=#ffffff>
    <TD colSpan=3 height=15></TD>
	<TD title="新增成员"align="center"><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14;'>
	  <A onclick="add();" style="cursor:hand;">新增</A> </FONT></TD>
	</TR>
  <%}%>
<%
	myBean.setOrgNO(strOrgNO);
	myBean.setPersonNO(strPersonNo);
	Vector vect = new Vector();
	if(strOrgNO.equals("00000000000000000000"))
	{
	//strPaixu:0,1按部门编号排序;2,3按职工编号排序;4,5按姓名排序;6,7按性别排序;
		if(strPaixu.equals("") || strPaixu.equals("0"))
			vect = (Vector)myBean.getData(true,"BMBH",false,"","",true);
		else if(strPaixu.equals("1"))
			vect = (Vector)myBean.getData(true,"BMBH",true,"","",true);
		else if(strPaixu.equals("2"))
			vect = (Vector)myBean.getData(true,"GH",false,"","",true);
		else if(strPaixu.equals("3"))
			vect = (Vector)myBean.getData(true,"GH",true,"","",true);
		else if(strPaixu.equals("4"))
			vect = (Vector)myBean.getData(true,"XM",false,"","",true);
		else if(strPaixu.equals("5"))
			vect = (Vector)myBean.getData(true,"XM",true,"","",true);
		else if(strPaixu.equals("6"))
			vect = (Vector)myBean.getData(true,"XB",false,"","",true);
		else if(strPaixu.equals("7"))
			vect = (Vector)myBean.getData(true,"XB",true,"","",true);
		if(!strSrchZD.equals("") && chkon.equals("ON"))//精确查询
		{
			if(strSrchZD.equals("0"))//按部门编号
			{
				if(strPaixu.equals("") || strPaixu.equals("0"))
					vect = (Vector)myBean.getData(true,"BMBH",false,"BMBH",txtsrch,true);
				else if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData(true,"BMBH",true,"BMBH",txtsrch,true);
				else if(strPaixu.equals("2"))
					vect = (Vector)myBean.getData(true,"GH",false,"BMBH",txtsrch,true);
				else if(strPaixu.equals("3"))
					vect = (Vector)myBean.getData(true,"GH",true,"BMBH",txtsrch,true);
				else if(strPaixu.equals("4"))
					vect = (Vector)myBean.getData(true,"XM",false,"BMBH",txtsrch,true);
				else if(strPaixu.equals("5"))
					vect = (Vector)myBean.getData(true,"XM",true,"BMBH",txtsrch,true);
				else if(strPaixu.equals("6"))
					vect = (Vector)myBean.getData(true,"XB",false,"BMBH",txtsrch,true);
				else if(strPaixu.equals("7"))
					vect = (Vector)myBean.getData(true,"XB",true,"BMBH",txtsrch,true);
			}
			else if(strSrchZD.equals("1"))//按职工编号
			{
				if(strPaixu.equals("") || strPaixu.equals("0"))
					vect = (Vector)myBean.getData(true,"BMBH",false,"GH",txtsrch,true);
				else if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData(true,"BMBH",true,"GH",txtsrch,true);
				else if(strPaixu.equals("2"))
					vect = (Vector)myBean.getData(true,"GH",false,"GH",txtsrch,true);
				else if(strPaixu.equals("3"))
					vect = (Vector)myBean.getData(true,"GH",true,"GH",txtsrch,true);
				else if(strPaixu.equals("4"))
					vect = (Vector)myBean.getData(true,"XM",false,"GH",txtsrch,true);
				else if(strPaixu.equals("5"))
					vect = (Vector)myBean.getData(true,"XM",true,"GH",txtsrch,true);
				else if(strPaixu.equals("6"))
					vect = (Vector)myBean.getData(true,"XB",false,"GH",txtsrch,true);
				else if(strPaixu.equals("7"))
					vect = (Vector)myBean.getData(true,"XB",true,"GH",txtsrch,true);
			}
			else if(strSrchZD.equals("2"))//按姓名
			{
				if(strPaixu.equals("") || strPaixu.equals("0"))
					vect = (Vector)myBean.getData(true,"BMBH",false,"XM",txtsrch,true);
				else if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData(true,"BMBH",true,"XM",txtsrch,true);
				else if(strPaixu.equals("2"))
					vect = (Vector)myBean.getData(true,"GH",false,"XM",txtsrch,true);
				else if(strPaixu.equals("3"))
					vect = (Vector)myBean.getData(true,"GH",true,"XM",txtsrch,true);
				else if(strPaixu.equals("4"))
					vect = (Vector)myBean.getData(true,"XM",false,"XM",txtsrch,true);
				else if(strPaixu.equals("5"))
					vect = (Vector)myBean.getData(true,"XM",true,"XM",txtsrch,true);
				else if(strPaixu.equals("6"))
					vect = (Vector)myBean.getData(true,"XB",false,"XM",txtsrch,true);
				else if(strPaixu.equals("7"))
					vect = (Vector)myBean.getData(true,"XB",true,"XM",txtsrch,true);
			}
			else if(strSrchZD.equals("3"))//按性别
			{
				if(strPaixu.equals("") || strPaixu.equals("0"))
					vect = (Vector)myBean.getData(true,"BMBH",false,"XB",txtsrch,true);
				else if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData(true,"BMBH",true,"XB",txtsrch,true);
				else if(strPaixu.equals("2"))
					vect = (Vector)myBean.getData(true,"GH",false,"XB",txtsrch,true);
				else if(strPaixu.equals("3"))
					vect = (Vector)myBean.getData(true,"GH",true,"XB",txtsrch,true);
				else if(strPaixu.equals("4"))
					vect = (Vector)myBean.getData(true,"XM",false,"XB",txtsrch,true);
				else if(strPaixu.equals("5"))
					vect = (Vector)myBean.getData(true,"XM",true,"XB",txtsrch,true);
				else if(strPaixu.equals("6"))
					vect = (Vector)myBean.getData(true,"XB",false,"XB",txtsrch,true);
				else if(strPaixu.equals("7"))
					vect = (Vector)myBean.getData(true,"XB",true,"XB",txtsrch,true);
			}
		}
		else if(!strSrchZD.equals("") && !chkon.equals("ON"))//模糊查询

⌨️ 快捷键说明

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