📄 exportstataction.java
字号:
/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.log.struts.action;
import java.io.BufferedOutputStream;
import java.io.PrintWriter;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.log.util.ExcelHelper;
import com.lzc.util.db.DBManager;
/**
* MyEclipse Struts
* Creation date: 10-09-2007
*
* XDoclet definition:
* @struts.action validate="true"
*/
public class ExportStatAction extends Action {
/*
* Generated Methods
*/
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
BufferedOutputStream outStream = null;
try {
String filename = new String("信息满意度统计报表.xls".getBytes(), "iso-8859-1");
outStream = new BufferedOutputStream(response.getOutputStream());
response.setContentType("application/vnd.ms-xml");
response.setHeader("Content-Disposition", "attachment; filename="
+ filename);
outStream = new BufferedOutputStream(response.getOutputStream());
String sql =request.getParameter("sql");
System.out.println("sql:"+sql);
String[][] data= DBManager.getNewInstance("szhtp").query(sql, -1, 1);
if (null == data ) {
response.setContentType("text/html;charset=gbk");
PrintWriter pw = response.getWriter();
pw.println("<html><title>没有记录</title><body>");
pw.println("<br>没有记录，所以您不能导出数据！！！</br>");
pw.println("</body></html>");
pw.flush();
pw.close();
} else {
ExcelHelper.writeToExcel(data, outStream);
}
if (outStream != null)
outStream.flush();
} catch (Exception e) {
System.out.println("Error in ExportStatAction:" + e);
return null;
}
return null;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -