Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Using Java with Oracle Database

• 1.1 Using Java to Connect to Oracle Database
  • 1.1.1 Oracle JDBC Thin Driver
  • 1.1.2 Oracle JDBC OCI Driver
  • 1.1.3 Oracle JDBC Packages
• 1.2 Using JDeveloper to Create JDBC Applications
  • 1.2.1 JDeveloper User Interface
  • 1.2.2 JDeveloper Tools
• 1.3 Overview of Sample Java Application
• 1.4 Advanced Application Development Using Developer Frameworks

2 Getting Started with the Application

• 2.1 What You Need to Install
  • 2.1.1 Oracle Database Server
    • 2.1.1.1 Modifying the HR Schema for the JDBC Application
  • 2.1.2 Oracle Database Client
  • 2.1.3 J2SE or JDK
  • 2.1.4 Integrated Development Environment
  • 2.1.5 Web Server
• 2.2 Verifying the Oracle Database Client Installation
  • 2.2.1 Checking Installed Directories and Files
  • 2.2.2 Checking the Environment Variables
  • 2.2.3 Determining the JDBC Driver Version
• 2.3 Installing Oracle JDeveloper
  • 2.3.1 JDeveloper Studio Edition: Base Installation and Full Installation
  • 2.3.2 Steps to Install JDeveloper
  • 2.3.3 Starting JDeveloper

3 Connecting to Oracle Database

• 3.1 Connecting to Oracle Database from JDeveloper
  • 3.1.1 JDeveloper Database Navigator
  • 3.1.2 Creating a Database Connection
  • 3.1.3 Browsing the Data Using the Database Navigator
• 3.2 Setting Up Applications and Projects in JDeveloper
  • 3.2.1 Using the JDeveloper Application Navigator
  • 3.2.2 Creating an Application and a Project
  • 3.2.3 Viewing the Javadoc and Source Code Available in the Project Scope
• 3.3 Connecting to Oracle Database from a Java Application
  • 3.3.1 Overview of Connecting to Oracle Database
  • 3.3.2 Specifying Database URLs
    • 3.3.2.1 Using the Default Service Feature of the Oracle Database Client
  • 3.3.3 Creating a Java Class in JDeveloper
  • 3.3.4 Java Libraries
    • 3.3.4.1 Overview of the Oracle JDBC Library
    • 3.3.4.2 Overview of the JSP Runtime Library
  • 3.3.5 Adding JDBC and JSP Libraries
  • 3.3.6 Importing JDBC Packages
  • 3.3.7 Declaring Connection-Related Variables
  • 3.3.8 Creating the Connection Method

4 Querying for and Displaying Data

• 4.1 Overview of Querying for Data in Oracle Database
  • 4.1.1 SQL Statements
  • 4.1.2 Query Methods for the Statement Object
  • 4.1.3 Result Sets
    • 4.1.3.1 Features of ResultSet Objects
    • 4.1.3.2 Summary of Result Set Object Types
• 4.2 Querying Data from a Java Application
  • 4.2.1 Creating a Method in JDeveloper to Query Data
  • 4.2.2 Testing the Connection and the Query Methods
• 4.3 Creating JSP Pages
  • 4.3.1 Overview of Page Presentation
    • 4.3.1.1 JSP Tags
    • 4.3.1.2 Scriptlets
    • 4.3.1.3 HTML Tags
    • 4.3.1.4 HTML Forms
  • 4.3.2 Creating a Simple JSP Page
  • 4.3.3 Adding Static Content to a JSP Page
  • 4.3.4 Adding a Style Sheet to a JSP Page
• 4.4 Adding Dynamic Content to the JSP Page: Database Query Results
  • 4.4.1 Adding a JSP useBean Tag to Initialize the DataHandler Class
  • 4.4.2 Creating a Result Set
  • 4.4.3 Adding a Table to the JSP Page to Display the Result Set
• 4.5 Filtering a Query Result Set
  • 4.5.1 Creating a Java Method for Filtering Results
  • 4.5.2 Testing the Query Filter Method
  • 4.5.3 Adding Filter Controls to the JSP Page
  • 4.5.4 Displaying Filtered Data in the JSP Page
• 4.6 Adding Login Functionality to the Application
  • 4.6.1 Creating a Method to Authenticate Users
  • 4.6.2 Creating a Login Page
  • 4.6.3 Preparing Error Reports for Failed Logins
  • 4.6.4 Creating the Login Interface
  • 4.6.5 Creating a JSP Page to Handle Login Action
• 4.7 Testing the JSP Page

