WebRoot/pinglun/pinglunlist.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
DBO db=new DBO();
request.setCharacterEncoding("gb2312");
ResultSet rs=null;
String sql="";
%><html>
<head>
<LINK href="../css/admin.css" type="text/css" rel="stylesheet"><style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
	background-color: #EEF2FB;
}
a:hover{
color:#FF0000;
text-decoration:underline;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>评论</title>
<body>
<%
sql="select * from pinglun";
rs=db.query(sql);
%>
<br>
<br>
<div align="center">
  <h3>评论列表</h3></div>
<hr width=80% color=#880000>
<table width="98%" border=1 style="border-collapse: collapse; border-style: dotted; border-width: 1px"  bordercolor="#999999" cellspacing="1" cellpadding="1">
<tr>
<td>序号</td>
<td>评论编号</td>
<td>汽车</td>
<td>评论</td>
<td>用户</td>
<td>时间</td>
<td>操作</td></tr>
<%
int i=1;
while(rs.next()){
%>
<tr>
<td><%=i%></td>
<td><%=rs.getString("plid")%></td>
<td><%=rs.getString("qc")%></td>
<td><%=rs.getString("pl")%></td>
<td><%=rs.getString("yh")%></td>
<td><%=rs.getString("sj")%></td>
<td><a href="pinglundelete.jsp?keyid=<%=rs.getString("plid")%>" onClick="javascript:if(confirm('是否删除')){return true;} else{return false;}">删除</a>|<a href="pinglundetail.jsp?keyid=<%=rs.getString("plid")%>">查看</a></td>
</tr>
<%
i++;