81,092
社区成员
发帖
与我相关
我的任务
分享
<%! int currentPage = 1; String sql;%>
<% String sql1 = request.getParameter("sql");
if(sql1 != null)
sql = sql1;
String pageIndex = request.getParameter("page");
if (pageIndex != null && !pageIndex.equals("")) {
currentPage = Integer.parseInt(pageIndex);
} else {
currentPage = 1;
}
%>
<table width="100%" align="center" bgcolor="#66CCFF" cellspacing="1">
<tr>
<td align="center" colspan="8"><h3>书籍管理</h3></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" width="45">编号</td>
<td align="center">书名</td>
<td align="center">价格</td>
<td align="center">类型</td>
<td align="center">出版商</td>
<td align="center">描述</td>
<td align="center">上架日期</td>
<td align="center">销售量</td>
<td align="center">销售状态</td>
<td align="center" width="90">操作</td>
</tr>
<% dao.setSql(sql);
List list = dao.getBooksList(currentPage);
for (Object obj : list) {
BookBean bean = (BookBean) obj;%>
<tr bgcolor="#FFFFFF">
<td align="center"><%=bean.getBookID()%></td>
<td><%=bean.getBookName() %></td>
<td><%=bean.getPrice()%></td>
<td><%=bean.getType()%></td>
<td><%=bean.getPublisher() %></td>
<td><%=bean.getBookDesc()%></td>
<td><%=bean.getOnsaleDate()%></td>
<td><%=bean.getBuyCount()%></td>
<td><%=bean.getOnsales()%></td>
<td align="center">
<a href="bookinfo.jsp?id=<%=bean.getBookID()%>&page=<%=currentPage%>">详细</a> |
<% if(bean.getOnsales().equals("销售中")){
out.println("<a href=\"../servlet/ChangeSalesStatusServlet?bookid="+bean.getBookID()+"&page="+currentPage+"\">停售</a>");
}else{
out.println("<a href=\"../servlet/ChangeSalesStatusServlet?bookid="+bean.getBookID()+"&page="+currentPage+"\">上架</a>");
}
%>
</td>
</tr>
<% }
%>
<tr bgcolor="#FFFFFF">
<td colspan="10" align="right">
共有 <%=dao.getCount()%> 条记录 共有 <%=dao.getPageCount()%> 页 当前第 <%=currentPage%> 页
<%
if (currentPage == 1) {
out.println(" [首页] ");
out.println(" [上一页] ");
} else {
out.println("<a href=\"managebook.jsp\">[首页]</a>");
out.println("<a href=\"managebook.jsp?page=" + (currentPage - 1) + "\">[上一页]</a>");
}
if (currentPage == dao.getPageCount()) {
out.println(" [下一页] ");
out.println(" [末页] ");
} else {
out.println("<a href=\"managebook.jsp?page=" + (currentPage + 1) + "\">[下一页]</a>");
out.println("<a href=\"managebook.jsp?page=" + dao.getPageCount() + "\"> [末页] </a>");
}
%>
</td>
</tr>
</table>