untitled

Size: px

Start display at page:

Download "untitled"

すずりいさやま
7 years ago
Views:

1 ireports ireports JasperReports GUI JasperReports Java PDF,HTML,Excel ireportsjasperreports URL ireportshttp://ireport.sourceforge.net/ JasperReportshttp://jasperreports.sourceforge.net/ JasperReports (.xml) Jasper Compiler JasperReports (.jasper) (JRDataSource) 1.2. ireportsjasperreports 2Web Web 0.1 1

net/ JasperReportshttp://jasperreports.sourceforge.net/ JasperReports (.

2 1.3. OSWindows2000 Professional JavaVM:Sun JDK ant1.4 ireportsireports JasperReportsJasperReports OSRed Hat Linux 8.0 DBPostgreSQL (1) ireportsireport zip JasperReportsjasperreports project.zip ireportshttp://prdownloads.sourceforge.net/ireport/ireport zip?download JasperReportshttp://prdownloads.sourceforge.net/jasperreports/jasperreports project.zip?download (2) ireportsjasperreports C C: ireport-0.2.1c: jasperreports ireports C: ireport off set JAVA_HOME=C: j2sdk1.4.0_03 set ANT_HOME=C: ant set IREPORT_HOME=C: Documenti progetti ireport ireport2 rem %ANT_HOME% bin ant javadocs %ANT_HOME% bin ant ireport 0.1 2

5.0-project.zip?download (2) ireportsjasperreports C C: ireport-0.2.1c: jasperreports-0.5.0 ireports C: ireport-0.2.1 ireport.bat @echo off set JAVA_HOME=C: j2sdk1.4.

3 ireports C: ireport ireport.bat ireports scrn ireports (1) [Tools]-[Options][External programs] pdf [PDF Viewer] scrn

4 (2) (A) [DataSource]-[Connections / Datasources] [New] JDBC ireport libc: ireport libireport [Test][SAVE] scrn 3 (B) [Build]-[Set Active connection] [OK] scrn

5 1.5. [File]-[New document] [Report name][ok] scrn

6 (1) [Datasource]-[Report query] scrn

7 [Report SQL Query] SQL SQL [Read fields] [Register fields to report] [Save query to report] scrn

8 (2) scrn 8 (3) scrn

9 [Band] scrn 10 [title][itemclsheader] 0.1 9

10 (4) $F{itemcls} $F [Fields] $V [Variables] $P [Parameter] [detail]$f{itemcls},$f{type}pagefooter String.valueOf($V{PAGE_NUMBER} scrn

11 (5) [] pagefooter scrn 12 (6) xml ireports xml image ireports 2(4)(D)

12 1.6. scrn

13 1.7. pdf [Build]-[*** View]1.4(1) scrn

14 2. Web Web TOMCAT CATALINA_HOME JasperReports JASPER_HOME OSRed Hat Linux 8.0 JavaVM:Sun JDK DB:PostgreSQL ant1.4 tomcat JasperReportsJasperReports (1) $ CATARINA _HOME/webapps $JASPER_HOME/demo/samples/webapps JasperReport TOMCAT (2) TOMCAT URL ):/JasperReport compile() scrn

5.0 (1) $ CATARINA _HOME/webapps $JASPER_HOME/demo/samples/webapps JasperReport

15 execute scrn 16 scrn

16 (3) home [PDF output()]execute PDF scrn 18 (4) (A) (sample.xml,sample.jasper) $ CATARINA _HOME/webapps/JasperReport/reports

17 (B) JSP $CATARINA_HOME/webapps/JasperReport/JSP compile.jsp () JasperCompileManager.compileReportToFile(application.getRealPath("/reports/sample.xml")); $CATARINA_HOME/webapps/JasperReport/JSP pdf.jsp () File reportfile = new File(application.getRealPath("/reports/sample.jasper")); // JasperRunManager connection Class.forName("org.postgresql.Driver"); Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/DEV","user", "pass"); byte[] bytes = JasperRunManager.runReportToPdf( reportfile.getpath(), parameters, con ); (C) sample.xml MSGothic <font fontname="msgothic" pdffontname="/usr/local/fonts/msgothic.ttc,1" size="12" isbold="false" isitalic="false" isunderline="false" ispdfembedded ="false" pdfencoding ="Identity-H" isstrikethrough="false" /> (D) ireports sample.xml <image> <imageexpression class="java.lang.string"> <![CDATA["/usr/local/tomcat/jakarta-tomcat /webapps/JasperReports/reports/logo.jpg"]]> </imageexpression> </image>

getConnection("jdbc:postgresql://localhost:5432/DEV","user", "pass"); byte[] bytes = JasperRunManager.runReportToPdf( reportfile.getpath(), parameters, con ); (C) sample.

18 3. Tips 3.1. (1) ireports xml querystring $P{} <querystring><![cdata[select * from dpmn where menuact=$p{ac_code};]]></querystring> (2) // File sourcefile = new File( "paramtest.xml"); JasperDesign jasperdesign = JRXmlLoader.load( absolutepath); File destfile = new File( absolutepath.substring(0, absolutepath.length() - 3) + "jasper"); String destfilename = destfile.tostring(); // JRDesignParameter designparameter = new JRDesignParameter(); designparameter.setname( "AC_CODE"); designparameter.setvalueclass( new String().getClass()); jasperdesign.addparameter( designparameter); JasperCompileManager.compileReportToFile(jasperDesign, destfilename); (3) // Map parameters = new HashMap(); parammap.put("basedir", "D: work "); parammap.put("ac_code", "NEW"); byte[] bytes; try { bytes = JasperRunManager.runReportToPdf( reportfile.getpath(), parammap, con); }

tostring(); // JRDesignParameter designparameter = new JRDesignParameter(); designparameter.setname( "AC_CODE"); designparameter.setvalueclass( new String().getClass()); jasperdesign.

19 3.2. A B $F{item_qty} $F{item_amount} ()()() scrn

$$F{item_qty}$

20 Reset typepage Valiable expression${subtotal} Calculation type Sum$V{total} $V{subtotal}$V{total} scrn 20 Textfield expression $V{subtotal}$V{total} scrn 21 scrn

21 3.3. ireports ireports (1) ireports scrn 23 (2) java scrn

22 4. WEB+DB PRESS VOL15 / ireports ( JasperReports (

23 5. JasperReports ireports

201506_Web版作成支援_簡易操作マニュアル

201506_Web版作成支援_簡易操作マニュアル ... 1... 7 :info_prtr@nite.go.jp PRTR http://www.nite.go.jp/chem/prtr/notify.html URL PRTR P.9 PRTR 1 P.7 2 P.11 3 4 XML PDF 5 OK XML PDF 6 XML PDF OK OK XML XML P.8 7 XML 8 http://www.nite.go.jp/chem/prtr/notify.html