op_sale_statistics.java~6~

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

package bookshop.run;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import bookshop.util.*;
public class op_sale_statistics extends DataBase {

  ArrayList al=new ArrayList();

  public op_sale_statistics() {
  }


  public ArrayList getSaleNumOrder()
  {
    String sql="select top 100 book.bookname bookname,sum(allorder.amount) num from allorder,book "+
               " where allorder.bookno=book.id "+
               " group by bookname "+
               " order by num desc";
           try{
                  DataBase db = new DataBase();
                  db.connect();
                  stmt = db.conn.createStatement ();
                  rs=stmt.executeQuery(sql);
                  while (rs.next())
                  {
                    String [] result=new String[2];
                    result[0]=rs.getString("bookname");
                    result[1]=rs.getString("num");
                    al.add(result);
                  }
                  return al;
             } catch (Exception e){
               System.out.println(e.getMessage());
              return null;

             }

  }

}