📄 photoes.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 album_id = request.getParameter("album_id"); if (album_id == null) { album_id = "1"; } DataBase db = new DataBase(); ResultSet rs = null; db.connectToDB(); String sql = "select album_name, album_number from albums where album_id = " + album_id; rs = db.executeQuery(sql); String album_name = "出错了"; String album_number = "0"; if (rs.next()) { album_name = rs.getString(1); album_number = rs.getString(2); }%><form action="AlbumServlet?operation=add_photoes" method="post" enctype="multipart/form-data"> <div id="photoes"> <div class="photoeshead" align="left"> 相册 >> <%=album_name%> <label>有<%=album_number%>张相片</label> </div> <hr> <div id="photoesbody"> <% sql = "select photo_id, photo_date, photo_description, visit_account, photo_path from photos where album_id = " + album_id; rs = db.executeQuery(sql); while (rs.next()) { String photo_id = rs.getString(1); String photo_date = rs.getString(2); String photo_description = rs.getString(3); String visit_account = rs.getString(4); String photo_path = rs.getString(5); %> <div> <div class="photo"> <a href="photo.jsp?photo_id=<%=photo_id%>">进入查看</a> <a href="AlbumServlet?operation=delete_photo&photo_id=<%=photo_id%>&album_id=<%=album_id%>&album_number=<%=album_number%>">删除相片</a> <div align="center"> <img class="photo_shortcut_format" src="<%=photo_path%>"></img> </div> </div> <% if (rs.next()) { photo_id = rs.getString(1); photo_date = rs.getString(2); photo_description = rs.getString(3); visit_account = rs.getString(4); photo_path = rs.getString(5); %> <div class="photo"> <a href="photo.jsp?photo_id=<%=photo_id%>">进入查看</a> <a href="AlbumServlet?operation=delete_photo&photo_id=<%=photo_id%>&album_id=<%=album_id%>&album_number=<%=album_number%>">删除相片</a> <div align="center"> <img class="photo_shortcut_format" src="<%=photo_path%>"></img> </div> </div> <% } %> </div> <% } %> </div> </div> <table width="500" height="200" border="0"> <div>添加新的相片</div> <tr> <td align="right" valign="middle"> 相片描述: </td> <td align="left"> <textarea name="photo_description" cols="60" rows="5"></textarea> </td> </tr> <tr> <td height="39" align="right" valign="middle"> 图片： </td> <td> <label> <div id="resource"> <div align="left"> <input type="file" name="file" /> <script> function add() { str="<br><input type='file' name='file'>"; resource.insertAdjacentHTML("beforeEnd",str); } </script> <input type="hidden" name="album_id" value="<%=album_id%>"></input> <input type="hidden" name="album_number" value="<%=album_number%>"></input> <input type="button" class="btn2" onClick="add();" value="增加相片" /> </div> </div> </label> </td> </tr> <tr> <td height="39" align="right" valign="middle"> <input type="submit" name="Submit" value="添加"> </td> <td align="left" valign="middle"></td> </tr> </table></form><%db.close();%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -