📄 selglyqx.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
<%
/**********************************************************
Copyright (C),2003-11-25, Beijing  USTB.
All rights reserved.
Filename: selGLYqx.jsp 
Author:    
Version 1.0
Date:2003-11-25
Description:选择管理员权限.jsp
Other:
History:
1.  Date:2003-11-29
    Author:liumei	
    Modification:modify
2.  ...
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString"%>

<%
oa.bean.ArticleBean myArtBean = null;
try{
	myArtBean = new oa.bean.ArticleBean();

	if(myArtBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}


DealString ds = new DealString();
String uid = ds.toString((String)request.getParameter("uid"));
String tableID = ds.toString((String)request.getParameter("id"));
String strID = ds.toString((String)request.getParameter("strId")); //版面ID
String strPersonNo = ds.toString((String)request.getParameter("strpersonno"));

Hashtable hash = (Hashtable)myArtBean.getbmqx(uid);
String str[] = new String[4];
if(tableID.equals("1"))//第1个表
{
	str[1] = (String)hash.get("IMG1");	
	str[2] = (String)hash.get("HEAD1");
	str[3] = (String)hash.get("GOOD1");
}
else//第2个表
{
	str[1] = (String)hash.get("IMG2");	
	str[2] = (String)hash.get("HEAD2");
	str[3] = (String)hash.get("GOOD2");
}

for(int i=1;i<=3;i++)
{
	str[i] = ","+str[i]+",";
}
%>
<html>
<head>
<title>选择管理员权限</title>
<script language="javascript" src="../scripts/department.js"></script>
<link href="../css/person.css" type=text/css rel=stylesheet>
</head>	
<body bgcolor= "#F6FEE8">
<form name="form2" method=post>


<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="subbtn" value="确定" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return onsure()"> 
	<input type="button" name="btcancel" value="取消" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="self.close()"> 
</td></tr></TABLE>
<hr size="4" noshade color="orange"></hr>

<TABLE WIDTH="98%" BORDER=0 CELLSPACING=1 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
  <col width="55%"><col width="45%">
  <TR CLASS=p9 valign=middle>
    <TD ALIGN=center BGCOLOR=#70A6FF nowrap height=20>
      <FONT COLOR=#993300 >&nbsp;请选择管理员权限</FONT>
    </TD>
  </TR>
</TABLE>

<TABLE WIDTH="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
	<tr>
		<td height=18 width="35%">&nbsp;</td>
		<input type="checkbox" name="chkbox" value="" style="color: #66FF66;border-style: double; border-color: #6699FF" checked readonly>审核文章</td>		
		<td height=18 >&nbsp;</td>
	</tr>

<%
	String QXtitle[] = new String[4];
	//QXtitle[0] = "审核文章";
	QXtitle[1] = "审核焦点";
	QXtitle[2] = "审核首页";
	QXtitle[3] = "审核图片";

for(int i=1;i<=3;i++)
{
	if(str[i].indexOf(","+strID+",")!=-1) 
	{
	%>
		<tr>
			<td height=18 width="35%">&nbsp;</td>
			<td height=18 align="left">&nbsp;
			<input type="checkbox" id="<%=i%>" name="chkbox" value="<%=strID%>,<%=i%>" style="color: #66FF66;border-style: double; border-color: #6699FF" <%if(i==0){%>checked readonly<%}%> ><%=QXtitle[i]%>
			</td>
			<td height=18 >&nbsp;</td>
		</tr>
	<%
	}
}

	String []chkval = (String[])request.getParameterValues("chkbox");
%>
</TABLE>

<TABLE WIDTH="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
  <TR CLASS=p9 valign=middle>
    <TD ALIGN=center BGCOLOR=#70A6FF nowrap height=20 ></TD>
  </TR>
</TABLE>


</form>
</body>
<script language=javascript>
	function onsure()//选择部门
	{
		if(!confirm("确定？"))
		{return false;}
		else
			document.all.form2.submit();
<%		
		String bmqx = "";
		String qx = strID+",0;";//将这个版面的审批文章权限分配给对象

		if(chkval!=null)
		{
			for(int j=0;j<chkval.length;j++)
			{
				bmqx = chkval[j];				
				qx = qx+bmqx+";";				
			}
		}	
		
		int jj = myArtBean.updateCZQX(qx,strPersonNo);	
		if(jj==0)
			%> alert("分配成功！");<%
		else
			%> alert("分配失败！");<%			
	
%>
		window.close();
	}


</script>
</html>
<%}finally{
	if(myArtBean!=null)myArtBean.closeConn();
}%>
⌨️ 快捷键说明

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