📄 friendadmin.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%
String id=(String)session.getAttribute("id");id=ht.donull(id);
String sql;
ResultSet rs;
if(id.compareTo("")==0){
response.sendRedirect("login.jsp");
}else{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>好友管理</title>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
td{font-size:13px}
th{font-size:13px}
a:link{text-decoration:none;color:#0000ff}
a:visited{text-decoration:none;color:#0000ff}
a:hover{text-decoration:none;color:#ff0000}
body {
margin-top: 3px;
}
-->
</style>
</head>
<body>
<table width="720" border="0" align="center" cellspacing="1" bgcolor="#f1f1f1">
<tr>
<td bgcolor="#ffffff"><div align="right"> [<a href="index.html" target="_parent">论坛首页</a>] [<font color="#FF0000">好友管理</font>] </div></td>
</tr>
<tr>
<td bgcolor="#ffffff"> </td>
</tr>
<tr>
<td><strong> 我的好友</strong></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellspacing="1" bgcolor="#aaaaaa">
<tr bgcolor="#7188e0">
<th class="style1">好友</th>
<th class="style1">发留言</th>
<th class="style1">送礼物</th>
<th class="style1">删除</th>
</tr>
<%
sql="select id,friendid,friendname from friend where userid='"+id+"' and isfriend='y'";
rs=con.query(sql);
while(rs.next()){ %>
<tr bgcolor="#f8f8f8">
<td><div align="center"><a href="aboutuser.jsp?id=<%=rs.getString(2)%>"><%=con.getStr(rs.getString(3))%></a></div></td>
<td><div align="center"><a href="massage/msend.jsp?id=<%=rs.getString(2)%>">发送</a></div></td>
<td><div align="center">发送</div></td>
<td><div align="center"><a href="action/delfriend.jsp?id=<%=rs.getString(1)%>"><font color="#FF0000">删除</font></a></div></td>
</tr>
<% }con.close();
%>
</table></td>
</tr>
<tr>
<td bgcolor="#ffffff"> </td>
</tr>
<tr>
<td><strong> 黑名单</strong></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellspacing="1" bgcolor="#aaaaaa">
<tr bgcolor="#7188e0">
<th width="20%" class="style1">会员</th>
<th> </th>
<th width="20%" class="style1">删除</th>
</tr><%
sql="select id,friendid,friendname from friend where userid='"+id+"' and isfriend='n'";
rs=con.query(sql);
while(rs.next()){ %>
<tr bgcolor="#f8f8f8">
<td class="style1"><div align="center"><a href="aboutuser.jsp?id=<%=rs.getString(2)%>"><%=con.getStr(rs.getString(3))%></a></div></td>
<td> </td>
<td class="style1"><div align="center"><a href="action/delfriend.jsp?id=<%=rs.getString(1)%>"><font color="#FF0000">删除</font></a></div></td>
</tr> <% }con.close();
%>
</table></td>
</tr>
<tr>
<td bgcolor="#ffffff"> </td>
</tr>
<tr>
<td><strong> 加我为好友者</strong></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellspacing="1" bgcolor="#aaaaaa">
<tr bgcolor="#7188e0">
<th width="20%" class="style1">会员</th>
<th width="20%" class="style1">发留言</th>
<th width="20%" class="style1">送礼物</th>
<th width="20%" class="style1">加为好友</th>
<th width="20%" class="style1">黑名单</th>
</tr><%
sql="select id,userid,username from friend where friendid='"+id+"' and isfriend='y'";
rs=con.query(sql);
while(rs.next()){ %>
<tr bgcolor="#f8f8f8">
<td><div align="center"><a href="aboutuser.jsp?id=<%=rs.getString(2)%>"><%=con.getStr(rs.getString(3))%></a></div></td>
<td><div align="center"><a href="massage/msend.jsp?id=<%=rs.getString(2)%>">发送</a></div></td>
<td><div align="center">发送</div></td>
<td><div align="center">加入</div></td>
<td><div align="center">加入</div></td>
</tr><% }con.close();
%>
</table></td>
</tr>
</table>
</body>
</html>
<%
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -