📄 browse.jsp~1~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>浏览图片</title> <style type="text/css"><!--body { background-color: #FFFFCC;}.style1 {font-size: 12px}.style2 { font-size: 16px; color: #FF0000;}--></style></head> <body> <jsp:useBean id="dbconn" class="org.DBConnection" scope="page"></jsp:useBean> <p align="center" class="style2">点击图片可以查看大图并对图片发表评论</p><table width="100" height="100" border="0" align="center"> <tr> <%Connection conn=dbconn.getConnection();Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);String sql="select * from pictures";ResultSet rs=stmt.executeQuery(sql);int k=0; while(rs.next()){ // int j=rs.getRow(); int i=rs.getInt("picture_id"); String title=rs.getString("picture_title"); if(k%2==0) out.println("</tr>"); %><td> <table width="333" height="213" border="0"> <tr> <td height="26" colspan="2">标题：<%=title%></td> </tr> <tr> <td width="139" height="150" rowspan="2"><a href="pic_detail.jsp?picture_id=<%=i%>"><img src="pic_show.jsp?picture_id=<%=i%>" width="130" height="150" border="0"></a></td> <td width="178" height="60"> </td> </tr> <tr> <td height="60"><p>上传时间：<%=rs.getString("upload_time")%></p> <p>上传用户：<%=rs.getString("user_name")%></p></td> </tr> </table> </td> <% k++; }%></table> <% rs.close(); stmt.close(); conn.close(); %> </body> </html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -