📄 user_list_j.jsp

📁 JSP+oracle开发实例精粹》随书光盘
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="qyxx.connectDB" />
<html>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="css/style.css" rel="stylesheet" type="text/css">
<title>查看用户</title>
<script language="javascript">
function op(para)
{
	if(para == 1)
	{
		document.add_form.action = "user_delete.jsp";
		document.add_form.submit();
	}
	if(para == 2)
	{
		document.add_form.action = "user_upgrade.jsp";
		document.add_form.submit();
	}
	if(para == 3)
	{
		document.add_form.action = "user_degrade.jsp";
		document.add_form.submit();
	}
}
</script>
<%
	String departid = (String)session.getAttribute("departid");
	ResultSet rs = null;
	try
	{
		String sql = "select * from QYXX_USER";
		rs = db.executeQuery(sql);
		if(rs.next())
		{
			%>
			<table>
			<tr>
			<td><input type="button" value="删除用户" class="commonbutton" onclick="op(1)"></td>
			<td><input type="button" value="提升用户权限" class="commonbutton" onclick="op(2)"></td>
			<td><input type="button" value="降低用户权限" class="commonbutton" onclick="op(3)"></td>
			</tr>
			</table>
			<form name="add_form" method="post" action="">
			<table width="300">
			<tr bgcolor="gray">
			<td align="center">选择</td>
			<td align="center">姓名</td>
			<td align="center">年龄</td>
			<td align="center">性别</td>
			<td align="center">权限</td>
			</tr>
			<tr>
			<td align="center">
			<%
				String pr = rs.getString("priority");
				if(Integer.parseInt(pr) < 2)
				{
			%>
					<input type="checkbox" name="choose" value="<%=rs.getString("username")%>">
			<%
				}
			%>
			</td>
			<td align="center"><%=rs.getString("name")%></td>
			<td align="center"><%=rs.getString("age")%></td>
			<td align="center"><%=rs.getString("sex")%></td>
			<td align="center"><%=("1".equals(pr) ?  "普通用户" : ("2".equals(pr) ? "主管" : "经理"))%></td>
			</tr>
			<%
			while(rs.next())
			{
				%>
				<tr>
				<td align="center">
				<%
					pr = rs.getString("priority");
					if(Integer.parseInt(pr) < 3)
					{
				%>
						<input type="checkbox" name="choose" value="<%=rs.getString("username")%>">
				<%
					}
				%>
				</td>
				<td align="center"><%=rs.getString("name")%></td>
				<td align="center"><%=rs.getString("age")%></td>
				<td align="center"><%=rs.getString("sex")%></td>
				<td align="center"><%=("1".equals(rs.getString("priority")) ?  "普通用户" : ("2".equals(pr) ? "主管" : "经理"))%></td>
				</tr>
				<%
			}
			%>
			</table>
			</form>
			<%
		}
		else
		{
			session.setAttribute("error","2");
			response.sendRedirect("error.jsp");
		}
	}
	catch(Exception e)
	{
		session.setAttribute("error","1");
		response.sendRedirect("error.jsp");
	}
	finally
	{
		try
		{
			db.closeDB();
			rs.close();
		}
		catch(Exception ee)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
%>
⌨️ 快捷键说明

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