Jaspersoft使用文档.docxVIP

Jaspersoft使用文档1:安装jaspersoft.不做介绍。2：创建文件。打开菜单：文件new选择Blank A4，点击Launch Report Wizard按钮确定.点击下一步后面连续点击”下一步”，完成文件的创建。一般情况下，只留Detail 1 模块即可，其它都可删除。特殊标签可能用到Page Header和page Footer删除之后，如下图所示，并且在属性栏设置文件的高、宽。然后根据开始你的标签布局设计模版：（注意，所有的字体显示，要选择上图那3个属性值，否则会出现乱码）（默认打印出来是不会显示边框的，选中Rectangle标签，右击Padding and Broders ）预览成功之后会生成一个.jaspersoft文件，用来java代码解析使用.Java代码调用jaspersoft1）：导入jarjasperreportsjasperreports5.6.0jasperreports2）：把要打印的模版存到对应的项目目录下3）：模版里面没有sql版本事例： public void printNewExpress(HttpServletRequest request,String no,HttpServletResponse response) throws JRException, InstantiationException, IllegalAccessException, IOException Collection storesQualitys = new ArrayList(); List pick=pickService.printExpressSingle(no); for (Pick detail : pick) String customerCode=detail.getCustomerCode(); String customerCompany=detail.getCustomerCompany(); String customerMobile=detail.getCustomerMobile(); String customerAddress=detail.getCustomerAddress(); String customerZipcode=detail.getCustomerZipcode(); String customerLocation=detail.getCustomerLocation(); String classPath=Thread.currentThread().getContextClassLoader().getResource().getPath(); String templatePath=; ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); Resource head = resolver.getResource(classpath:/com/iceasy/wms/console/controller/xls/template/printCarrierReport_Fed.jasper); templatePath =head.getFile().getAbsolutePath(); /封装报表参数 HashMap params = new HashMap(); /获取报表模板 String fileURL=com+System.getProperty(file.separator)+iceasy+System.getProperty(file.separator)+ wms+System.getProperty(file.separator)+console+System.getProperty(file.separator)+controller +System.getProperty(file.separator)+xls+System.getProperty(file.separator) +template+System.getProperty(file.separator); String templatePathImages =classPath + fileURL+checkbox_cheked.png; params.put(image_url, templatePathImages); /编译成JasperPrint对象 byte bytes = JasperRunManager.runReportToPdf(templatePath, params, new JRBeanCollectionDataSource(storesQualitys); response.setContentType(application/pdf);response.setContentLength(bytes.length);ServletOutputStream out;try out = response.getOutputStream();out.write(bytes, 0, bytes.length);out.flush();out.close(); catch (IOException e) / TODO Auto-generated catch blocke.printStackTrace(); 3）：模版里面有sql版本事例：public void printPickingList(HttpServletRequest request,String no,HttpServletResponse response) throws JRException, InstantiationException, IllegalAccessException, SQLException, IOException /获取报表模板 ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); Resource head = resolver.getResource(classpath:/com/iceasy/wms/console/controller/xls/template/printPickingList.jasper); Resource body = resolver.getResource(classpath:/com/iceasy/wms/console/controller/xls/template/printPickingDetailList.jasper); SqlSession sqlSession = sqlSessionFactory.openSession(); Connection connection = sqlSession.getConnection(); try String templatePath = head.getFile().getAbsolutePath(); String templatePath_Index = body.getFile().getAbsolutePath(); /封装报表参数 HashMap params = new HashMap(); params.put(pickListJasper, templatePath_Index); params.put(no, no); byte bytes = JasperRunManager.runReportToPdf(templatePath, params, connection); response.setContentType(application/pdf); response.setContentLength(bytes.length); ServletOutput