 | Level: Introductory Nicholas Chase (nicholas@nicholaschase.com), Author
24 Oct 2001 This tutorial explains the basics of retrieving data from a database into a DOM document, transforming the DOM document into a second document, and inserting the data from the second document into the database using updatable ResultSets in Java. (Though the examples are all written in Java, the concepts are the same in any programming language and the tutorial can assist any developer who wants to learn how to manipulate data with XSLT.) Several of the more advanced features of XSLT and XPath are covered, demonstrating some of the ways that XSLT style sheets can be used to emulate the programming capabilities of database stored procedures.
Prerequisites
This tutorial assumes you are already familiar with the basics of XML in general, the Document Object Model (DOM) in particular, and with the basics of XSLT and XPath. All of the examples use Java, with JDBC for database access, but you can still get a basic grounding in the concepts without trying out the examples.
System requirements
You will need JavaScript enabled on your browser. You will also need:
- A text editor: XML and Java source files are simply text. To create and read them, a text editor is all you need.
- A Java environment such as the Java 2 SDK, or the IBM JDK.
- Any database that understands SQL, as long as you have an ODBC or JDBC driver. (If you have an ODBC driver, you can skip this step and use the JDBC-ODBC bridge, which is included as part of the Java 2 SDK.) This tutorial uses JDataConnect.
- Java APIs for XML Processing, version 1.1 or later. Also known as JAXP, this is the reference implementation that Sun provides.
Duration
Under one hour
Formats html, pdf
| | | |
