JasperReports is a Java reporting tool to generate HTML, XML, PDF, CSV, or XLS reports. In this chapter we learned how to create a PDF and an Excel spreadsheet report from a database table using JDBC to connect to the database and run an SQL query. We added JDBC 4.0 features connection state tracking and connection client identification in the JDBC 4.0 version of the JasperReports application.
JDBC 4.0 and Oracle JDeveloper for J2EE Development
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Overview of this book
Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface
Free Chapter
JDBC 4.0
Configuring JDBC in Oracle JDeveloper
Connecting to a Database with JSTL SQL Tag Library
Configuring JDBC in JBoss Application Server
Configuring JDBC in WebLogic Server
Configuring JDBC in WebSphere Application Server
XML SQL Utility
XSQL
Oracle Web RowSet
Creating a JSF Data Table
Creating a JSF Panel Grid
Creating a Report with JasperReports
Creating a Spreadsheet with Apache POI
Creating Oracle ADF Business Components
Hibernate
Customer Reviews