Jaspersoft使用文檔

1、.;Jaspersoft使用文檔1:安裝jaspersoft.不做介紹。2：創(chuàng)建文件。打開菜單：文件new選擇Blank A4，點(diǎn)擊Launch Report Wizard按鈕確定.點(diǎn)擊下一步后面連續(xù)點(diǎn)擊”下一步”，完成文件的創(chuàng)建。一般情況下，只留Detail 1 模塊即可，其它都可刪除。特殊標(biāo)簽可能用到Page Header和page Footer刪除之后，如下圖所示，并且在屬性欄設(shè)置文件的高、寬。然后根據(jù)開始你的標(biāo)簽布局設(shè)計(jì)模版：（注意，所有的字體顯示，要選擇上圖那3個(gè)屬性值，否則會(huì)出現(xiàn)亂碼）（默認(rèn)打印出來是不會(huì)顯示邊框的，選中Rectangle標(biāo)簽，右擊Padding and Brode

2、rs ）預(yù)覽成功之后會(huì)生成一個(gè).jaspersoft文件，用來java代碼解析使用.Java代碼調(diào)用jaspersoft1）：導(dǎo)入jarjasperreportsjasperreports5.6.0jasperreports2）：把要打印的模版存到對(duì)應(yīng)的項(xiàng)目目錄下3）：模版里面沒有sql版本事例： public void printNewExpress(HttpServletRequest request,String no,HttpServletResponse response) throws JRException, InstantiationException, IllegalAcce

3、ssException, 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 cust

4、omerAddress=detail.getCustomerAddress(); String customerZipcode=detail.getCustomerZipcode(); String customerLocation=detail.getCustomerLocation(); String classPath=Thread.currentThread().getContextClassLoader().getResource().getPath(); String templatePath=; ResourcePatternResolver resolver = new Pat

5、hMatchingResourcePatternResolver(); Resource head = resolver.getResource(classpath:/com/iceasy/wms/console/controller/xls/template/printCarrierReport_Fed.jasper); templatePath =head.getFile().getAbsolutePath(); /封裝報(bào)表參數(shù) HashMap params = new HashMap(); /獲取報(bào)表模板 String fileURL=com+System.getProperty(fil

6、e.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 =cla

7、ssPath + fileURL+checkbox_cheked.png; params.put(image_url, templatePathImages); /編譯成JasperPrint對(duì)象 byte bytes = JasperRunManager.runReportToPdf(templatePath, params, new JRBeanCollectionDataSource(storesQualitys); response.setContentType(application/pdf);response.setContentLength(bytes.length);Servl

8、etOutputStream 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 respons

9、e) throws JRException, InstantiationException, IllegalAccessException, SQLException, IOException /獲取報(bào)表模板 ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); Resource head = resolver.getResource(classpath:/com/iceasy/wms/console/controller/xls/template/printPickingList.jaspe

10、r); 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();

11、String templatePath_Index = body.getFile().getAbsolutePath(); /封裝報(bào)表參數(shù) 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