依赖jar包
话不多说直接贴上代码
@RequestInfo(comments = "按条件导出")
public void printAllbyireport() {
HttpServletResponse res = getResponse();
HttpServletRequest req = getRequest();
HttpSession httpsession = req.getSession();
res.setCharacterEncoding("UTF-8");
File file = null;
try {
String p = req.getContextPath();
String paramMap = req.getParameter("paramMap").trim();
String dataUrl = req.getParameter("dataUrl").trim();
dataUrl = dataUrl.substring(p.length());
String title = req.getParameter("title");
String[] headers = req.getParameter("headers").split(",");
String[] fields = req.getParameter("fields").split(",");
String[] urlPara = new String[1];
Action action = JFinal.me().getAction(dataUrl, urlPara);
Controller controller = (Controller) action.getControllerClass()
.newInstance();
controller.setHttpServletRequest(req);
controller.setHttpServletResponse(getResponse());
controller.setUrlPara(urlPara[0]);
action.getMethod().invoke(controller, null);
JsonRender render = (JsonRender) controller.getRender();
String s = render.getJsonText();
s = s.substring(s.indexOf("["), s.lastIndexOf("]") + 1);
org.json.JSONArray jsonArray = new org.json.JSONArray(s);
httpsession.setAttribute("dataList", s);
JSONArray jsonArray1 = JSONArray.fromObject(s);
List list = (List) JSONArray.toList(jsonArray1);
String jaspername = req.getParameter("jaspername");
String exportType = req.getParameter("exportType");
JasperHelper.exportmain(req,res,exportType, jaspername, list, title,paramMap);
renderNull();
} catch (Exception e) {
e.printStackTrace();
}
}
//工具类,可以导出不同的文件格式
public class JasperHelper extends AppService{
private static Logger logger = Logger.getLogger(JasperHelper.class);
public static final String PRINT_TYPE = "print";
public static final String PDF_TYPE = "pdf";
public static final String EXCEL_TYPE = "excel";
public static final String HTML_TYPE = "html";
public static final String WORD_TYPE = "word";
public static void prepareReport(JasperReport jasperReport, String type) {
logger.debug("The method======= prepareReport() start.......................");
/*
* 如果导出的是excel,则需要去掉周围的margin
*/
if ("excel".equals(type))
try {
Field margin = JRBaseReport.class
.getDeclaredField("leftMargin")