messages.jsp

来自「仿校内网站」· JSP 代码 · 共 57 行

JSP
57
字号
<%@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>&nbsp;&nbsp;
                            <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 + =
减小字号Ctrl + -
显示快捷键?