exceloutputservlet.java

关于学校管理

package student.manage.excelOutput;

import java.io.DataInputStream;
import java.io.IOException;
import java.io.OutputStream;

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

import student.manage.mark.SuperBean;

@SuppressWarnings("serial")
public class ExcelOutputServlet extends HttpServlet{
	

	
	public SuperBean requestPageForm (HttpServletRequest request,HttpServletResponse response) throws ServletException {
		String fileName = request.getParameter("fileName");
		String titles = request.getParameter("titles");
		String[] datas = request.getParameterValues("datas");
		String sheetNme = request.getParameter("sheetNme");
		
		try {
			OutputStream os;
			response.setContentType ( "application/ms-excel" ) ;
			
//			DataInputStream dis = new DataInputStream(request.getInputStream());
//			byte[] bs = new byte[request.getContentLength()];
//			dis.readFully(bs);
//			dis.close();
//			String s = new String(bs);
//
//			new String(s.getBytes("utf-8"),"GBK"));
	        response.setHeader ( "Content-Disposition" ,
	                             "attachment;filename="+new String((fileName+".xls").getBytes(),"gb2312")) ;

			os = response.getOutputStream();
			ExcelUtils.writeExcel(titles, datas, sheetNme,os);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		

		
		return null;
	}
	
	public void service (HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException {
		
		requestPageForm(request,response);

	}
	
}