1/16
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 XE
1.1
Using Java to Connect to Oracle Database XE
1.1.1
Oracle JDBC Thin Driver
1.1.2
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
Resources
2
Getting Started with the Application
2.1
What You Need to Install
2.1.1
Oracle Database XE
2.1.1.1
Modifying the HR Schema for the JDBC Application
2.1.2
J2SE or JDK
2.1.3
Integrated Development Environment
2.1.4
Web Server
2.2
Verifying the Oracle Database XE 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 XE
3.1
Connecting to Oracle Database XE 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 XE from a Java Application
3.3.1
Overview of Connecting to Oracle Database XE
3.3.2
Specifying Database URLs
3.3.2.1
Using the Default Service Feature of the Oracle Database XE
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 XE
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
Enabling 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
Getting Unconnected from Oracle Database XE
7.1
Creating a Method to Close All Open Objects
7.2
Closing Open Objects in the Application
8
Creating a Universal Connection Pool
8.1
Setting JDeveloper Project Properties
8.2
Creating the Stock Ticker Application
8.3
Observing the Output
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
Scripting on this page enhances content navigation, but does not change the content in any way.