📄 userinfo.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
import="java.util.*" pageEncoding="gb2312" errorPage="../error.jsp"%>
<!DOCTYPE HTML PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>用户信息</title>
<style type="text/css">
<!--
body {
background-color: #B9DAF9;
}
.STYLE3 {font-family: "宋体"; font-size: 18px; }
-->
</style>
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.STYLE5 {color: #FFFFFF}
-->
</style>
</head>
<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
<%
String id = (String) session.getAttribute("userid");
if (id == null)
response.sendRedirect("../index.jsp?error=2");
%>
<%
Integer level = (Integer) session.getAttribute("level");
int l = level.intValue();
if (level == null)
response.sendRedirect("../index.jsp?error=2");
if (!(l == 3))
response.sendRedirect("../error.jsp");
%>
<%
String sql = null;
java.sql.Connection con = null;
java.sql.ResultSet rs = null;
%>
<%
sql = "select * from users";
try {
rs = myRs.executeQuery(sql);
} catch (Exception e) {
e.printStackTrace();
}
%>
<body bgcolor="#FFFFFF">
<table width="1024" border="0" align="center">
<tr>
<td>
<img src="MainImages/Top.jpg" width="1024" height="126">
</td>
</tr>
<tr>
<td>
<table width="1024" height="300" border="0"
background="MainImages/bg01.gif">
<tr>
<td width="192" valign="top">
<table width="100%" border="0">
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="../Main.jsp">首页</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserInfo.jsp">用户信息</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserAdd.jsp">增加用户</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserDel.jsp">删除用户</a>
</div>
</td>
</tr>
<tr>
<td valign="middle">
<div align="center" class="STYLE3">
<a href="UserMod.jsp">修改用户</a>
</div>
</td>
</tr>
</table>
</td>
<td width="822" align="center">
<span class="STYLE5"> <%
out.println("<table align=\"center\" border=\"1\" width=\"800\">");
out.println("<tr><td>用户名<td>权限</tr>");
while (rs.next()) {
out.println("<tr><td><a href=\"User.jsp?userid="
+ rs.getString("userid") + "\">"
+ rs.getString("userid") + "</a><td>"
+ rs.getInt("levels") + "</tr>");
}
out.println("</table>");
%> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<p align="center">
<img src="MainImages/bottom.gif" width="1024" height="80"
border="0" usemap="#Map">
</p>
</td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="521,49,605,70"
href="mailto:zhangxuebo1025@163.com" target="_blank">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -