📄 display.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
<%
/**********************************************************
Copyright (C),2003-10-21, Beijing  USTB.
All rights reserved.
Filename: deptree_edit.jsp
Author:  
Version 1.0
Date:2003-10-21
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.PersonBean myBean =null;
oa.bean.RightBean rtBean = null;
try{
	myBean = new oa.bean.PersonBean();
	rtBean = new oa.bean.RightBean();

	if(myBean.getConn()==null || rtBean.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"));

	//组织机构编号
	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 imgname0 = ds.toString((String)request.getParameter("imgname0"));
	//if(imgname0.equals("") || imgname0==null)
	//    imgname0 = "../images/arrowup.gif";
	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过期，请重新登陆！");
}
%>	

<%//权限判断
	rtBean.setUID(userid);
	rtBean.setOrgid(strOrgNO);
%>
<br>

<div align=center>
<font color="#CC00FF" size=2><b>查看人员信息列表<b></font>
</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="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center style="table-layout:fixed;word-break:break-all">
<tr>
  <td><input type="submit" name="all" value="显示全部" class=fashion onclick="dispall();"></td>
<%if(rtBean.isRightModelbh("人员信息","离退休及挂起人员管理")){%>
  <td width=165><input type="submit" name="all"  value="离退休及已挂起人员" class=fashion onclick="tiredps();"></td>
<%}%>
  <td align="center"><input type="text" name="txt_search" size="20" value="<%=txtsrch%>"style="border-style: double; border-color: D0E7FF" onchange="clrsrch();"></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="" <%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="4"<%if(strSrchZD.equals("4")){%>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 onclick="oncheck(this);" checked>是否精确查询
<%}
else{
%>  
  <input type="checkbox" id="chk_search" name="chk_search"value="" class=fashion onclick="oncheck(this);">是否精确查询
<%}%>
  </td>
</tr>
</table>
<br>

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

  <TR bgColor=D0E7FF 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 color="#9933CC"><a style="cursor:hand;"onclick="onpaixuno()">工号<img src="<%=imgname1%>"></a></font></B></CENTER></TD>
   
	<TD title="按姓名排序">
      <CENTER><B><font color="#9933CC"><a style="cursor:hand;"onclick="onpaixuxm()">姓名<img src="<%=imgname2%>"></a></font></B></CENTER></TD>
	<TD title="按性别排序">
      <CENTER><B><font color="#9933CC"><a style="cursor:hand;"onclick="onpaixuxb()">性别<img src="<%=imgname3%>"></a></font></B></CENTER></TD>
	<TD >
      <CENTER><B>级别</B></CENTER></TD>
  <%
 boolean 
  right1 = rtBean.isRightModelbh("人员信息","浏览人员信息"),
  right2 = rtBean.isRightModelbh("人员信息","查看模块权限"),
//  right3 = rtBean.isRightModelbh("人员信息","查看流程权限"),
//  right4 = rtBean.isRightModelbh("人员信息","查看网络资源"),
  right5 = rtBean.isRightModelbh("人员信息","修改"),
  right6 = rtBean.isRightModelbh("人员信息","分派职务"),
  right7 = rtBean.isRightModelbh("人员信息","删除"),
  right8 = rtBean.isRightModelbh("人员信息","新增人员"),
  right9 = rtBean.isRightModelbh("人员信息","设置人员级别");
	//out.println("==============="+right9+"==========");
	//out.println(rtBean.getRightMode());

  if(right2)
  {
  %>
	<TD>
      <CENTER><B>操作权限</B></CENTER></TD>
  <%
  }
  if(right8 || right5 || right6 || right7)
  {
  %>
    <TD>
      <CENTER><B>操作</B></CENTER></TD>
<%}%>
	</TR>
  <%
  if(right8)
  {
  %>
    <TR bgColor=#ffffff>
    <TD colSpan=5 height=15></TD>
	<TD title="新增成员"align="center"><FONT color="#006600">
	  <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("4"))//按用户名
			{
				if(strPaixu.equals("") || strPaixu.equals("0"))
					vect = (Vector)myBean.getData(true,"BMBH",false,"YHM",txtsrch,true);
				else if(strPaixu.equals("1"))
					vect = (Vector)myBean.getData(true,"BMBH",true,"YHM",txtsrch,true);
				else if(strPaixu.equals("2"))
12 3 下一页
⌨️ 快捷键说明

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