usedinfo.jsp

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

<%
/**********************************************************
Copyright (C),2003-10-15, Beijing  USTB.
All rights reserved.
Filename: oper.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 strEdit = ds.toString((String)request.getParameter("txt_edit"));

	//权限控制
	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>
    <TD>
      <CENTER><B><font color="#ffffff">默认操作</font></B></CENTER></TD>
    <TD>
      <CENTER><B><font color="#ffffff">使用状态</font></B></CENTER></TD>
     <%if(strmkqx.equals("增删改")){%>
	 <TD>
      <CENTER><B><font color="#ffffff">操作</font></B></CENTER></TD><%}%>
	  
  </TR>
  <TR bgColor=#ffffff>
    <TD colSpan=7 height=15 align=right>
	<FONT color="#FF6600">
	<A onclick="add('','');" style="cursor:hand;">新增模块类型</A>
	</FONT>&nbsp;&nbsp;&nbsp;</TD></TR>
  <%
 	String bgcolor="";
	myBean.setType(2);
	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 strID1 = (String)hash.get("MKBH");
		String strLX = (String)hash.get("CZLX");
		String strCZ = (String)hash.get("MRCZ");
		String strZT = (String)hash.get("SYZT");
		if(strLX.equals("0")) strLX = "浏览";
		else strLX = "增删改";
		if(strCZ.equals("0")) strCZ = "非默认";
		else strCZ = "<font color='#0066FF'>默认</font>";
		if(strZT.equals("0")) strZT = "使用";
		else strZT = "<font color='#ff0000'>弃用</font>";
%>

  <TR bgColor="<%=bgcolor%>">
    <TD width=60 align=center><%=strID1%></TD>
    <TD width=60 ><%=(String)hash.get("MKMC")%></TD>
    <TD><%=(String)hash.get("MKSM")%></TD>
    <TD width=60 align=center><%=strLX%></TD>
    <TD width=60 align=center><%=strCZ%></TD>
	<TD width=60 align=center><%=strZT%></TD>
    <%if(strmkqx.equals("增删改")){%><TD width=110 align=center>
	<FONT color="#99cc00">
	 
	  <A onclick="edit('<%=strID1%>');" style="cursor:hand;">修改</A> | 
	  <A onclick="del('<%=strID1%>');" style="cursor:hand;">删除</A>
	</FONT>
	</TD><%}%></TR>
<%
	}
%>
  </TBODY></TABLE>
  <script>
	function add(id)
	{
		document.all.txt_type.value = "2";
		document.all.txt_id.value = id;
		document.all.txt_dict.value = "";
		document.all.txt_edit.value = "1";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}

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

	function del(id)
	{
		if(!confirm("是否真的要删除？"))
		{
		}
		else
		{
			document.all.txt_type.value = "2";
			document.all.txt_id.value = id;
			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();
}
%>