📄 del_comment.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}--></style></head><body><jsp:useBean id="dbconn" scope="page" class="org.DBConnection"/> <% Connection conn=dbconn.getConnection(); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql="select * from comments"; ResultSet rs=stmt.executeQuery(sql); rs.last(); int rowcount=rs.getRow();%><p align="center" style="font-size:24px; color: #FF0000;">共有<%=rowcount%>条评论</p><table width="605" border="1" align="center" bordercolor="#FFCC99"> <tr> <td width="120"><div align="center"><span class="style1">评论id</span></div></td> <td width="120"><div align="center"><span class="style1">发表人</span></div></td> <td width="120"><div align="center"><span class="style1">图片id</span></div></td> <td width="120"><div align="center"><span class="style1">操作</span></div></td> <td width="120"><div align="center"><span class="style1">操作</span></div></td> </tr> <% rs.beforeFirst(); while(rs.next()) { int i=rs.getInt("comment_id"); String user_name=rs.getString("user_name"); String picture_id=rs.getString("picture_id");%><tr> <td><%=i%></td> <td><%=user_name%></td> <td><%=picture_id%></td> <td><a href="delcomm_ok.jsp?comment_id=<%=i%>">删除</a></td> <td><a href="comm_content.jsp?comment_id=<%=i%>">查看</a></td> </tr> <%}%> <% rs.close(); stmt.close(); conn.close(); %></table><p align="center" class="style1"><a href="admin.jsp">返回管理页面</a></p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -