Data retrieval and storage is one of the most common components
of J2EE applications. JDBC (Java Database Connectivity) is the Java
API for accessing a SQL relational database and adding, retrieving,
and updating data in the database.
Oracle JDeveloper is a developer-friendly integrated development
environment (IDE) for building service-oriented applications using
the latest industry standards for Java, XML, web services, and SQL.
It supports the complete development lifecycle with integrated
features for modeling, coding, debugging, testing, profiling,
tuning, and deploying applications.
This book is about developing Java/J2EE applications with a
database component in Oracle JDeveloper (version 10.1.3). It covers
the practical aspects of JDBC (version 4.0); it will teach
application developers about setting the environment for developing
various JDBC-based J2EE applications and the procedure to develop
JDBC-based J2EE applications. It will also explore the new features
added in JDBC 4.0.
What you will learn from this book?
In this book you will learn about the following:
JDBC 4.0 specifications--including the new features
Configuring JDBC in Oracle JDeveloper IDE
Creating, modifying, and querying a database with the JSTL SQL Tag Library
Configuring JDBC in JBoss application server, WebLogic server, and WebSphere application server
Mapping an XML document to a database table and vice versa
Modifying a database table from an XML document and creating an XSQL Page to run an SQL Query and generate XML
Implementing Oracle Web RowSet to fetch the disconnected data
Creating Excel spreadsheets, PDFs, and Excel reports using JasperReports and the Apache POI HSSF library
Creating JSF Data Tables, JSF Panel Grids, and business components from Oracle databases with JDeveloper
Creating and managing database tables using Hibernate