Oracle9i XML Sample:
Employee Information Sample with the Oracle 9i XDK for Java

April 2002

OTN developers have built sample applications that demonstrate the features of Oracle XML Developer's Kits(XDK) for Java and Oracle9i native XML support. The Employee Information sample application manages employee information in the database. It provides interface for Adding, Updating, Deleting and Viewing of Employee Information stored in the database. All database operations and presentation of data to the user in the application are done through the XSQL pages publishing framework which is available as part of the Oracle XML Developer's Kit(XDK) for Java.

This sample demonstrates the following features of the XSQL Pages Publishing Framework:

• Using XSQL pages for insertion, updation and deletion of data in the database
• Database Connection in XSQL pages using XSQLConfig file
• XSL Transformations from XML to HTML through XSQL pages
• Use of Bind and Lexical References in XSQL pages
• Assigning Stylesheets Dynamically in XSQL pages

Prerequisite:

• Oracle9i Database
• Oracle XML Developer's Kit(XDK) for Java version 9.2.0.2.0
• Oracle9iAS Containers for J2EE(OC4J) 2.0

Download the Sample

The download includes installation instructions, Java source code, XSQL source code and SQL scripts for building the database.

• Download the Employee Information Sample
• Readme
• Install

Related Documents

• XML Developer's Kits Guide
• XSQL Pages Publishing Framework
• Using Core built-in XSQL Actions
• Transforming XML with XSLT