📄 selczqx.jsp

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

💻 JSP

字号:

<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,java.sql.*,oa.main.DealString,javax.swing.tree.DefaultMutableTreeNode"%>
<html>
<script>
	function UpdCzqx(chkbox)//选择操作权限
	{
		var e="";
		var e2;
		var num = chkbox.length;
		var flag = false;
		for(var i=0;i<num;i++)
		{
			if(chkbox[i].checked)
			{
				flag = true;
				e2 = chkbox[i].value;
				if(e=="")
					e=e2;
				else
					e=e+","+e2;

			}
		}
		if(flag == false)
		{
			e="";
			//return false;
		}
		window.opener.document.all.txt_doright.value = e;
		window.close();
		return true;
	}

</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>选择模块操作权限</title>
<script language="javascript" src="../scripts/department.js"></script>
<link href="../css/person.css" type=text/css rel=stylesheet>

</head>
<script language="javascript" src="funs.js"></script>
<body bgcolor= "#F6FEE8">
<form name="form1" method=get>
<style type=text/css>
.HAND
{CURSOR:hand}

</style>
<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 UpdCzqx(document.form1.chkbox)"> 
	<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">
<%
Statement stm = null;
oa.bean.DutyBean myBean = null;
try{
	myBean = new oa.bean.DutyBean();

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

DealString ds = new DealString();
ResultSet rs = myBean.selOper();
String mkmc = "";

while(rs.next())
{
	mkmc = ds.toString(rs.getString("MKMC"));
%>
		<tr>
			<td height=18 width="35%">&nbsp;</td>
			<td height=18 align="left">&nbsp;
			<input type="checkbox" id="chkbox" name="chkbox" value="<%=mkmc%>"style="color: #66FF66;border-style: double; border-color: #6699FF" ><%=mkmc%>
			</td>
			<td height=18 >&nbsp;</td>
		</tr>

<%
}
if(rs!=null){stm=rs.getStatement();rs.close() ;}
if(stm!=null)stm.close();
%>
	</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>
</html>
<%}finally{
	if(myBean!=null)myBean.closeConn();
}%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -