更新时间:2021-08-25 18:09:14
封面
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface
What This Book Covers
Who is This Book for
Conventions
Reader Feedback
Customer Support
Downloading the Example Code for the Book
Errata
Questions
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
Support for Wrapper Pattern
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
Chapter 3. Connecting to a Database with JSTL SQL Tag Library
Overview of JSTL SQL and Core Tags
Creating a Database Table
Updating a Database Table
Querying a Database Table
Chapter 4. Configuring JDBC in JBoss Application Server
Deploying a Web Application to JBoss from JDeveloper
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
Chapter 5. Configuring JDBC in WebLogic Server
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
Chapter 6. Configuring JDBC in WebSphere Application Server
Configuring a JDBC Provider
Deploying a Web Application to the WebSphere from JDeveloper
Chapter 7. XML SQL Utility
XML Document to SQL Database Mapping
Updating Database from XML Document
Deleting a Row in a Database
SQL Database to XML Document Mapping
Chapter 8. XSQL
Overview of XSQL Tags
Configuring a Connection
Creating XSQL Queries
Applying XSQL Query Attributes
Transforming XSQL Output
Chapter 9. Oracle Web RowSet
Creating a Web RowSet
Modifying a Database Table with Web RowSet
Creating a New Row
Reading a Row
Updating a Row