-
Book Overview & Buying
-
Table Of Contents
JasperReports for Java Developers
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:

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...
Change the font size
Change margin width
Change background colour