📄 friends.jsp
字号:
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="myTools.DataBase" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*" %>
<%@ page import="myTools.TimeMaker" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<link href="css.css" rel="stylesheet" type="text/css" media="all" />
<title>个人空间--好友列表</title>
<%
String be_visited_id = (String)session.getAttribute("be_visited_id");
String user_id = be_visited_id;
DataBase db = new DataBase();
ResultSet rs = null;
db.connectToDB();
String sql = "select friends from users where user_id = " + user_id;
rs = db.executeQuery(sql);
ArrayList<String> friends = null;
if(rs.next()){
friends = TimeMaker.getFriends(rs.getString(1));
}
if(friends.size() == 0){
}else{
sql = "select user_id, user_name, photo_path, visitor_count from users where user_id in (";
for(int i=1; i<friends.size(); i++){
sql += friends.get(i) + ", ";
}
sql += (friends.get(0) + ")");
rs = db.executeQuery(sql);
}
%>
<form>
<div id="friends">
<div class="friendshead" align="left">
好友列表
</div>
<%
if(friends.size() != 0){
while(rs.next()){
String friend_id = rs.getString(1);
String friend_name = rs.getString(2);
String photo_path = rs.getString(3);
String visitor_count = rs.getString(4);
%>
<hr>
<div>
<div style="float:left;">
<img style="max-height:70px;" src="<%=photo_path%>"></img>
</div>
<div style="min-height:80px;">
<div style="float:left;"><%=friend_name%></div>
<div><a href="#">给TA留言</a> <a target="home" href="homepage.jsp?be_visited_id=<%=friend_id%>">进去看看</a></div>
</div>
</div>
<%
}
}
%>
</div>
</form>
<%
db.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -