dict.jsp

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

<%
/**********************************************************
Copyright (C),2003-10-15, Beijing  USTB.
All rights reserved.
Filename: dict.jsp
Author: 
Version 1.0
Date:2003-10-15
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.SysmanBean myBean = null;
oa.bean.RightBean rBean = null;

try{
	myBean = new oa.bean.SysmanBean();
	rBean = new oa.bean.RightBean();

	if(myBean.getConn()==null || rBean.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 strID = ds.toString((String)request.getParameter("txt_id"));

	//字典名称
	String strDict = ds.toString((String)request.getParameter("txt_dict"));

	//权限控制
	String uid = (String)session.getAttribute("zgbh");
	rBean.setUID(uid);
%>

<br>



<div align=center>
<font color="#CC00FF" size=3><b>字典维护<b></font>
</div>
<br>
<TABLE cellSpacing=1 cellPadding=5 width="95%" align=center bgColor=#999999 style="word-break:break-all;">
  <TBODY>
  <TR bgColor=#2969b5 height=20>
    <TD>
      <CENTER><B><font color="#ffffff">字典名称</font></B></CENTER></TD>
    <!--TD>
      <CENTER><B><font color="#ffffff">项目编号</font></B></CENTER></TD--->
    <TD>
      <CENTER><B><font color="#ffffff">项目名称</font></B></CENTER></TD>
    <TD>
      <CENTER><B><font color="#ffffff">使用状态</font></B></CENTER></TD>
<%
boolean
	right1 = rBean.isRightMode("字典维护","修改"),
	right2 = rBean.isRightMode("字典维护","删除"),
	right3 = rBean.isRightMode("字典维护","增加项目"),
	right4 = rBean.isRightMode("字典维护","新增字典名称");
if(right1||right2||right3)
{%>
	<TD><CENTER><B><font color="#ffffff">操作</font></B></CENTER></TD>
<%}%>	

	</TR>
<%if(right4){%>
  <TR bgColor=#ffffff>
    <TD colSpan=5 height=15 align=right>
	<FONT color="#FF6600">
	<A onclick="add('','');" style="cursor:hand;">新增字典项目</A>
	</FONT>&nbsp;&nbsp;&nbsp;
	</TD></TR>
<%}%>

<%	String bgcolor="";
	myBean.setType(1);
	Vector vect = (Vector)myBean.getData();
	for(int i=0;i<vect.size();i++)
	{
		if ((i%2)==0) { 
			bgcolor="#d0e7ff";
		}else {
			bgcolor="#ffffff";
		}
		Hashtable hash = (Hashtable)vect.get(i);
		String strMC = (String)hash.get("ZDMC");
		String strID1 = (String)hash.get("XMBH");
		String strZT = (String)hash.get("SYZT");
		if(strZT.equals("0"))strZT = "使用";
		else strZT = "<font color='#ff0000'>弃用</font>";
%>

  <TR bgColor="<%=bgcolor%>">
    <TD width=120><%=strMC%></TD>
    <!---TD width=60 align=center><%=strID1%></TD--->
    <TD><%=(String)hash.get("XMMC")%></TD>
    <TD width=60 align=center><%=strZT%></TD>
	
<%
if(right1||right2||right3)
{
	if(strZT.equals("使用")){
%>
		<TD width=140 align=center>
		<FONT color="#338800"><!--#99cc00--->
		<%if(right3 && !strMC.equals("操作权限分管领导") && !strMC.equals("操作权限主管领导")&& !strMC.equals("系统邮件过滤")){%>
		<A onclick="add('<%=strID1%>','<%=strMC%>');" style="cursor:hand;">增加项目&nbsp;</A>|
		<%}%>
		<%if(right1){%>
		<A onclick="edit('<%=strID1%>','<%=strMC%>');"style="cursor:hand;">修改</A>
		<%}%>
		<%if(right2 && !strMC.equals("操作权限分管领导") && !strMC.equals("操作权限主管领导")){%>|<A onclick="del('<%=strID1%>','<%=strMC%>');" style="cursor:hand;">&nbsp;删除</A>
		<%}%>
		</FONT>
		</TD>
<%
	}else{
%>
		<TD width=140 align=center>
		<FONT color="#338800"><!--#99cc00--->
		<%if(right1){%>
		<A onclick="revert('<%=strID1%>','<%=strMC%>');"style="cursor:hand;">恢复使用</A>
		<%}%>
		<%if(right2){%>|<A onclick="_del('<%=strID1%>','<%=strMC%>');" style="cursor:hand;">&nbsp;彻底删除</A>
		<%}%>
		</FONT>
		</TD>
<%
	}
}
%>

	</TR>
<%
	}
%>
  </TBODY></TABLE>
  <script>
	function revert(id,mc)
	{
		if(!confirm("是否真的要恢复使用？"))
		{
			return false;
		}
		else
		{
			document.all.txt_type.value = "1";
			document.all.txt_id.value = id;
			document.all.txt_dict.value = mc;
			document.all.txt_edit.value = "4";
			document.all.form1.action = "../../Sysman";
			document.all.form1.submit();
		}
	}

	function add(id,mc)
	{
		document.all.txt_type.value = "1";
		document.all.txt_id.value = id;
		document.all.txt_dict.value = mc;
		document.all.txt_edit.value = "1";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}

	function edit(id,mc)
	{
		document.all.txt_type.value = "1";
		document.all.txt_id.value = id;
		document.all.txt_dict.value = mc;
		document.all.txt_edit.value = "2";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}

	function del(id,mc)
	{
		if(!confirm("是否真的要弃用？"))
		{
			return false;
		}
		else
		{
			document.all.txt_type.value = "1";
			document.all.txt_id.value = id;
			document.all.txt_dict.value = mc;
			document.all.txt_edit.value = "3";
			document.all.form1.action = "../../Sysman";
			document.all.form1.submit();
		}
	}
	function _del(id,mc)
	{
		if(!confirm("是否真的要删除？"))
		{
			return false;
		}
		else
		{
			document.all.txt_type.value = "11";
			document.all.txt_id.value = id;
			document.all.txt_dict.value = mc;
			document.all.txt_edit.value = "3";
			document.all.form1.action = "../../Sysman";
			document.all.form1.submit();
		}
	}
</script>
<%}finally{
	if(myBean!=null)myBean.closeConn();
	if(rBean!=null)rBean.closeConn();
}%>