📄 alluser.jsp
字号:
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@include file="top.jsp" %>
<%@include file="conn.jsp" %>
<%
String sql1="select * from icefish_user";
Statement stmt1=conn.createStatement();
ResultSet rs1=stmt1.executeQuery(sql1);
%>
<html>
<head>
<title></title>
</head>
<body topmargin="0">
<img src="images/user/4.gif" align="left" height="330" width="235">
<table width="720" border="1" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr>
<td width="25%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">用户名</p></td>
<td width="25%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">用户等级</p></td>
<td width="50%" height="25" background="images/skin/1/bg_td.gif"><b><font color="#ffffff">
<p align="center">个性签名</p></td>
</font></b></tr>
<%while(rs1.next()){
String user_id=rs1.getString("user_id");
%>
<table width="720" border="1" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr bgcolor="#f3f3f3">
<td height="25" width=25%><b><font color="#ffffff"> <img src="images/skin/1/nofollow.gif">
<a class=zh href="oneuser.jsp?user_id=<%=rs1.getString("user_id")%>"><%=rs1.getString("user_name")%></a> </td>
<td height="25" width=25%><b><font color="#ffffff"> <img src="images/skin/1/nofollow.gif">
<a class=zh href="oneuser.jsp?user_id=<%=rs1.getString("user_id")%>"><%=rs1.getString("user_grade")%></a> </td>
<td height="25" width=50%><b><font color="#ffffff"> <img src="images/skin/1/nofollow.gif">
<a class=zh href="oneuser.jsp?user_id=<%=rs1.getString("user_id")%>"><%=rs1.getString("user_sign")%></a> </td>
</tr>
<%}
rs1.close();
stmt1.close();
conn.close();
%>
<tr bgcolor="#dff2ed">
<td height="25" colspan="3" bgcolor="#f3f3f3"><b><font color="#000000"><p align="right">点击查看用户信息</p></font></td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -