📄 diarys.jsp

📁 仿校内网站

💻 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>
<%
	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 * from diary where diarymaker_id = " + user_id;
    rs = db.executeQuery(sql);
    %>
<form>
    <div id="diarys">
        <div id="diaryshead" align=""><strong>日志列表</strong></div>
        <%
        while(rs.next()){
            String diary_id = rs.getString(1);
            String diarymaker_id = rs.getString(2);
            String diary_title = rs.getString(3);
            String diary_date = rs.getString(4).substring(0, 16);
            String diary_content = rs.getString(5);
            String comments_account = rs.getString(6);
            String visit_account = rs.getString(7);
            if(diary_content.length()>200){
                diary_content = diary_content.substring(0, 199);
            }
        %>
        <div class="diary">
            <hr>
            <div class="diarytitle"><%=diary_title%></div>
            <div class="diarybody">
                <div><%=diary_content%></div>
                <div clas="diarycontinue" align="right"><a href="diary.jsp?diary_id=<%=diary_id%>">&gt;&gt;继续阅读</a></div>
            </div>
            <div>浏览(<%=visit_account%>)&nbsp;评论(<%=comments_account%>)</div>
        </div>
        <%
        }
        %>
    </div>
</form>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -