📄 albums.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;

%>
<form>
    <div id="albums">
        <div class="albumshead" align="left">
            你的相册列表　　　　　　　　　<a href="addAlbum.jsp?user_id=<%=user_id%>">新建一个相册</a>
        </div>
        <hr>
        <div id="albumsbody">
            <%
            DataBase db = new DataBase();
            ResultSet rs = null;
            db.connectToDB();
            String sql = "select user_id, album_id, album_name from albums a where a.user_id = " + user_id;
            rs = db.executeQuery(sql);
            while(rs.next()){
                String use_id = rs.getString(1);
                String album_id = rs.getString(2);
                String  album_name = rs.getString(3);
                DataBase db1 = new DataBase();
                ResultSet rs1 = null;
                db1.connectToDB();
                String sql1 = "select photo_path from photos where album_id = " + album_id + " limit 1";
                rs1 = db1.executeQuery(sql1);
                String photo_path = "";
                if(rs1.next()){
                    photo_path = rs1.getString(1);
                }else{
                    photo_path = "photoes/no.jpg";
                }
            %>
            <div>
                <div class="album">
                    <div class="album_name"><a href="photoes.jsp?album_id=<%=album_id%>"><%=album_name%></a></div>
                    <div align="center">
                        <img class="photo_shortcut_format" src="<%=photo_path%>"></img>
                    </div>
                </div>
                <%
                if(rs.next()){
                    use_id = rs.getString(1);
                    album_id = rs.getString(2);
                    album_name = rs.getString(3);
                    sql1 = "select photo_path from photos where album_id = " + album_id + " limit 1";
                    rs1 = db1.executeQuery(sql1);
                    if(rs1.next()){
                        photo_path = rs1.getString(1);
                    }else{
                        photo_path = "photoes/no.jpg";
                    }
                %>
                <div class="album">
                    <a href="photoes.jsp?album_id=<%=album_id%>"><%=album_name%></a>
                    <div align="center">
                        <img class="photo_shortcut_format" src="<%=photo_path%>"></img>
                    </div>
                </div>
                <%
                }
                %>
            </div>
            <%
            }
            db.close();
            %>
        </div>
    </div>
</form>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -