📄 totalbook.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,bean.DBClass" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><html><!-- DW6 --><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>销售排行</title><link href="source/bookshop.css" rel="stylesheet" type="text/css"></head><% if(session.getAttribute("adminId")==null) { %><jsp:forward page="/notLogin.jsp" /><% } else { %><body> <div id="masthead"><jsp:include page="/utility/siteName.jsp" /><jsp:include page="/utility/bar.jsp" /></div> <div id="pagecell1"> <div id="breadCrumb"> <table width="100%" border="0"> <tr> <% String requestURL= request.getRequestURI(); String param=request.getQueryString(); String hidAddr="/bookshop/MenuHidden?jspURL=" + requestURL +"¶m="+ param ; String showAddr="/bookshop/MenuShow?jspURL=" + requestURL +"¶m="+ param ; %> <td width="211"><a href=<%= hidAddr %> align="left">隐藏</a> / <a href=<%= showAddr %>>显示</a> </td> <td width="516"></td> </tr> </table> </div> <table width="100%" border="0"> <tr valign="top"> <% if(session.getAttribute("hidden")==null){ %> <jsp:include page="/utility/adminMenu.jsp" /> <% } %> <td width="81%" > <div class="book"> <table width="100%" border="0" > <tr> <td background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td> </tr> <tr> <td height="11" bgcolor="#FFFFFF" > <table width="100%" border="0" > <tr> <td width="20%"><div align="center">书ID</div></td> <td width="20%"><div align="center">书名</div></td> <td width="20%"><div align="center">总数量</div></td> <td width="20%"><div align="center">总金额</div></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <% String pg=""; if(request.getParameter("pg")==null){ pg="1"; }else{ pg=request.getParameter("pg"); } int index=(Integer.parseInt(pg)-1)*30; String query=" select count(book) t,book,sum(convert(int,sum)) s from orderlist o group by book order by s desc"; DBClass db=new DBClass(); db.connect(); ResultSet resultset=db.executeQuery(query); for(int i=0;i<index;i++){ resultset.next(); } int n=0; while(resultset.next()&&n<30){ n++; DBClass db1=new DBClass(); db1.connect(); String id=resultset.getString("book"); ResultSet resultset2=db1.executeQuery("select * from book where id="+id); resultset2.next(); float money = resultset2.getFloat("price"); String s=resultset.getString("s");%> <tr> <td ><div align="center"><%= id %></div></td> <td ><div align="center"><div align="center"><%= resultset2.getString("name") %></div></td> <td><div align="center"><%= resultset.getInt("s") %></div></td> <td><div align="center">¥<%= resultset.getInt("s")*money %></div></td> </tr> <% db1.closeConnection(); } %> </table> </td> </tr> <tr> <td height="5" background="source/glbnav_background.gif" bgcolor="#FFFFFF" > </td> </tr> </table> </div> <table width="100%" border="0"> <tr> <td> <% String pre="/bookshop/totalbook.jsp?pg="+Integer.toString(index/30); String aft="/bookshop/totalbook.jsp?pg="+Integer.toString(index/30+2); if(pg.equals("1")){ if(resultset.next()){ %> <div align="right">上一页/<a href=<%= aft %>>下一页</a></div> <% }else{ %> <div align="right">上一页/下一页</div> <% } } else { if(resultset.next()){ %> <div align="right"><a href=<%= pre %>>上一页</a>/<a href=<%= aft %>>下一页</a></div> <% } else { %> <div align="right"><a href=<%= pre %>>上一页</a>/下一页</div> <% } } db.closeConnection(); %> </td> </tr> </table> <p> </p> </td> </tr></table><jsp:include page="/utility/copyRight.jsp" /></div> <!--end pagecell1--> <br> </body><% } %></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -