📄 paihang.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>
<body>
<div id="masthead">
<jsp:include page="/utility/siteName.jsp" />
<jsp:include page="/utility/navigation.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">
<td width="100%" >
<div class="book">
<table width="100%" border="0" >
<tr>
<td width＝"20%" > </td>
</tr>
<tr>
<td height="11" bgcolor="#FFFFFF" >
<table width="100%" border="0" background="source/019.jpg" >
<tr>
<td width="15%"><div align="center">书ID</div></td>
<td width="15%"><div align="center">书名</div></td>
<td width="15%"><div align="center">作者</div></td>
<td width="15%"><div align="center">价格</div></td>
<td width="15%"><div align="center">总数量</div></td>
<td width="15%"><div align="center">总金额</div></td>
</tr>
<tr>
<td colspan="6"><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"><%= resultset2.getString("author") %></div></td>
<td><div align="center"><%= resultset2.getString("price") %></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/paihang.jsp?pg="+Integer.toString(index/30);
String aft="/bookshop/paihang.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>
</div>
<!--end pagecell1-->
<br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -