www.brainysoft.net
1.JasperReport ireport...4 1.1 JasperReport...4 1.2 ireport...4 2....4 2.1 JDK...4 2.1.1 JDK...4 2.1.2 JDK...5 2.1.3 JDK...5 2.2 ant...6 2.2.1 ant...6 2.2.2 ant...6 2.3 JasperReport...7 2.3.1 JasperReport...7 2.3.2 JasperReport...7 2.4 ireport...8 2.4.1 ireport...8 2.4.2 ireport...8 3.iReport...8 3.1 ireport...8 3.1.1 ant ireport...8 3.1.2 ant ireport...8 3.2 ireport...9 3.3...9 3.4...10 3.5...12 3.5.1...12 3.5.2 SQL...13 3.5.3...14 3.5.4...14 3.5.5...16 3.6...17 3.7 JasperReport band...18 3.8 ireport...22 3.9...23 4. JasperReport...24 2
4.1 JSP...24 4.1.1 JSP...24 4.1.2 JSP...24 4.1.3 JSP...25 4.2 Servlet...26 4.3 SQL...27 4.4...28 4.5 PDF...28 5....29 5.1 ireport...29 5.2...30 5.3...30 3
1.JasperReport ireport 1.1 JasperReport JasperReport sf.net java JasperReport 0.5.2 JasperReport http://jasperreports.sourceforge.net/index.html JasperReport WEB Java Application JasperReport 1.2 ireport ireport sf.net JasperReport JasperReport ireport ireport 0.3.0 ireport http://ireport.sourceforge.net ireport JasperReport ireport JasperReport 2. 2.1 JDK 2.1.1 JDK JDK SUN http://java.sun.com JDK 3 J2ME,J2SE,J2EE J2SE SDK J2SE SDK JAVA J2SE JRE JDK SUN JDK JDK JDK 4
2.1.2 JDK Windows Next JDK 2.1.3 JDK Windows 2000 J2SE SDK ( J2SE JRE) JAVA_HOME 2.1.2 JDK \ CLASSPATH CLASSPATH %JAVA_HOME%\lib\tools.jar; %JAVA_HOME%\lib\dt.jar %JAVA_HOME% PATH, %JAVA_HOME%\bin JDK set classpath set java_home javac -version JAVA 5
2.2 ant ant JasperReport ireport ant ant 2.2.1 ant ant apache http://ant.apache.org Windows ZIP ant ant 2.2.2 ant 2.1.3 JDK ANT_HOME ant \ Path %ANT_HOME%\bin ant ant 6
2.3 JasperReport 2.3.1 JasperReport JasperReport sf.net JasperReport sf.net sf.net Asia jasperreport source.zip jasperreport JasperReport.jar JasperReport.jar %JAVA_HOME%\lib\ 2.3.2 JasperReport JasperReport-x.x.x.jar ClASSPATH JasperReport 7
2.4 ireport 2.4.1 ireport ireport bug fix ireport ireport bug fix ireport 8M ireport Windows.zip ireport bug fix ( ) JasperReport PDF itext itext itextasia.jar itextasia.jar, http://itextpdf.sourceforge.net itextasia.jar ireport lib 2.4.2 ireport 2.x ant ireport ireport ireport.bat ireport.bat javadoc javadoc doc ireport 3.0 ireport.bat 3.iReport 3.1 ireport 3.1.1 ant ireport ireport ireport.bat 3.1.2 ant ireport 2.X ireport noant startup.bat 3.0 bin 8
startup.bat 3.2 ireport ireport tinylaf.jar ireport\lib tinylaf.jar.jar ireport 3.3 File, New document Report property UTF-8 9
Static text tool Detail bands build complile JRViewer preview execute report 3.4 Static Text Static text 10
FONT font name, PDF font name PDF Encoding JRViewer PDF PDF itextasian.jar ireport Lib 11
3.5 3.5.1 data source Connections/Datasources new JasperReport JDBC XML Sql Server pubs Sql Server Sql Server JDBC ireport lib JDBC ireport Test Save 12
3.5.2 SQL Table SQL SQL build set active connection SQL View Report query SQL 2.X Read fields SQL ireport Ctrl Shift Register fields to report Save query to report 3.0 3.0 sql sql OK 13
3.5.3 View Report fields ireport 3.5.2 SQL 3.5.4 Details 14
Text Field Textfield expression Textfield expression $F{ } Font 3.4 15
3.5.5 build compile ireport null build execute report build execute report (use active conn) PDF, adobe acrobat reader 16
3.6 View Report fonts new Font name PDF font name STSong-Light PDF Encoding UniGB-UCS2-H OK 17
3.7 JasperReport band Title Band title Title band pageheader Band pageheader pageheader Title Band pageheader pagefooter Band Detail Band Detail columnheader Band Detail Band columnfooter Band: Detail Band Summary Band: Detail band Sql Server pubs titles 18
summary detail band title band summary band 19
20
21
3.8 ireport SQL View Report Parameters New ireport $F $P $P{ } 22
3.9 View, Report Variables New PrintDate $V( ) Pattern HH MM 23
4. JasperReport 4.1 JSP 4.1.1 JSP JasperReport JSP ireport lib.jar JSP web-inf\lib web-inf\lib Jar JAR 4.1.2 JSP <%@ page contenttype="application/pdf;charset=gb2312"%> <%@ page import="dori.jasper.engine.*" %> <%@ page import="dori.jasper.engine.util.*" %> <%@ page import="dori.jasper.engine.export.*" %> <%@ page import="java.util.*" %> <%@ page import="java.io.*" %> <%@ page import="java.sql.*" %> <% //.jasper File reportfile = new File(application.getRealPath("/report/test.jasper")); // SQL Server JDBC URL String url ="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=pubs"; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); // 24
Map parameters = new HashMap(); //"Name", String parameters.put("name", new String(" ")); System.out.println("---------conn-------------"); // Connection conn = DriverManager.getConnection(url,"sa", ""); System.out.println("---------Jasper begin-------------"); // System.out.println(reportFile.getPath()); byte[] bytes=jasperrunmanager.runreporttopdf(reportfile.getpath(),parameters,conn); System.out.println("---------Jasper end-------------"); response.setcontenttype("application/pdf"); response.setcontentlength(bytes.length); ServletOutputStream ouputstream = response.getoutputstream(); ouputstream.write(bytes, 0, bytes.length); ouputstream.flush(); %> ouputstream.close(); 4.1.3 JSP 1 JSP IIS RESIN-2.11 JSP Windows 2000 IIS 5.0 IIS 80 Apache log Resin fill (Service) JSP JSP 2 test.jasper 25
test.jasper 3 Adobe acrobat reader PDF 4 PDF IE Adobe acrobat reader Localhost IP 5 web-inf\lib itextasian.jar font 4.2 Servlet Servlet 4.1 import javax.servlet.*; import javax.servlet.http.*; import dori.jasper.engine.*; import java.io.*; import java.util.*; import java.sql.*; public class TestReport extends HttpServlet { public void doget(httpservletrequest request, HttpServletResponse response) throws ServletException, IOException { Connection conn = null; try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn =DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs; user=sa;password="); ServletContext servletcontext =this.getservletcontext(); File reportfile = new File(servletContext.getRealPath("report/test.jasper")); Map parameters = new HashMap(); String myname=new String(" "); parameters.put("name", myname); byte[] bytes =JasperRunManager.runReportToPdf(reportFile.getPath(),parameters,conn); 26
} response.setcontenttype("application/pdf"); response.setcontentlength(bytes.length); ServletOutputStream ouputstream = response.getoutputstream(); ouputstream.write(bytes, 0, bytes.length); ouputstream.flush(); ouputstream.close(); } catch (JRException jre) { System.out.println("JRException:" + jre.getmessage()); } catch (Exception e) { System.out.println("Exception:" + e.getmessage()); } public void dopost(httpservletrequest request,httpservletresponse response) throws ServletException, IOException { doget(request, response); } } 4.3 SQL SQL SQL String 27
SQL, $P!{SQLSTR} $P! $P 4.4 PrintWhenExpression PrintWhenExpression Boolean new java.lang.boolean($f{type}.trim().equals("mod_cook")) 4.5 PDF Java Application Adobe Acroabat Adobe Acrobat Reader public void print() throws UnsupportedFormatException { 28
save("./tmp.pdf"); try { String osname = System.getProperty("os.name"); //FOR WINDOWS 95 AND 98 USE COMMAND.COM if (osname.equals("windows 95") osname.equals("windows 98")) { Runtime.getRuntime().exec("command.com /C start acrord32 /p " + "./tmp.pdf"); } //FOR WINDOWS NT/XP/2000 USE CMD.EXE else { Runtime.getRuntime().exec("cmd.exe /C Start acrord32 /p " + "./tmp.pdf"); } } catch (IOException IOE) { JOptionPane.showMessageDialog(null, IOE.getMessage(), "RuntimeException", JOptionPane.ERROR_MESSAGE); } } 5. 5.1 ireport variablesname $V{ variablesname } parametername $P{ parametername } filedsname $F{ filedsname } 29
5.2 www.brainysoft.net JasperReport Ireport http://forum.brainysoft.net 5.3 98 Java Delphi/BCB Windows Windows Java JasperReport ireport itext Java itext Java 5.1 ireport JasperReport Java JasperReport JasperReport JasperReport 2004 5 13 2 30