5 Updating Data

• 5.1 Creating a JavaBean
  • 5.1.1 Creating a JavaBean in JDeveloper
  • 5.1.2 Defining the JavaBean Properties and Methods
• 5.2 Updating Data from a Java Class
  • 5.2.1 Creating a Method to Identify an Employee Record
  • 5.2.2 Creating a Method to Update Employee Data
  • 5.2.3 Adding a Link to Navigate to an Update Page
  • 5.2.4 Creating a JSP Page to Edit Employee Data
  • 5.2.5 Creating a JSP Page to Handle an Update Action
• 5.3 Inserting an Employee Record
  • 5.3.1 Creating a Method to Insert Data
  • 5.3.2 Adding a Link to Navigate to an Insert Page
  • 5.3.3 Creating a JSP Page to Enter New Data
  • 5.3.4 Creating a JSP Page to Handle an Insert Action
• 5.4 Deleting an Employee Record
  • 5.4.1 Creating a Method for Deleting Data
  • 5.4.2 Adding a Link to Delete an Employee
  • 5.4.3 Creating a JSP Page to Handle a Delete Action
• 5.5 Exception Handling
  • 5.5.1 Adding Exception Handling to Java Methods
  • 5.5.2 Creating a Method for Handling Any SQLException
• 5.6 Navigation in the Sample Application
  • 5.6.1 Creating a Starting Page for an Application

6 Enhancing the Application: Advanced JDBC Features

• 6.1 Using Dynamic SQL
  • 6.1.1 Using OraclePreparedStatement
  • 6.1.2 Using OracleCallableStatement
  • 6.1.3 Using Bind Variables
• 6.2 Calling Stored Procedures
  • 6.2.1 Creating a PL/SQL Stored Procedure in JDeveloper
  • 6.2.2 Creating a Method to Use the Stored Procedure
  • 6.2.3 Allowing Users to Choose the Stored Procedure
  • 6.2.4 Calling the Stored Procedure from the Application
• 6.3 Using Cursor Variables
  • 6.3.1 Oracle REF CURSOR Type Category
  • 6.3.2 Accessing REF CURSOR Data
  • 6.3.3 Using REF CURSOR in the Sample Application
    • 6.3.3.1 Creating a Package in the Database
    • 6.3.3.2 Creating a Database Function
    • 6.3.3.3 Calling the REF CURSOR from a Method
    • 6.3.3.4 Displaying a Dynamically Generated List

7 Creating a Master-Detail Application Using JPA and Oracle ADF

• 7.1 Overview of the Master-Detail Application
• 7.2 Using Java Persistence API (JPA) with Oracle ADF
  • 7.2.1 Java Persistence API (JPA)
  • 7.2.2 Oracle ADF Faces
  • 7.2.3 ADF Data Controls
• 7.3 Building the Data Model with EJB 3.0 Using the EJB Diagramer
  • 7.3.1 Creating an Application and Project
  • 7.3.2 Creating the Persistence Model
  • 7.3.3 Creating the Data Model
  • 7.3.4 Running the Java Service outside Java EE container
• 7.4 Create a New Project for the User Interface
• 7.5 Creating the Page Flow
• 7.6 Creating a Master-Detail JavaServer Faces Page
• 7.7 Creating a Query and Edit Page
• 7.8 Running the Application

8 Getting Unconnected from Oracle Database

• 8.1 Creating a Method to Close All Open Objects
• 8.2 Closing Open Objects in the Application

9 Building Global Applications

• 9.1 Developing Locale Awareness
  • 9.1.1 Mapping Between Oracle and Java Locales
• 9.2 Determining User Locales
  • 9.2.1 Locale Awareness in Java Applications
• 9.3 Encoding HTML Pages
  • 9.3.1 Specifying the Page Encoding for HTML Pages
  • 9.3.2 Specifying the Page Encoding in Java Servlets and JSP Pages
• 9.4 Organizing the Content of HTML Pages for Translation
  • 9.4.1 Strings in Java Servlets and JSP Pages
  • 9.4.2 Static Files
  • 9.4.3 Data from the Database
• 9.5 Presenting Data by User Locale Convention
  • 9.5.1 Oracle Date Formats
  • 9.5.2 Oracle Number Formats
  • 9.5.3 Oracle Linguistic Sorts
  • 9.5.4 Oracle Error Messages
• 9.6 Localizing Text on JSP Pages in JDeveloper
  • 9.6.1 Creating a Resource Bundle
  • 9.6.2 Using Resource Bundle Text on JSP Pages

Index