?? 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 + -