salestatexcelservlet.java

网上商城代码

package com.fendou.manage.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

import com.fendou.dao.GoodsManage;
import com.fendou.exception.GoodsException;
import com.fendou.vo.GoodsStat;

public class SaleStatExcelServlet extends HttpServlet {

	public SaleStatExcelServlet() {
		super();
	}

	public void destroy() {
		super.destroy(); 
	}

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request,response);
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String filename="salestat.xls";
		response.setCharacterEncoding("UTF-8");
		filename=java.net.URLEncoder.encode(filename,"UTF-8");
		response.setHeader("Content-Disposition", "attachment;filename="+filename);
        response.setContentType("application/vnd.ms-excel");
		GoodsManage goodsManage=new GoodsManage();
		List<GoodsStat> list;
		try {
			list = goodsManage.statGoods(null, null, "2009-3-1","2009-3-2");			
			if(null!=list){
				WritableWorkbook workbook =Workbook.createWorkbook(response.getOutputStream());
				WritableSheet sheet =workbook.createSheet("SaleStat", 0);				
				WritableFont wf = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, true);
		        WritableCellFormat wcfF = new WritableCellFormat(wf);
		        Label label=null;
		        try {
			        label=new Label(0,0,"商品名称",wcfF);
					sheet.addCell(label);
					label=new Label(1,0,"价格",wcfF);
		        	sheet.addCell(label);
		        	label=new Label(2,0,"数量",wcfF);
		        	sheet.addCell(label);
			        for(int i=0;i<list.size();i++){
			        	GoodsStat goods=(GoodsStat)list.get(i);	 
		        		label=new Label(0,i+1,goods.getGoodsName(),wcfF);
						sheet.addCell(label);
						label=new Label(1,i+1,String.valueOf(goods.getSaleAmount()),wcfF);
			        	sheet.addCell(label);
			        	label=new Label(2,i+1,String.valueOf(goods.getSaleCount()),wcfF);
			        	sheet.addCell(label);						            
			        }
			        workbook.write();
			        workbook.close();
			        
		        } catch (RowsExceededException e) {
					e.printStackTrace();
				} catch (WriteException e) {
					e.printStackTrace();
				}	
			}
		} catch (GoodsException e) {
			System.out.println(e);
			request.getRequestDispatcher("error.jsp").forward(request, response);
		}
		
		
	}

	
	public void init() throws ServletException {
		
	}

}