我的技术文档库

查询结果显示为网页文件后将有一个按钮提示导出为Excel文件
选择以Excel或者网页方式来显示查询结果的代码如下：
String target=request.getParameter("target");
if(target==null)
	target="";

if(!target.equals(""))
	{
		response.setContentType("application/vnd.ms-excel; charset=GBK");
		response.setHeader("Content-Disposition","attachment; filename=\"AQEExport.xls\"");
	}
else
	{
		response.setContentType("text/html; charset=GBK");
	}	
<--!查询结果-->
参数target用来判断是否选择了导出excel文件的按钮

直接将查询数据生成Excel的方法：
   String path = request.getRealPath("");
   FileOutputStream fos=null;
    if(region.indexOf("***")!=-1)
    	fos = new FileOutputStream(path+"Report/Excel/AFYP_S_"+region.substring(0,2)+".xls");
    else
    	fos = new FileOutputStream(path+"Report/Excel/AFYP_S_"+region+".xls"); 
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    wb.setSheetName(0, "AFYP(100%)");
    short n = 0;
    short m = 0;
    HSSFRow row = s.createRow(n);
    HSSFCell cell = row.createCell(m);

具体程序源代码参见AQEExport.jsp和ams系统下的Rep1106.jsp.