Book Image

JasperReports for Java Developers

Book Image

JasperReports for Java Developers

Overview of this book

JasperReports is the world's most popular embeddable Java open source reporting library, providing Java developers with the power to easily create rich print and web reports. This book shows you exactly how to get started, and develop the skills to get the most from JasperReports. The book steers you through each point of report setup, to creating, designing, formatting, and exporting reports with data from a wide range of datasources, and integrating JasperReports with other Java frameworks. Starting with the basics of adding reporting capabilities to your application, and creating report templates you will first see how to produce your reports through the use of JRXML files, custom ANT targets, and then see preview them in both the browser and the native browser of JasperReports. Getting data into your reports is the next step, and you will see how to get data from a range of datasources, not only databases, but XML files, and Java Objects, among others. You will create better looking reports with formatting and grouping, as well as adding graphical elements to the report. You will export your reports to a range of different formats, including PDF and XML. Creating reports will be made even easier with a walkthrough of the iReport Designer visual designing tool. To round things off, you will see how to integrate your reports with other Java frameworks, using Spring or Hibernate to get data for the report, and Java Server Faces or Struts for presenting the report.
Table of Contents (13 chapters)
12
Index

Database for Our Reports

In this chapter, we will use a MySQL database to obtain data for our reports. The database is a subset of public domain data that can be downloaded from http://dl.flightstats.us. The original download is 1.3GB. However, we deleted most of the tables and a lot of the data to trim the download size considerably.

A MySQL dump of the modified database can be found at this book's website: http://www.packtpub.com/support.

The database contains the following tables: aircraft, aircraft_models, aircraft_types, aircraft_engines, and aircraft_engine_types. The database structure can be seen in the following diagram:

Database for Our Reports

Note

The FlightStats database uses the default MyISAM MySQL engine, which does not support referential integrity (foreign keys). That is the reason for which we don't see any arrows in the diagram indicating dependencies between the tables.

Let us create a report that will show the most powerful aircraft in the database, say, those with a horsepower of...