📄 exportloginfoaction.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.log.util.PageSqlUtil;
import com.lzc.util.db.DBManager;
/**
* MyEclipse Struts
* Creation date: 10-09-2007
*
* XDoclet definition:
* @struts.action validate="true"
*/
public class ExportLogInfoAction 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 = "日志查询报表.xls";
if(null!=request.getParameter("fileName")&&!request.getParameter("fileName").equals("")){
filename=request.getParameter("fileName");
//System.out.println("fileName:"+filename);
}
filename = new String(filename.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 =com.lzc.util.Tools.conver(request.getParameter("sql"));
String sql =request.getParameter("sql");
int pageNum=0;
int pageSize=0;
int pageRowCount=0;
pageNum=Integer.parseInt(request.getParameter("pageNum"));
pageSize=Integer.parseInt(request.getParameter("pageSize"));
pageRowCount=Integer.parseInt(request.getParameter("pageRowCount"));
//PageSqlUtil pageutil=new PageSqlUtil();
//String newsql=pageutil.getPageSql(sql, pageNum, pageSize, pageRowCount);
//String[][] data= DBManager.getNewInstance("szhtp").query(newsql, pageRowCount, 1);
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 ExportLogInfoAction:" + e);
return null;
}
return null;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -