📄 manager_user.jsp
字号:
<%@ page errorPage="ErrPage.jsp"
import="java.util.Date, java.sql.*"
contentType="text/html;charset=gb2312"%>
<jsp:useBean id="pool" scope="application" class="com.PoolBean"/>
<!--利用JAVABEAN连接数据库-->
<%
String strLoginUser = (String)session.getAttribute("LoginUser");
if (strLoginUser == null || strLoginUser.length() == 0)
response.sendRedirect("../Login.jsp");
%>
<HTML>
<HEAD>
<LINK REL="stylesheet" HREF="../littleproject.css" TYPE="text/css">
<TITLE>用户管理</TITLE>
</HEAD>
<BODY bgcolor=LightBlue>
<br>
<center>
<%
try
{
if (pool.getConnectionSize() == 0)
{
pool.initializePool();
}
Connection con = null;
Statement stmt = null;
ResultSet rs=null;
con = pool.getConnection();
stmt= con.createStatement();
//建立Statement对象, 并设置记录指标类型为可前后移动
String sql=null;
//利用For循环配合PageSize属性输出一页中的记录
sql="select code,name,duty,address,telephone from user";
rs = stmt.executeQuery(sql);
%>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=700>
<tr>
<td colspan="5" align="center" width="700">
<font size="5pt" face="隶书">系统注册人员名单</font>
</td>
</tr>
<tr>
<td width="100" align="center">姓 名</td>
<td width="100" align="center">职 务</td>
<td width="300" align="center">联系地址</td>
<td width="100" align="center">联系电话</td>
<td width="100" align="center">删 除</td>
</tr>
<%
while(rs.next())
{
String meeting_code=rs.getString("code");
String meeting_name=rs.getString("name");
String meeting_duty=rs.getString("duty");
String meeting_address=rs.getString("address");
String meeting_tel=rs.getString("telephone");
%>
<tr>
<td width="100" align="center"><%=meeting_name%></td>
<td width="100" align="center"><%=meeting_duty%></td>
<td width="300" align="center"><%=meeting_address%></td>
<td width="100" align="center"><%=meeting_tel%></td>
<td width="100" align="center">
<a href="manager_user_delete.jsp?code=<%=meeting_code%>">
删除
</a>
</td>
</tr>
<%
}
%>
</TABLE>
<br>
<a href="default.jsp">返回首页</a>
</CENTER>
<%
if (rs != null) rs.close();
pool.releaseConnection(con);
}
catch(Exception e)
{
System.out.println("Exception: " + e.getMessage());
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -