📄 pic_detail.jsp~2~
字号:
<%@ 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"><!--.style1{font-size: 12px}--></style></head><body><jsp:useBean id="format" scope="page" class="photo.StrFormat"/><jsp:useBean id="dbconn" scope="page" class="photo.DBConnection"/><p> <%try{int i=Integer.parseInt(request.getParameter("picture_id"));//request.setCharacterEncoding("GBK");//String picture_title=format.StrFormat(request.getParameter("picture_title"));Connection conn=dbconn.getConnection();String sql1="select * from pictures where picture_id="+i;Statement stmt1 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);ResultSet rs1=stmt1.executeQuery(sql1);if(rs1.next())%></p><table width="100%" border="1"> <tr> <td height="30">标题:<%=rs1.getString("picture_title")%></td> </tr> <tr> <td><img alt="" src="pic_show.jsp?picture_id=<%=i%>"></td> </tr></table><p> <%Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql="select * from comments where picture_id="+i;ResultSet rs=stmt.executeQuery(sql); while(rs.next()){ %></p><p><span class="style1">评论内容：</span></p><p><%=rs.getString("content")%></p><p> <span class="style1">发表人：</span><%=rs.getString("user_name")%> <span class="style1"> 发表时间</span>：<%=rs.getString("comment_time")%></p><hr><%}%><form name="form1" method="post" action="add_comments.jsp"> <p>发表评论： </p> <p> <textarea name="content" rows="10" cols="90"></textarea> </p> <p> <input type="hidden" name="picture_id" value="<%=i%>"></p> <p> <input type="submit" name="Submit" value="发表"> <input type="reset" name="Submit2" value="重写"></p></form><p align="center" class="style411"><a href="browse.jsp">返回</a></p></body><%rs1.close();stmt1.close();rs.close();stmt.close();conn.close();}catch(Exception e){e.printStackTrace();}%></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -