留言管理

<%@ page contentType="text/html; charset=gb2312" %> <%@ page import="java.util.Iterator"%> <%@ page import="java.util.Collection"%> <%@ page import="java.sql.*"%> <%@ page import="java.text.SimpleDateFormat"%> <%@ page import="electric.dbs.Dbmess"%> <%@ page import="electric.dbs.Messdb"%> <%@ page import="electric.dbs.mess"%> <%@ page import="electric.dbs.Dbshop"%> <%@ page import="electric.dbs.Shopdb"%> <%@ page import="electric.dbs.shop"%> <%@ page import="electric.electricUtils.ParamUtils"%> <%@ page import="electric.electricUtils.DbConnectionManager"%> <% Messdb mess=new Messdb(); int countpage=mess.selectsql(5); shop pt=(shop)session.getAttribute("USERPO"); if(pt==null) { response.sendRedirect("login.jsp"); } %> 留言管理

<% int pa=ParamUtils.getIntParameter(request,"pa",1); int spa=pa-1; if(spa<1) { spa=1; } int xpa=pa+1; if(xpa>countpage) { xpa=countpage; } Messdb messdb=new Messdb(); Collection coll=messdb.select(5,pa); if (coll == null || coll.isEmpty()) { System.out.println("coll is null"); }else { Iterator it = coll.iterator(); while (it.hasNext()) { mess b2 = (mess) it.next(); %> <% } } %>

发布时间	姓名	留言	删除
<%=b2.getCreateDate().substring(0,4)%>年<%=b2.getCreateDate().substring(4,6)%>月<%=b2.getCreateDate().substring(6,8)%>日	<%=b2.getMname()%>	<%=b2.getMtext()%>

<%if(pa>1){%> 第一页上一页 <%} if(pa 下一页最后一页 <%}%>