您的位置: 首页  >  文章  >  关于jfinal整合ireport实例，并调用lodop打印

关于jfinal整合ireport实例，并调用lodop打印

分类: 文章 • 2024-07-16 20:03:58

关于jfinal整合ireport实例，并调用lodop打印依赖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");
      margin.setAccessible(true);
      margin.setInt(jasperReport, 0);
      margin = JRBaseReport.class.getDeclaredField("topMargin");
      margin.setAccessible(true);
      margin.setInt(jasperReport, 0);
      margin = JRBaseReport.class.getDeclaredField("bottomMargin");
      margin.setAccessible(true);
      margin.setInt(jasperReport, 0);
      Field pageHeight = JRBaseReport.class
        .getDeclaredField("pageHeight");
      pageHeight.setAccessible(true);
      pageHeight.setInt(jasperReport, 2147483647);
     } catch (Exception exception) {
     }
   }


   /**
    * 导出excel
    */
   public static void exportExcel(JasperPrint jasperPrint,String defaultFilename,
     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {
   logger.debug("执行导出excel   The method======= exportExcel() start.......................");
     /*
      * 设置头信息
      */
     response.setContentType("application/vnd.ms-excel");
     String defaultname=null;
     if(defaultFilename.trim()!=null&&defaultFilename!=null){
    defaultname=defaultFilename+".xls";
     }else{
    defaultname="export.xls";
     }
     String fileName = new String(defaultname.getBytes("gbk"), "utf-8");
     response.setHeader("Content-disposition", "attachment; filename="
       + fileName);
     ServletOutputStream ouputStream = response.getOutputStream();
     JRXlsExporter exporter = new JRXlsExporter();
     exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
     exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,ouputStream);
     exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
     exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
     exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
     
     exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED,true);
     exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,true);
     exporter.exportReport();
     ouputStream.flush();
     ouputStream.close();
   }


   /**
    * 导出pdf，注意此处中文问题， 


    * 这里应该详细说：主要在ireport里变下就行了。看图


    * 1）在ireport的classpath中加入iTextAsian.jar
    * 2）在ireport画jrxml时，看ireport最左边有个属性栏。


    * 下边的设置就在点字段的属性后出现。
    * pdf font name ：STSong-Light ，pdf encoding ：UniGB-UCS2-H
    */
   private static void exportPdf(JasperPrint jasperPrint,String defaultFilename,
     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {
     response.setContentType("application/pdf");
     String defaultname=null;
     if(defaultFilename.trim()!=null&&defaultFilename!=null){
    defaultname=defaultFilename+".pdf";
     }else{
    defaultname="export.pdf";
     }
     String fileName = new String(defaultname.getBytes("GBK"), "ISO8859_1");
     response.setHeader("Content-disposition", "attachment; filename="
       + fileName);
     ServletOutputStream ouputStream = response.getOutputStream();
     JasperExportManager.exportReportToPdfStream(jasperPrint,
       ouputStream);
     ouputStream.flush();
     ouputStream.close();
   }


   /**
    * 导出html
    */
   private static void exportHtml(JasperPrint jasperPrint,String defaultFilename,
     HttpServletRequest request, HttpServletResponse response) throws IOException, JRException {
     response.setContentType("text/html");
     
    /* response.setContentType("text/html;charset=GB2312");*/
     //获得输出流 ,这里不能这样response.getOutputStream()  
    /* PrintWriter printWriter = response.getWriter(); */
     ServletOutputStream ouputStream = response.getOutputStream();
     JRHtmlExporter exporter = new JRHtmlExporter();
   //导出 html
     exporter.setParameter(
       JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN,
       Boolean.FALSE);
     exporter.setParameter(JRHtmlExporterParameter.SIZE_UNIT,"pt"); 
     exporter
       .setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
     exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING,
       "UTF-8");
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM,
       ouputStream);
    
   //设置输出  
    /* exporter.setParameter(JRExporterParameter.OUTPUT_WRITER,printWriter);  */


     exporter.exportReport();
     
     ouputStream.flush();
     ouputStream.close();
    /* printWriter.close();*/
   }


   /**
    * 导出word
    */
   private static void exportWord(JasperPrint jasperPrint,String defaultFilename,
     HttpServletRequest request, HttpServletResponse response)
     throws JRException, IOException {
    response.setContentType("application/msword;charset=utf-8");
    String defaultname=null;
     if(defaultFilename.trim()!=null&&defaultFilename!=null){
    defaultname=defaultFilename+".doc";
     }else{
    defaultname="export.doc";
     }
    String fileName = new String(defaultname.getBytes("GBK"), "utf-8");
    response.setHeader("Content-disposition", "attachment; filename="
      + fileName);
    JRExporter exporter = new JRRtfExporter();
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response
      .getOutputStream());


    exporter.exportReport();
   }
   /**
    * 按照类型导出不同格式文件
    * 
    * @param datas
    *            数据
    * @param type
    *            文件类型
    * @param is
    *            jasper文件的来源
    * @param request
    * @param response
    * @param defaultFilename默认的导出文件的名称
    */
   private static void export(Collection datas, String type,String defaultFilename, InputStream is,
     HttpServletRequest request, HttpServletResponse response,String parameMap) {
    logger.debug("导出判断     The method======= export() start.......................");
    try {
     JasperReport jasperReport = (JasperReport) JRLoader.loadObject(is);
     prepareReport(jasperReport, type);
    JRDataSource ds = new JRBeanCollectionDataSource(datas, false);
   //  Map parameters = new HashMap();
     
    JSONObject jsonobject=JSONObject.fromObject(parameMap); //使用net.sf.json.JSONObject对象来解析json
     
     Map parameters = new HashMap();
     parameters = new HashMap<String,Object>();
     Iterator iterator = jsonobject.keys();  
     while(iterator.hasNext()){  
                 String key = (String) iterator.next();  
            String value = jsonobject.getString(key);  
            parameters.put(key, value);
     }  
     //List<Map<String, Object>> listMap=new ArrayList<Map<String,Object>>(); 
    
            /*  //只保留不为空的 键值对
              if( (String) jsonOne.get("Value")!=""&&!"".equals( (String) jsonOne.get("Value"))){
               listMap.add(map); 
              }*/
     
     
   // parameters.put("wheresql", " and status='3'");
    /* parameters.put("wheresql", "");
       String diver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@192.168.1.156:1521:orcl";
String username = "qqwcrm0625";
String password = "qqwcrm";
ReportDataSource datasource = new ReportDataSource();
datasource.setDiver(diver);
datasource.setUrl(url);
datasource.setUsername(username);
datasource.setPassword(password);
Connection con=getConnection(datasource);*/
     JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, ds);


     jasperPrint.setLocaleCode("11111111111111");
     if (EXCEL_TYPE.equals(type)) {
      exportExcel(jasperPrint,defaultFilename, request, response);
     } else if (PDF_TYPE.equals(type)) {
      exportPdf(jasperPrint,defaultFilename, request, response);
     } else if (HTML_TYPE.equals(type)) {
      exportHtml(jasperPrint,defaultFilename, request, response);
     } else if (WORD_TYPE.equals(type)) {
      exportWord(jasperPrint,defaultFilename, request, response);
     }else if(PRINT_TYPE.equals(type)){
      exportHtml(jasperPrint,defaultFilename, request, response);
      //直接打印
     // JasperPrintManager.printReport(jasperPrint, true);  
     }
    } catch (Exception e) {
     e.printStackTrace();
    }
   }
   /**
    * 导出入口
    * 
    * @param exportType
    *            导出文件的类型
    * @param jaspername
    *            jasper文件的名字 如： xx.jasper
    * @param lists
    *           导出的数据
    * @param request
    * @param response
    * @param defaultFilename默认的导出文件的名称
    */
   public static void exportmain(HttpServletRequest request, HttpServletResponse response, String exportType,String jaspername,List lists,String defaultFilename,String paramMap){
   logger.debug("进入导出    The method======= exportmain() start.......................");

   
   String filenurl=PathKit.getWebRootPath() +jaspername;//jasper文件放在WebRoot/ireport/xx.jasper</span>
   
   File file = new File(filenurl);
        InputStream is = null;
        try {
is = new FileInputStream(file);
} catch (FileNotFoundException e) {
e.printStackTrace();
}
export(lists,exportType,defaultFilename,is,request,response,paramMap);
   }

}


前端js代码：

$.post(url,allPara,function(result){
//console.info(result);
//lodop.print(resule); 伪代码
if(param.exportType=="print"){
LODOP = getLodop();
LODOP.ADD_PRINT_HTM(0,0,"100%","100%",result);
LODOP.SET_PRINT_MODE("PRINT_PAGE_PERCENT","Auto-Width");//整宽不变形
LODOP.SET_PREVIEW_WINDOW(2,0,0,0,0,""); //按适宽模式显示
LODOP.PREVIEW();//打印预览
//LODOP.PRINT_SETUP();//打印维护
}

})


后台返回通过ireport生成的html页面，通过lodop直接调用打印预览

相关推荐