Table of Contents
Preface
Chapter 1: JDBC 4.0
Chapter 2: Configuring JDBC in Oracle JDeveloper
Chapter 3: Connecting to a Database with JSTL SQL Tag Library
Chapter 4: Configuring JDBC in JBoss Application Server
Chapter 5: Configuring JDBC in WebLogic Server
Chapter 6: Configuring JDBC in WebSphere Application Server
Chapter 7: XML SQL Utility
Chapter 8: XSQL
Chapter 9: Oracle Web RowSet
Chapter 10: Creating a JSF Data Table
Chapter 11: Creating a JSF Panel Grid
Chapter 12: Creating a Report with JasperReports
Chapter 13: Creating a Spreadsheet with Apache POI
Chapter 14: Creating Oracle ADF Business Components
Chapter 15: Hibernate
Index
- Chapter 1: JDBC 4.0
- DriverManager Class
- Connection Interface
- Transactions
- Savepoint Interface
- Statement Interface
- ResultSet Interface
- PreparedStatement Interface
- Database Metadata
- JDBC Exceptions
- New Features in JDBC 4.0
- Automatic SQL Driver Loading
- Enhanced Data Type Support
- SQL: 2003 XML Data Type Support
- Generating an XML Document
- Storing an XML Document
- Retrieving an XML Document
- Accessing an XML Document Data
- Support for Wrapper Pattern
- Enhancements in SQLException
- Connection Management
- Scalar Functions
- JDBC 4.0 support in Oracle Database
- JDBC 4.0 support in MySQL Database
- JDBC 4.0 support in IBM's DB2 UDB
- Example Connection using a JDBC 4.0 Driver
- Summary
- Chapter 2: Configuring JDBC in Oracle JDeveloper
- Connection Pooling and DataSource
- Setting the Environment
- JDBC Configuration Errors
- Creating a Managed Data Source
- Connecting to a Database from a Web Application
- Setting J2SE Version to JDK 6.0
- Developing and Running JSP
- JDBC 4.0 Version
- Summary
- Chapter 3: Connecting to a Database with JSTL SQL Tag Library
- Overview of JSTL SQL and Core Tags
- Setting the Environment
- Creating a Database Table
- Updating a Database Table
- Querying a Database Table
- Summary
- Chapter 4: Configuring JDBC in JBoss Application Server
- Deploying a Web Application to JBoss from JDeveloper
- JDBC 4.0 Version
- JBoss Deployment Descriptors for EJBs
- Configuring JBoss Server with Oracle Database
- Configuring JBoss Server with MySQL Database
- Configuring JBoss Server with PostgreSQL Database
- Configuring JBoss Server with DB2 Database
- Configuring JBoss Server with SQL Server
- Summary
- Chapter 5: Configuring JDBC in WebLogic Server
- Setting the Environment
- Creating a Data Source
- Configuring a Data Source
- Creating a Multi Data Source
- Performance Tuning JDBC
- Deploying a Web Application to WebLogic Server from JDeveloper
- JDBC 4.0 Version
- Summary
- Chapter 6: Configuring JDBC in WebSphere Application Server
- Setting the Environment
- Configuring a JDBC Provider
- Configuring a Data Source
- Deploying a Web Application to the WebSphere from JDeveloper
- JDBC 4.0 Version
- Summary
- Chapter 7: XML SQL Utility
- Setting the Environment
- XML Document to SQL Database Mapping
- Updating Database from XML Document
- Deleting a Row in a Database
- SQL Database to XML Document Mapping
- Summary
- Chapter 8: XSQL
- Overview of XSQL Tags
- Setting the Environment
- Configuring a Connection
- Creating XSQL Queries
- Applying XSQL Query Attributes
- Transforming XSQL Output
- JDBC 4.0 Version
- Summary
- Chapter 9: Oracle Web RowSet
- Setting the Environment
- Creating a Web RowSet
- Modifying a Database Table with Web RowSet
- Creating a New Row
- Reading a Row
- Updating a Row
- Deleting a Row
- Updating Database Table
- JDBC 4.0 Version
- Summary
- Chapter 10: Creating a JSF Data Table
- Setting the Environment
- Creating a Data Table by Binding a MBean
- Creating a Data Table with the JSF API
- JDBC 4.0 Version
- Summary
- Chapter 11: Creating a JSF Panel Grid
- Setting the Environment
- Creating a Panel Grid by Binding Rows
- Creating a Panel Grid by Binding a Managed Bean
- JDBC 4.0 Version
- Summary
- Chapter 12: Creating a Report with JasperReports
- Setting the Environment
- Installing JasperReports
- Configuring the JasperReports Configuration File
- Generating a PDF Report
- Creating an Excel Spreadsheet
- JDBC 4.0 Version
- Summary
- Chapter 13: Creating a Spreadsheet with Apache POI
- Setting the Environment
- Creating an Excel Spreadsheet
- JDBC 4.0 Version
- Summary
- Chapter 14: Creating Oracle ADF Business Components
- Setting the Environment
- Configuring a BC4J Project
- Creating Business Components
- Developing a BC4J Web Application
- JDBC 4.0 Version
- Summary
- Chapter 15: Hibernate
- Hibernate and JDBC
- Setting the Environment
- Developing Hibernate Mapping and Properties Files
- Creating a Database Table
- Modifying Table Data with Hibernate
- Adding Data to the Database Table
- Retrieving Data from the Database Table
- Updating the Database Table
- Deleting Data
- Summary
