showsalestatistics.jsp

java开发的在线CD销售系统。开发环境 MyＥclipse+Tomat+SQL Server2000

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

<%@ page import="java.util.*" %>
<%@ page import="cdshop.cd.order" %>
<%@ page import="cdshop.cd.*"%>
<%@ page import="cdshop.util.dataFormat"%>
<jsp:useBean id="cd_list" scope="page" class="cdshop.run.op_cd" />
<jsp:useBean id="classlist" scope="page" class="cdshop.run.op_cdclass" />
<jsp:useBean id="sale" scope="page" class="cdshop.run.op_sale_statistics" />

<%
String mesg = "";
ArrayList al=new ArrayList();

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/adm_head.inc"%>
<tr>
      <td align="center">
  <!--      <p><br><font color="#33FFCC"><b><font color="#0000FF">CD销售统计</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>CD名称</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>
        -->
        <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">CD销售统计</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>CD名称</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>
        </td>
</tr>

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