📄 messages.jsp
字号:
<%@page contentType="text/html" pageEncoding="GB2312"%>
<%@ page import="myTools.DataBase" %>
<%@ page import="java.sql.*"%>
<!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>
<form>
<div id="messages">
<div class="messageshead" align="left">
留言列表
</div>
<hr>
<%
String be_visited_id = (String)session.getAttribute("be_visited_id");
System.out.println("I in messages, where be_visited_id = " + be_visited_id);
String idString = be_visited_id;
DataBase db = new DataBase();
ResultSet rs = null;
db.connectToDB();
rs = db.executeQuery("select visitor_id, message_content, message_date, message_id, photo_path, user_name from messages m, users u where m.host_id = " + idString + " and m.visitor_id = u.user_id order by m.message_date desc");
while (rs.next()) {
String visitor_id = rs.getString(1);
String content = rs.getString(2);
String time = rs.getString(3).substring(0, 16);
String message_id = rs.getString(4);
String visitor_picture_path = rs.getString(5);
String user_name = rs.getString(6);
%>
<div >
<div style="float:left;">
<img style="max-height:70px;" src="<%=visitor_picture_path%>"></img>
</div>
<div style="min-height:80px;">
<div>
<div style="margin-left:10px;float:left; width:200px;text-align:left;">
<a target="home" href="homepage.jsp?be_visited_id=<%=visitor_id%>"><%=user_name%></a>
</div>
<div style="float:left; width:150px;text-align:right;"><%=time%></div>
<div style="width:100px; text-align:right;">
<a href="MessageServlet?operation=delete&message_id=<%=message_id%>">删除</a>
<a href="response.jsp?message_id=<%=message_id%>">回复</a>
</div>
</div>
<div style="text-align:left; margin-left:10px;margin-top:5px;"><%=content%></div>
</div>
</div>
<hr>
<%
}
db.close();
%>
</div>
</form>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -