showsalestatistics.jsp

基于JSP的网上书店.功能较为全面 开发环境:sql server2000+tomcat+jdk

<%@ page contentType="text/html;charset=gb2312" %> 
<%@ page session="true" %>

<%@ page import="java.util.*" %>
<%@ page import="bookshop.book.order" %>
<%@ page import="bookshop.book.*"%>
<%@ page import="bookshop.util.dataFormat"%>
<jsp:useBean id="book_list" scope="page" class="bookshop.run.op_book" />
<jsp:useBean id="classlist" scope="page" class="bookshop.run.op_bookclass" />
<jsp:useBean id="sale" scope="page" class="bookshop.run.op_sale_statistics" />

<%
String mesg = "";
ArrayList al=new ArrayList();
String Uid = (String) session.getAttribute("userid");
if(Uid==null||Uid.equals(""))
{
   response.sendRedirect("login.jsp?msg=nologin");
}
long uid = 0;
try {

	al=sale.getSaleNumOrder( request.getParameter("classid"),request.getParameter("keyword"));
} catch (Exception e) {
	mesg = "出现不可预知错误!";
}
%>


<script language="javascript">
function openScript(url,name, width, height){
	var Win = window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script>
<%@include file="inc/head.inc"%>
<%@include file="inc/sub.inc"%>
<table width="778">
  <tr>
     <td width="150" align="center">
     <%@include file="inc/left3.inc"%>
     </td>
     
      <td align="center">
        <p><br><font color="#33FFCC"><b><font color="#0000FF">图书销售统计</font></b></font></p>
<%if (!mesg.equals("")) {
		out.println("<p><font color=red>" + mesg + "</font></p>");
} else {   %>
        <table width="80%" border="1" cellspacing="2" cellpadding="1" bordercolor="white">
          <tr align="center" bgcolor="#DEF3CE">
            <td>图书名称</td>
            <td>销售数量</td>
          </tr>
	<%for (int i = 0; i<al.size();i++){
		String []result = (String [])al.get(i);
			%>
          <tr>
            <td><font color=red><%=dataFormat.toString(result[0]) %></font></td>
            <td align="center"><%= result[1] %></td>

          </tr>
		<%}%>
        </table>
<%} %>
        <p>&nbsp;</p>
        </td>
   </tr>
 </table>

<%@include file="inc/tail.inc"%>