Skip Headers

Oracle® Application Developer's Guide - XML 10g (9.0.4) Part Number B12099-01 |
Home | Contents | Index

# 23
Using XML Transviewer Beans

This chapter contains the following sections:

- Accessing Oracle XML Transviewer Beans

- XDK for Java: XML Transviewer Bean Features

- Using the XML Transviewer Beans

- Using XMLSourceView Bean

- Using XMLTransformPanel Bean

- Using XSLTransformer Bean

- Using DOMBuilder Bean

- Using Treeviewer Bean

- Using DBViewer Bean

- Using DBAccess Bean

- Installing the Transviewer Bean Samples

- Transviewer Bean Example 1: AsyncTransformSample.java

- Transviewer Bean Example 2: ViewSample.java

- Transviewer Bean Example 3: XMLTransformPanelSample.java

- Transviewer Bean Example 4a: DBViewer Bean -- DBViewClaims.java

- Transviewer Bean Example 4b: DBViewer Bean -- DBViewFrame.java

- Transviewer Bean Example 4c: DBViewer Bean -- DBViewSample.java

## Accessing Oracle XML Transviewer Beans

The Oracle XML Transviewer beans are provided with Oracle Enterprise and Standard Editions from Release 2 (8.1.6) and higher, as part of XDK for Java Beans. If you do not have these editions you can download the beans from the site: http://otn.oracle.com/tech/xml

## XDK for Java: XML Transviewer Bean Features

XML Transviewer Beans facilitate the addition of graphical or visual interfaces to your XML applications.

#### Direct Access from JDeveloper

Bean encapsulation includes documentation and descriptors that can be accessed directly from Java Integrated Development Environments like JDeveloper.

#### Sample Transviewer Bean Application is Included

A sample application that demonstrates all of the beans to create a simple XML editor and XSL transformer is included with your software.

The included sample application with XML SQL Utility (XSU) cause the following:

- Database queries to materialize XML

- Transform the XML through an XSL stylesheet

- Store the resulting XML document back in the database for fast retrieval

### Database Connectivity

Database Connectivity is included with the XML Transviewer Beans. The beans can now connect directly to a JDBC-enabled database to retrieve and store XML and XSL files.

### XML Transviewer Beans

XML Transviewer Beans are comprised of the following beans:

#### DOMBuilder Bean

The DOMBuilder bean is a non-visual bean. It builds a DOMTree from an XML document.

DOM Builder bean encapsulates the XML Parser for Java's DOMParser class with a bean interface, and extends its functionality to permit asynchronous parsing. By registering a listener, Java applications can parse large or successive documents having control return immediately to the caller. See "Using DOMBuilder Bean" .

#### XSLTransformer Bean

The XSLTransformer bean is a non-visual bean. It accepts an XML file, applies the transformation specified by an input XSL stylesheet, and creates the resulting output file.

XSLTransformer bean enables you to transform an XML document to almost any text-based format including XML, HTML and DDL, by applying the appropriate XSL stylesheet.

- When integrated with other beans, XSLTransformer bean enables an application or user to view the results of transformations immediately.

- This bean can also be used as the basis of a server-side application or servlet to render an XML document, such as an XML representation of a query result, into HTML for display in a browser.

See "Using XSLTransformer Bean".

#### Treeviewer Bean

The Treeviewer bean displays XML formatted files graphically as a tree. The branches and leaves of this tree can be manipulated with a mouse. See "Using Treeviewer Bean" .

#### XMLSourceView Bean

The XMLSourceView bean is a visual Java bean. It allows visualization of XML documents and editing. It enables the display of XML and XSL formatted files with color syntax highlighting when modifying an XML document with an editing application. This helps view and edit the files. It can be easily integrated with DOM Builder bean, and allows for pre or post parsing visualization, and validation against a specified DTD. See "Using XMLSourceView Bean" .

#### XMLTransformPanel Bean

A visual Java bean that applies XSL transformations on XML documents and shows the results. It allows editing of XML and XSL input files. See "Using XMLTransformPanel Bean" .

#### DBViewer Bean

DBViewer bean is Java bean that can be used to display database queries or any XML by applying XSL stylesheets and visualizing the resulting HTML in a scrollable swing panel. DBViewer bean has XML and XSL tree buffers as well as a result buffer. DBViewer bean allows the calling program to do the following:

- Load or save buffers from various sources such as from CLOB tables in an Oracle database or from the file system. Control can be also used to move files between the file system and the user schema in the database.

- Apply stylesheet transformations to the XML buffer using the stylesheet in the XSL buffer.

The result can be stored in the result buffer. The XML and XSL buffer content can be shown as a source or tree structure. The result buffer content can be rendered as HTML and also shown as source or tree structure. The XML buffer can be loaded from a database query.

#### DBAccess Bean

DBAccess bean maintains CLOB tables that hold multiple XML and text documents.

## Using the XML Transviewer Beans

Guidelines for using the XML Transviewer Beans are described in the following sections:

- Using DOMBuilder Bean

- Using XSLTransformer Bean

- Using Treeviewer Bean

- Using XMLSourceView Bean

- Using XMLTransformPanel Bean

- Using DBViewer Bean

- Using DBAccess Bean

  See Also: Oracle9i XML Reference Chapter 3, "Oracle XML Developer Kits (XDKs) and Components: Overview and General FAQs".

## Using DOMBuilder Bean

DOMBuilder() class implements an eXtensible Markup Language (XML) 1.0 parser according to the World Wide Web Consortium (W3C) recommendation, to parse an XML document and build a DOM tree.

The parsing is done in a separate thread and DOMBuilderListener interface must be used for notification when the tree is built.

### Used for Asynchronous Parsing in the Background

DOM Builder bean encapsulates XML Parser for Java with a bean interface. It extends its functionality to permit asynchronous parsing. By registering a listener, a Java application can parse documents and return control return to the caller.

Asynchronous parsing in a background thread can be used interactively in visual applications. For example, when parsing a large file with the normal parser, the user interface can freeze till the parsing has completed. This can be avoided with the DOMBuilder bean. After calling the DOMBuilder bean parse method, the application can receive control back immediately and display "Parsing, please wait". If a "Cancel" button is included you can also cancel the operation. The application can continue when `domBuilderOver()` method is called by DOMBuilder bean when background parsing task has completed.

### DOMBuilder Bean Parses Many Files Fast

When parsing a large number of files, DOMBuilder bean can save you much time. Up to 40% faster times have been recorded when compared to parsing the files one by one.

### DOMBuilder Bean Usage

Figure 23-1 illustrates DOMBuilder Bean usage.

1. The XML document to be parsed is input as a file, string buffer, or URL.

2. This inputs `DOMBuilder.addDOMBuilderListener(DOMBuilderListener)`method. This adds DOMBuilderListener.

3. The DOMBuilder.parser() method parses the XML document.

4. Optionally, the parsed result undergoes further processing. See Table 23-1 for a list of available methods to apply.

5. DOMBuilderListener API is called using `DOMBuilderOver()` method. This is called when it received an async call from an application. This interface must be implemented to receive notifications about events during asynchronous parsing. The class implementing this interface must be added to the DOMBuilder using `addDOMBuilderListener` method.

   Available DOMBuilderListener methods are:

   - `domBuilderError(DOMBuilderEvent)`. This method is called when parse error occur.

   - `domBuilderOver(DOMBuilderEvent)`. This method is called when the parse is complete

   - `domBuilderStarted(DOMBuilderEvent)`. This method is called when parsing starts

6. `DOMBuilder.getDocument()` fetches the resulting DOM document and outputs the DOM document.

#### Figure 23-1 DOMBuilder Bean Usage

Text description of the illustration adxml080.gif

.

##### Table 23-1 DOMBuilder Bean: Methods

Method | Description
--- | ---
addDOMBuilderErrorListener(DOMBuilderErrorListener) | Adds DOMBuilderErrorListener
addDOMBuilderListener(DOMBuilderListener) | Adds DOMBuilderListener
| Get the DTD
getDocument() | Gets the document
getId() | Returns the parser object id.
getReleaseVersion() | Returns the release version of the Oracle XML Parser
| Gets the document
getValidationMode() | Returns the validation mode
parse(InputSource) | Parses the XML from given input source
| Parses the XML from given input stream.
parse(Reader) | Parses the XML from given input stream.
parse(String) | Parses the XML from the URL indicated
parse(URL) | Parses the XML document pointed to by the given URL and creates the corresponding XML document hierarchy.
parseDTD(InputSource, String) | Parses the XML External DTD from given input source
parseDTD(InputStream, String) | Parses the XML External DTD from given input stream.
parseDTD(Reader, String) | Parses the XML External DTD from given input stream.
| Parses the XML External DTD from the URL indicated
parseDTD(URL, String) | Parses the XML External DTD document pointed to by the given URL and creates the corresponding XML document hierarchy.
removeDOMBuilderErrorListener(DOMBuilderErrorListener) | Removes DOMBuilderErrorListener
removeDOMBuilderListener(DOMBuilderListener) | Removes DOMBuilderListener
run() | This method runs in a thread
| Set the base URL for loading external enitites and DTDs.
setDebugMode(boolean) | Sets a flag to turn on debug information in the document
setDoctype(DTD) | Sets the DTD
setErrorStream(OutputStream) | Creates an output stream for the output of errors and warnings.
setErrorStream(OutputStream, String) | Creates an output stream for the output of errors and warnings.
setErrorStream(PrintWriter) | Creates an output stream for the output of errors and warnings.
| Sets the node factory.
setPreserveWhitespace(boolean) | Sets the white space preserving mode
setValidationMode(boolean) | Sets the validation mode
showWarnings(boolean) | Switches to determine whether to print warnings

## Using XSLTransformer Bean

The XSLTransformer bean accepts an XML file and applies the transformation specified by an input XSL stylesheet, to create and output file. It enables you to transform an XML document to almost any text-based format including XML, HTML and DDL, by applying an XSL stylesheet.

When integrated with other beans, XSLTransformer bean enables an application or user to view the results of transformations immediately.

This bean can also be used as the basis of a server-side application or servlet to render an XML document, such as an XML representation of a query result, into HTML for display in a browser.

The XSLTransformer bean encapsulates the Java XML Parser XSLT processing engine with a bean interface and extends its functionality to permit asynchronous transformation.

By registering a listener, your Java application can transform large and successive documents by having the control returned immediately to the caller.

### Many Files to Transform? Use XSLTransformer Bean

XSL transformations can be time consuming. Use XSL Transformer bean in applications that transform large number of files. It can transform multiple files concurrently.

### Need a responsive User Interface? Use XSLTransformer Bean

XSLTransformer bean can be used for visual applications for a responsive user interface. There are similar issues here as with DOMBuilder bean.

By implementing `XSLTransformerListener()` method, the caller application can be notified when the transformation is complete. The application is free to perform other tasks in between requesting and receiving the transformation.

### XSL Transviewer Bean Scenario 1: Regenerating HTML -- Underlying Data Changes

This scenario illustrates one way of applying XSLTransformer bean.

1. Create a SQL query. Store the selected XML data in a CLOB table.

2. Using the XSLTransfomer bean, create an XSL stylesheet and interactively apply this to the XML data until you are satisfied by the data presentation. This can be HTML produced by the XSL transformation.

3. Now that you have the desired SQL (data selection) and XSL (data presentation), create a trigger on the table or view used by your SQL query. The trigger can execute a stored procedure. The stored procedure, can for example, do the following:

   - Run the query

   - Apply the stylesheet

   - Store the resulting HTML in a CLOB table.

4. This process can repeat whenever the source data table is updated.

   The HTML stored in the CLOB table always mirrors the last data stored in the tables being queried. A JSP (Java Server Page) can display the HTML.

   In this scenario, multiple end users do not produce multiple data queries that contribute to bigger loads to the database. The HTML is regenerated only when the underlying data changes and only then.

### XSLTransformer Bean Usage

Figure 23-2 illustrates the XSLTransformer bean usage. For examples of implementing this bean, see "Transviewer Bean Example 1: AsyncTransformSample.java".

#### Figure 23-2 XSLTransformer Bean Usage

Text description of the illustration adxml079.gif

1. An XSL stylesheet and XML document input the XSLTransformer using method: `XSLTransfomer.addXSLTransformerListener(XSLTransformerListener).` This adds a listener.

2. The XSLTransfomer.processXSL() method initiates the XSL transformation in the background.

3. Optionally, other work can be assigned to the XSLTransformer bean. Table 23-2 lists available XSLTransformer bean methods.

4. When the transformation is complete, an asynchronous call is made and the `XSLTransformerListener.xslTransformerOver()` method is called. This interface must be implemented in order to receive notifications about events during the asynchronous transformation. The class implementing this interface must be added to the XSLTransformer event queue using `addXSLTransformerListener` method.

5. XSLTransformer.getResult() method returns the XML document fragment for the resulting document.

6. It ouputs the XML document fragment.

   ##### Table 23-2 XSLTransformer Bean: Methods

   Method | Description
   --- | ---
   addXSLTransformerErrorListener(XSLTransformerErrorListener) | Adds an error event listener
   addXSLTransformerListener(XSLTransformerListener) | Adds a listener
   getId() | Returns the unique XSLTransformer id
   getResult() | Returns the document fragment for the resulting document.
   processXSL(XSLStylesheet, InputStream, URL) | Initiates XSL Transformation in the background.
   processXSL(XSLStylesheet, Reader, URL) | Initiates XSL Transformation in the background.
   processXSL(XSLStylesheet, URL, URL) | Initiates XSL Transformation in the background.
   processXSL(XSLStylesheet, XMLDocument) | Initiates XSL Transformation in the background.
   processXSL(XSLStylesheet, XMLDocument, OutputStream) | Initiates XSL Transformation in the background.
   removeDOMTransformerErrorListener(XSLTransformerErrorListener) | Removes an error event listener
   removeXSLTransformerListener(XSLTransformerListener) | Removes a listener
   run() |
   setErrorStream(OutputStream) | Sets the error stream used by the XSL processor
   showWarnings(boolean) | Sets the showWarnings flag used by the XSL processor

## Using Treeviewer Bean

The Treeviewer bean displays an XML document as a tree. It recognizes the following XML DOM nodes:

- Tag

- Attribute Name

- Attribute Value

- Comment

- CDATA

- PCDATA

- PI Data

- PI Name

- NOTATION Symbol

It takes as input an org.w3c.dom.Document object.

Figure 23-3, "Treeviewer Bean in Action: Displaying an XML Document as a Tree" shows how the Treeviewer bean displays the XML document and the editing options.

#### Figure 23-3 Treeviewer Bean in Action: Displaying an XML Document as a Tree

Text description of the illustration treeview.gif

Figure 23-4 illustrates XML Treeviewer bean usage. A DOM XML document is input to `XMLTreeView.setXMLDocument(doc)` method. This associates the XML Treeviewer with the XML document. Available Treeviewer bean methods are:

- getPreferredSize() -- Returns the XMLTreeView preferred size.

- setXMLDocument(Document) -- Associates the XMLTreeViewer with an XML document.

- updateUI() -- Forces the XMLTreeView to update/refresh the user interface.

#### Figure 23-4 XML Treeviewer Bean Usage

Text description of the illustration adxml077.gif

## Using XMLSourceView Bean

XMLSourceView bean is a visual Java bean that displays an XML document. It improves the viewing of XML and XSL files by color-highlighting the XML/XSL syntax. It also offers an Edit mode. XMLSourceView bean easily integrates with DOM Builder bean. It allows for pre or post parsing visualization and validation against a specified DTD.

XMLSourceView bean recognizes the following XML token types:

- Tag

- Attribute Name

- Attribute Value

- Comment

- CDATA

- PCDATA

- PI Data

- PI Name

- NOTATION Symbol

Each token type has a foreground color and font. The default color/font settings can be changed by the user. This takes as input, an org.w3c.dom.Document object.

### XMLSourceView Bean Usage

Figure 23-6 shows the XMLSourceView bean usage. This is part of the `oracle.xml.srcviewer` API. A DOM document inputs XMLSourceView.SetXMLDocument(Doc). The resulting DOM document is displayed. See "Transviewer Bean Example 2: ViewSample.java".

Figure 23-5, "XMLSourceView Bean in Action: Displaying an XML Document with Color Highlighting" displays an XML document with tags shown in blue, tag content in black and attributes in red.

#### Figure 23-5 XMLSourceView Bean in Action: Displaying an XML Document with Color Highlighting

Text description of the illustration sourcevi.gif

#### Figure 23-6 XMLSourceView Bean Usage

Text description of the illustration adxml078.gif

Table 23-3 lists the XMLSourceView methods.

##### Table 23-3 XMLSourceView Bean Methods

Method | Description
--- | ---
fontGet(AttributeSet) | Extracts and returns the font from a given attributeset.
fontSet(MutableAttributeSet, Font) | Sets the mutableattributeset font.
getAttributeNameFont() | Returns the Attribute Value font.
getAttributeNameForeground() | Returns the Attribute Name foreground color.
getAttributeValueFont() | Returns the Attribute Value font.
getAttributeValueForeground() | Returns the Attribute Value foreground color.
getBackground() | Returns the background color.
getCDATAFont() | Returns the CDATA font.
getCDATAForeground() | Returns the CDATA foreground color.
getCommentDataFont() | Returns the Comment Data font.
getCommentDataForeground() | Returns the Comment Data foreground color.
getEditedText() | Returns the edited text.
getJTextPane() | Returns the viewer JTextPane component.
getMinimumSize() | Returns the XMLSourceView minimal size.
getNodeAtOffset(int) | Returns the XML node at a given offset.
getPCDATAFont() | Returns the PCDATA font.
getPCDATAForeground() | Returns the PCDATA foreground color.
getPIDataFont() | Returns the PI Data font.
getPIDataForeground() | Returns the PI Data foreground color.
getPINameFont() | Returns the PI Name font.
getPINameForeground() | Returns the PI Data foreground color.
getSymbolFont() | Returns the NOTATION Symbol font.
getSymbolForeground() | Returns the NOTATION Symbol foreground color.
getTagFont() | Returns the Tag font.
getTagForeground() | Returns the Tag foreground color.
getText() | Returns the XML document as a String.
isEditable() | Returns boolean to indicate whether this object is editable.
selectNodeAt(int) | Moves the cursor to XML Node at offset i.
setAttributeNameFont(Font) | Sets the Attribute Name font.
setAttributeNameForeground(Color) | Sets the Attribute Name foreground color.
setAttributeValueFont(Font) | Sets the Attribute Value font.
setAttributeValueForeground(Color) | Sets the Attribute Value foreground color.
setBackground(Color) | Sets the background color.
setCDATAFont(Font) | Sets the CDATA font.
setCDATAForeground(Color) | Sets the CDATA foreground color.
setCommentDataFont(Font) | Sets the Comment font.
setCommentDataForeground(Color) | Sets the Comment foreground color.
setEditable(boolean) | Sets the specified boolean to indicate whether this object should be editable.
setPCDATAFont(Font) | Sets the PCDATA font.
setPCDATAForeground(Color) | Sets the PCDATA foreground color.
setPIDataFont(Font) | Sets the PI Data font.
setPIDataForeground(Color) | Sets the PI Data foreground color.
setPINameFont(Font) | Sets the PI Name font.
setPINameForeground(Color) | Sets the PI Name foreground color.
setSelectedNode(Node) | Sets the cursor position at the selected XML node.
setSymbolFont(Font) | Sets the NOTATION Symbol font.
setSymbolForeground(Color) | Sets the NOTATION Symbol foreground color.
setTagFont(Font) | Sets the Tag font.
setTagForeground(Color) | Sets the Tag foreground color.
setXMLDocument(Document) | Associates the XMLviewer with a XML document.

## Using XMLTransformPanel Bean

XMLTransformPanel visual bean applies XSL transformations to XML documents. It visualizes the result and allows editing of input XML and XSL documents and files. XMLTransformPanel bean requires no programmatic input. It is a component that interacts directly with you and is not customizable.

### XMLTransformPanel Bean Features

XMLTransformPanel bean has the following features:

- Imports and exports XML and XSL files from the file system, and XML, XSL, and HTML files from Oracle. With Oracle9i, XMLTransformPanel bean uses two-column CLOB tables. The first column stores the data name (file name) and the second stores the data text (file's data) in a CLOB. The bean lists all CLOB tables in your schema. When you click on a table, the bean lists its file names. You can also create or delete tables, retrieve or add files to the tables. This can be useful for organizing your information. See Figure 23-7, "XSLTransformPanel Bean in Action: Showing CLOB Table and Data Names"

  Note: CLOB tables created by the XSL Transformer bean can be used by trigger-based stored procedures to mirror tables or views in the database into HTML data held in these CLOB tables. See "XSL Transviewer Bean Scenario 1: Regenerating HTML -- Underlying Data Changes".

- Supports multiple database connections

- Creates XML from database result sets. This feature allows you to submit any SQL query to the database that you are currently connected. The bean converts the result set into XML and automatically loads this XML data into the bean's XML buffer for further processing.

- Edits XML and XSL data loaded into the bean.

- Applies XSL transformations to XML buffers and show the results. See With the bean, you can also export results to the file system or a CLOB in the database.

#### Transviewer Bean Application

The Transviewer bean is one application that illustrates the use of XMLTransform Panel bean. It can be used from a command line to perform the following actions:

- Edit and parse XML files

- Edit and apply XSL transformations

- Retrieve and save XML, XSL and result files in the file system or in Oracle

  See: "Transviewer Bean Example 3: XMLTransformPanelSample.java" for an example of how to use XMLTransformPanel.

#### Figure 23-7 XSLTransformPanel Bean in Action: Showing CLOB Table and Data Names

Text description of the illustration transpan.gif

## Using DBViewer Bean

DBViewer bean can be used to display database queries on any XML document by applying XSL stylesheets and visualizing the resulting HTML in a scrollable swing panel. See:

- Figure 23-8, "DBViewer Bean in Action: Entering a Database Query to Generate XML"

- Figure 23-9, "DBViewer Bean in Action: Viewing the XML Document After Transforming to HTM With XSL Stylesheet"

DBViewer bean has the following three buffers:

- XML

- XSL

- Result buffer

DBViewer bean API allows the calling program to load or save buffers from various sources and apply stylesheet transformation to the XML buffer using the stylesheet in the XSL buffer. Results can be stored in the result buffer.

#### Showing Content

Content in the XML and XSL buffers can be shown as a source or tree structure. Content in the result buffer content can be rendered as HTML and also shown as a source or tree structure.

#### Loading and Saving the Buffers

The XML buffer can be loaded using a database query. All the buffers can be loaded from and files saved from the following:

- CLOB tables in Oracle

- File system

Therefore, control can also be used to move files between the file system and the user schema in the database.

#### Figure 23-8 DBViewer Bean in Action: Entering a Database Query to Generate XML

Text description of the illustration dbview.gif

#### Figure 23-9 DBViewer Bean in Action: Viewing the XML Document After Transforming to HTM With XSL Stylesheet

Text description of the illustration htmlview.gif

### DBViewer Bean Usage

Figure 23-10 illustrates DBViewer bean's usage.

#### Figure 23-10 DBViewer Bean Usage Diagram

Text description of the illustration adxml095.gif

#### DBViewer Bean Methods

Table 23-4 lists the DBViewer bean methods.

##### Table 23-4 DBViewer Bean Methods

Method | Description
--- | ---
DBViewer() | Constructs a new instance.
getHostname() | Gets database host name
getInstancename() | Gets database instance name
getPassword() | Gets user password
getPort() | Gets database port number
getResBuffer() | Gets the content of the result buffer
getResCLOBFileName() | Gets result CLOB file name
getResCLOBTableName() | Gets result CLOB table name
getResFileName() | Gets Result file name
getUsername() | Gets user name
getXmlBuffer() | Gets the content of the XML buffer
getXmlCLOBFileName() | Gets XML CLOB file name
getXmlCLOBTableName() | Gets XML CLOB table name
getXmlFileName() | Gets XML file name
getXMLStringFromSQL(String) | Gets XML presentation of result set from SQL query
getXslBuffer() | Gets the content of the XSL buffer
getXslCLOBFileName() | Gets the XSL CLOB file name
getXslCLOBTableName() | Gets XSL CLOB table name
getXslFileName() | Gets XSL file name
loadResBuffer(String) | Loads the result buffer from file
loadResBuffer(String, String) | Loads the result buffer from CLOB file
loadResBufferFromClob() | Loads the result buffer from CLOB file
loadResBufferFromFile() | Loads the result buffer from file
loadXmlBuffer(String) | Loads the XML buffer from file
loadXmlBuffer(String, String) | Loads the XML buffer from CLOB file
loadXmlBufferFromClob() | Loads the XML buffer from CLOB file
loadXmlBufferFromFile() | Loads the XML buffer from file
loadXMLBufferFromSQL(String) | Loads the XML buffer from SQL result set
loadXslBuffer(String) | Loads the XSL buffer from file
loadXslBuffer(String, String) | Loads the XSL buffer from CLOB file
loadXslBufferFromClob() | Loads the XSL buffer from CLOB file
loadXslBufferFromFile() | Loads the XSL buffer from file
parseResBuffer() | Parses the result buffer and refresh the tree view and source view
parseXmlBuffer() | Parses the XML buffer and refresh the tree view and source view
parseXslBuffer() | Parses the XSL buffer and refresh the tree view and source view
saveResBuffer(String) | Saves the result buffer to file
saveResBuffer(String, String) | Saves the result buffer to CLOB file
saveResBufferToClob() | Saves the result buffer to CLOB file
saveResBufferToFile() | Saves the result buffer to file
saveXmlBuffer(String) | Saves the XML buffer to file
saveXmlBuffer(String, String) | Saves the XML buffer to CLOB file
saveXmlBufferToClob() | Saves the XML buffer to CLOB file
saveXmlBufferToFile() | Saves the XML buffer to file
saveXslBuffer(String) | Saves the XSL buffer to file
saveXslBuffer(String, String) | Saves the XSL buffer to CLOB file
saveXslBufferToClob() | Saves the XSL buffer to CLOB file
saveXslBufferToFile() | Saves the XSL buffer to file
setHostname(String) | Sets database host name
setInstancename(String) | Sets database instance name
setPassword(String) | Sets user password
setPort(String) | Sets database port number
setResBuffer(String) | Sets new text in the result buffer
setResCLOBFileName(String) | Sets Result CLOB file name
setResCLOBTableName(String) | Sets Result CLOB table name
setResFileName(String) | Sets Result file name
setResHtmlView(boolean) | Shows the result buffer as rendered HTML
setResSourceEditView(boolean) | Shows the result buffer as XML source and enter edit mode
setResSourceView(boolean) | Shows the result buffer as XML source
setResTreeView(boolean) | Shows the result buffer as XML tree view
setUsername(String) | Sets user name
setXmlBuffer(String) | Sets new text in the XML buffer
setXmlCLOBFileName(String) | Sets XML CLOB table name
setXmlCLOBTableName(String) | Sets XML CLOB table name
setXmlFileName(String) | Sets XML file name
setXmlSourceEditView(boolean) | Shows the XML buffer as XML source and enter edit mode
setXmlSourceView(boolean) | Shows the XML buffer as XML source
setXmlTreeView(boolean) | Shows the XML buffer as tree
setXslBuffer(String) | Sets new text in the XSL buffer
setXslCLOBFileName(String) | Sets XSL CLOB file name
setXslCLOBTableName(String) | Sets XSL CLOB table name
setXslFileName(String) | Sets XSL file name
setXslSourceEditView(boolean) | Shows the XSL buffer as XML source and enter edit mode
setXslSourceView(boolean) | Shows the XSL buffer as XML source
setXslTreeView(boolean) | Shows the XSL buffer as tree
transformToDoc() | Transfroms the content of the XML buffer by applying the stylesheet from the XSL buffer.
transformToRes() | Applies the stylesheet transformation from the XSL buffer to the XML in the XML buffer and stores the result into the result buffer
transformToString() | Transfroms the content of the XML buffer by applying the stylesheet from the XSL buffer.

## Using DBAccess Bean

DBAccess bean maintains CLOB tables that can hold multiple XML and text documents. Each table is created using the following statement:

    CREATE TABLE tablename FILENAME CHAR( 16) UNIQUE, FILEDATA CLOB) LOB(FILEDATA)
    STORE AS (DISABLE STORAGE IN ROW)

Each XML (or text) document is stored as a row in the table. The FILENAME field holds a unique string used as a key to retrieve, update, or delete the row. Document text is stored in the FILEDATA field. This is a CLOB object. CLOB tables are automatically maintained by the Transviewer bean. The CLOB tables maintained by DBAccess bean can be later used by the Transviewer bean. DBAccess bean does the following tasks:

- Creates and deletes CLOB tables

- Lists a CLOB table's contents

- Adds, replaces, or deletes text documents in the CLOB tables

### DBAcess Bean Usage

Figure 23-11 illustrates the DBAccess bean usage. It shows how DBAccess bean maintains, and manipulates XML documents stored in CLOBs.

#### Figure 23-11 DBAccess Bean Usage Diagram

Text description of the illustration adxml104.gif

#### DBAccess Bean Methods

Table 23-5 lists the DBAccess bean methods.

##### Table 23-5 DBAccess Bean Methods

Method | Description
--- | ---
createXMLTable(Connection, String) | Creates XML table
deleteXMLName(Connection, String, String) | Deletes text file from XML table
dropXMLTable(Connection, String) | Deletes XML table
getNameSize() | Returns the size of the field where the filename is kept.
getXMLData(Connection, String, String) | Retrieve text file from XML table
getXMLNames(Connection, String) | Returns all file names in XML table
getXMLTableNames(Connection, String) | Gets all XML tables with names starting with a given string
insertXMLData(Connection, String, String, String) | Inserts text file as a row in XML table
isXMLTable(Connection, String) | Checks if the table is XML table.
replaceXMLData(Connection, String, String, String) | Replaces text file as a row in XML table
xmlTableExists(Connection, String) | Checks if XML table exists.

## Running the Transviewer Bean Samples

The XDK for Java Transviewer bean sample/ directory contains sample Transviewer bean applications that illustrate how to use Oracle Transviewer beans. Oracle Transviewer beans toolset contains DOMBuilder, XMLSourceView, XMLTreeView, XSLTransformer, XMLTransformPanel, DBViewer, and DBAccess beans.

Table 23-6 lists the sample files in sample/.

##### Table 23-6 Transviewer Bean Sample Files in sample/

File Name | Description
--- | ---
booklist.xml | Sample XML file used by Example 1, 2, or 3
doc.xml | Sample XML file used by Example 1, 2, or 3
doc.html | Sample HTML file used by Examples 1, 2, or 3
doc.xsl | Sample input XSL file used by Examples 1, 2, or 3. doc.xsl is used by XSLTransformer.
emptable.xsl | Sample input XSL file used by Examples 1, 2, or 3
tohtml.xsl | Sample input XSL file used by Examples 1, 2, or 3. Transforms booklist.xml.
AsyncTransformSample.java See "Transviewer Bean Example 1: AsyncTransformSample.java". | Sample nonvisual application using XSLTransformer bean and DOMBuilder bean. It applies the XSLT stylesheet specified in doc.xsl on all *.xml files from the current directory. The results are in the files with extension.log.
ViewSample.java See "Transviewer Bean Example 2: ViewSample.java". | Sample visual application that uses XMLSourceView and XMLTreeView beans.It visualizes XML document files.
XMLTransformPanelSample.java See "Transviewer Bean Example 3: XMLTransformPanelSample.java". | A visual application that uses XMLTransformPanel bean. This bean uses all four beans from above. It applies XSL transformations on XML documents and shows the result Visualizes and allows editing of XML and XSL input files.
DBViewSample See: "Transviewer Bean Example 4a: DBViewer Bean -- DBViewClaims.java" "Transviewer Bean Example 4b: DBViewer Bean -- DBViewFrame.java" "Transviewer Bean Example 4c: DBViewer Bean -- DBViewSample.java" | A sample visual application that uses DBViewer bean to implement simple insurance claim handling application.

## Installing the Transviewer Bean Samples

The Transviewer beans require as a minimum JDK 1.1.6, and can be used with any version of JDK 1.2.

1. Download and install the following components used by the Transviewer beans:

   - Oracle JDBC Driver for thin client (jar file classes111.zip)

   - Oracle XML SQL Utility (jar file oraclexmlsql.jar)

   After installing this components, include classes111.zip and oraclexmlsql.jar in your classpath.

2. The beans and the samples use swing 1.1. If you use jdk1.2, go to step 3. If you use jdk1.1, you will need to download Swing 1.1 from Sun. After downloading Swing, add swingall.jar to your classpath.

3. Change JDKPATH in `Makefile` to point to your JDK path. In addition, on Windows NT, change the file separator as stated in the `Makefile`.

4. If you are not using the default database with a scott/tiger account, change USERID and PASSWORD in the Makefile to run Sample4

5. Run "make" to generate .class files.

6. Run the sample programs using commands:

   - gmake sample1

   - gmake sample2

   - gmake sample3

   - gmake sample4

7. Visualize the results in .log files using the ViewSample.

8. Use the XSLT document from './tohtml.xsl' to transform the XML document from './booklist.xml'.

A few .xml files are provided as test cases. An XSL stylesheet 'doc.xsl' is used by XSLTransformer.

Note: sample1 runs the XMLTransViewer program so that you can import and export XML files from Oracle, keep your XSL transformation files in Oracle, and apply stylesheets to XML interactively.

### Using Database Connectivity

To use the database connectivity feature in this program, you must know the following:

- Network name of the computer where Oracle or Oracle Application Server runs

- Port (usually 1521)

- Name of the oracle instance (usually orcl)

You also need an account with CREATE TABLE privilege.

You can try the default account scott with password tiger if it still enabled on your Oracle system.

### Running Makefile

The following is the `makefile` script:

    # Makefile for sample java files

    .SUFFIXES : .java .class

    CLASSES = ViewSample.class  AsyncTransformSample.class
    XMLTransformPanelSample.class

    # Change it to the appropriate separator based on the OS
    PATHSEP= :

    # Change this path to your JDK location. If you use JDK 1.1, you will need
    # to download also Swing 1.1 and add swingall.jar to your classpath.
    # You do not need to do this for JDK 1.2 since Swing is part of JDK 1.2
    JDKPATH = /usr/local/packages/jdk1.2

    # Make sure that the following product jar/zip files are in the classpath:
    # - Oracle JDBC driver for thin client (file classes111.zip)
    # - Oracle XML SQL Utility (file oraclexmlsql.jar)
    # You can download this products from technet.us.oracle.com

    #
    CLASSPATH
    :=$(CLASSPATH)$(PATHSEP)../lib/xmlparserv2.jar$(PATHSEP)../lib/xmlcomp.jar$(PATH
    SEP)../lib/jdev-rt.zip$(PATHSEP).$(PATHSEP)
    %.class: %.java
    	$(JDKPATH)/bin/javac -classpath "$(CLASSPATH)" $<

    # make all class files
    all: $(CLASSES)

    sample1: XMLTransformPanelSample.class
    	$(JDKPATH)/bin/java -classpath "$(CLASSPATH)" XMLTransformPanelSample
    sample2: ViewSample.class
    	$(JDKPATH)/bin/java -classpath "$(CLASSPATH)" ViewSample
    sample3: AsyncTransformSample.class
    	$(JDKPATH)/bin/java -classpath "$(CLASSPATH)" AsyncTransformSample

### Transviewer Bean Example 1: AsyncTransformSample.java

This example shows you how to use DOMBuilder and the XSLTransformer beans to asynchronously transform multiple XML files.

    import java.net.URL;
    import java.net.MalformedURLException;
    import java.io.IOException;
    import java.io.InputStream;
    import java.io.ObjectInputStream;
    import java.io.OutputStream;
    import java.io.File;
    import java.io.FileOutputStream;
    import java.io.PrintWriter;
    import java.util.Vector;

    import org.w3c.dom.DocumentFragment;
    import org.w3c.dom.DOMException;

    import oracle.xml.async.DOMBuilder;
    import oracle.xml.async.DOMBuilderEvent;
    import oracle.xml.async.DOMBuilderListener;
    import oracle.xml.async.DOMBuilderErrorEvent;
    import oracle.xml.async.DOMBuilderErrorListener;
    import oracle.xml.async.XSLTransformer;
    import oracle.xml.async.XSLTransformerEvent;
    import oracle.xml.async.XSLTransformerListener;
    import oracle.xml.async.XSLTransformerErrorEvent;
    import oracle.xml.async.XSLTransformerErrorListener;
    import oracle.xml.async.ResourceManager;
    import oracle.xml.parser.v2.DOMParser;
    import oracle.xml.parser.v2.XMLDocument;
    import oracle.xml.parser.v2.XSLStylesheet;
    import oracle.xml.parser.v2.*;

    public class AsyncTransformSample
    {
      /**
       *  uses DOMBuilder bean
       */
       void runDOMBuilders ()
       {
          rm = new ResourceManager (numXMLDocs);

          for (int i = 0; i < numXMLDocs; i++)
          {
             rm.getResource();

             try
             {
                DOMBuilder builder = new DOMBuilder(i);

                URL  xmlURL = createURL(basedir + "/" +
                                      (String)xmlfiles.elementAt(i));
                if (xmlURL == null)
                   exitWithError("File " + (String)xmlfiles.elementAt(i) +
                                 " not found");

                builder.setPreserveWhitespace(true);
                builder.setBaseURL (createURL(basedir + "/"));
                builder.addDOMBuilderListener (new DOMBuilderListener() {
                   public void domBuilderStarted(DOMBuilderEvent p0) {}
                   public void domBuilderError(DOMBuilderEvent p0) {}
                   public synchronized void domBuilderOver(DOMBuilderEvent p0)
                   {
                      DOMBuilder bld = (DOMBuilder)p0.getSource();
                      runXSLTransformer (bld.getDocument(), bld.getId());
                   }
                });
                builder.addDOMBuilderErrorListener (new DOMBuilderErrorListener() {
                   public void domBuilderErrorCalled(DOMBuilderErrorEvent p0)
                   {
                      int id = ((DOMBuilder)p0.getSource()).getId();
                      exitWithError("Error occurred while parsing " +
                         xmlfiles.elementAt(id) + ": " +
                         p0.getException().getMessage());
                   }
                });
                builder.parse (xmlURL);

                System.err.println("Parsing file " + xmlfiles.elementAt(i));
             }
             catch (Exception e)
             {
                exitWithError("Error occurred while parsing " +
                              (String)xmlfiles.elementAt(i) + ": " +
                              e.getMessage());
             }
          }
       }

      /**
       *  uses XSLTransformer bean
       */
       void runXSLTransformer (XMLDocument xml, int id)
       {
          try
          {
             XSLTransformer processor = new XSLTransformer (id);
             XSLStylesheet  xsl       = new XSLStylesheet (xsldoc, xslURL);

             processor.showWarnings (true);
             processor.setErrorStream (errors);
             processor.addXSLTransformerListener (new XSLTransformerListener() {
                public void xslTransformerStarted (XSLTransformerEvent p0) {}
                public void xslTransformerError(XSLTransformerEvent p0) {}
                public void xslTransformerOver (XSLTransformerEvent p0)
                {
                   XSLTransformer trans = (XSLTransformer)p0.getSource();
                   saveResult (trans.getResult(),  trans.getId());
                }
             });
       processor.addXSLTransformerErrorListener (new XSLTransformerErrorListener() {
       public void xslTransformerErrorCalled(XSLTransformerErrorEvent p0)
                {
                   int i = ((XSLTransformer)p0.getSource()).getId();
                   exitWithError("Error occurred while processing " +
                         xmlfiles.elementAt(i) + ": " +
                         p0.getException().getMessage());
                 }
             });
             processor.processXSL (xsl, xml);
             // transform xml document
          }
          catch (Exception e)
          {
             exitWithError("Error occurred while processing " + xslFile + ": " +
                           e.getMessage());
          }
        }

        void saveResult (DocumentFragment result, int id)
        {
          System.err.println("Transforming '" + xmlfiles.elementAt(id) +
                   "' to '" + xmlfiles.elementAt(id) + ".log'" +
                   " applying '" + xslFile);

          try
          {
              File resultFile = new File((String)xmlfiles.elementAt(id) + ".log");

              ((XMLNode)result).print(new FileOutputStream(resultFile));
          }
          catch (Exception e)
          {
             exitWithError("Error occurred while generating output : " +
                           e.getMessage());
          }

          rm.releaseResource();
       }

       void makeXSLDocument ()
       {
          System.err.println ("Parsing file " + xslFile);
          try
          {
             DOMParser parser = new DOMParser();
             parser.setPreserveWhitespace (true);
             xslURL = createURL (xslFile);
             parser.parse (xslURL);
             xsldoc = parser.getDocument();
          }
          catch (Exception e)
          {
             exitWithError("Error occurred while parsing " + xslFile + ": " +
                           e.getMessage());
          }
       }

       private URL createURL(String fileName) throws Exception
       {
          URL url = null;

          try
          {
             url = new URL(fileName);
          }
          catch (MalformedURLException ex)
          {
             File f = new File(fileName);

             try
             {
                String path = f.getAbsolutePath();
                // This is a bunch of weird code that is required to
                // make a valid URL on the Windows platform, due
                // to inconsistencies in what getAbsolutePath returns.
                String fs = System.getProperty("file.separator");
                if (fs.length() == 1)
                {
                   char sep = fs.charAt(0);
                   if (sep != '/')
                      path = path.replace(sep, '/');
                   if (path.charAt(0) != '/')
                      path = '/' + path;
                }
                path = "file://" + path;
                url = new URL(path);
             }
             catch (MalformedURLException e)
             {
                exitWithError("Cannot create url for: " + fileName);
             }
          }

          return url;
       }

       boolean init () throws Exception
       {
          File     directory = new File (basedir);
          String[] dirfiles = directory.list();
          for (int j = 0; j < dirfiles.length; j++)
          {
             String dirfile = dirfiles[j];

             if (!dirfile.endsWith(".xml"))
                 continue;

              xmlfiles.addElement(dirfile);
          }

          if (xmlfiles.isEmpty()) {
          System.out.println("No files in directory were selected for processing");
             return false;
          }
          numXMLDocs = xmlfiles.size();

          return true;
       }

       private void exitWithError(String msg)
       {
          PrintWriter errs = new PrintWriter(errors);
          errs.println(msg);
          errs.flush();
          System.exit(1);
       }

       void asyncTransform () throws Exception
       {
          System.err.println (numXMLDocs +
                   " XML documents will be transformed" +
                   " using XSLT stylesheet specified in " + xslFile +
                   " with " +  numXMLDocs + " threads");

          makeXSLDocument ();
          runDOMBuilders ();

          // wait for the last request to complete
          while (rm.activeFound())
             Thread.sleep(100);

       }
       String       basedir = new String (".");
       OutputStream errors = System.err;

       Vector xmlfiles = new Vector();
       int    numXMLDocs = 1;

       String      xslFile = new String ("doc.xsl");
       URL         xslURL;
       XMLDocument xsldoc;

       private ResourceManager rm;

       /**
        *   main
        */
       public static void main (String args[])
       {
          AsyncTransformSample inst = new AsyncTransformSample();

          try
          {
             if (!inst.init())
                System.exit(0);

             inst.asyncTransform ();
          }
          catch (Exception e)
          {
             e.printStackTrace();
          }

          System.exit(0);
       }
    }

### Transviewer Bean Example 2: ViewSample.java

This example shows you how to use XMLSourceView and XMLTreeView beans to visually represent XML files.

    import java.awt.*;
    import oracle.xml.srcviewer.*;
    import oracle.xml.treeviewer.*;
    import oracle.xml.parser.v2.XMLDocument;
    import oracle.xml.parser.v2.*;
    import org.w3c.dom.*;
    import java.net.*;
    import java.io.*;
    import java.util.*;
    import java.awt.event.*;
    import javax.swing.*;
    import javax.swing.event.*;

    public class ViewSample
    {

      public static void main(String[] args)
      {
         String fileName = new String ("booklist.xml");
         if (args.length > 0) {
            fileName = args[0];
         }

         JFrame        frame         = setFrame ("XMLViewer");
         XMLDocument   xmlDocument   = getXMLDocumentFromFile (fileName);
         XMLSourceView xmlSourceView = setXMLSourceView (xmlDocument);
         XMLTreeView   xmlTreeView   = setXMLTreeView (xmlDocument);
         JTabbedPane   jtbPane       = new JTabbedPane ();

         jtbPane.addTab ("Source", null, xmlSourceView, "XML document sorce view");
         jtbPane.addTab ("Tree", null, xmlTreeView, "XML document tree view");
         jtbPane.setPreferredSize (new Dimension(400,300));
         frame.getContentPane().add (jtbPane);

         frame.setTitle    (fileName);
         frame.setJMenuBar (setMenuBar());
         frame.setVisible  (true);
      }

      static JFrame setFrame (String title)
      {
        JFrame frame = new JFrame (title);
        //Center the window
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize  = frame.getSize();
        if (frameSize.height > screenSize.height) {
           frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
          frameSize.width = screenSize.width;
        }
        frame.setLocation ((screenSize.width - frameSize.width)/2,
                          (screenSize.height - frameSize.height)/2);
        frame.addWindowListener(new WindowAdapter() {
           public void windowClosing(WindowEvent e) {
              System.exit(0);
           }
        });
        frame.getContentPane().setLayout (new BorderLayout());
        frame.setSize(new Dimension(400, 300));
        frame.setVisible (false);
        frame.setTitle (title);

        return frame;
      }

      static JMenuBar setMenuBar ()
      {
         JMenuBar menuBar = new JMenuBar();
         JMenu    menu    = new JMenu ("Exit");
         menu.addMenuListener ( new MenuListener () {
           public void menuSelected (MenuEvent ev) { System.exit(0); }
           public void menuDeselected (MenuEvent ev) {}
           public void menuCanceled (MenuEvent ev) {}
         });
         menuBar.add (menu);
         return menuBar;
      }

      /**
       * creates  XMLSourceView object
       */
      static XMLSourceView setXMLSourceView(XMLDocument xmlDocument)
      {
        XMLSourceView xmlView = new XMLSourceView();

        xmlView.setXMLDocument(xmlDocument);
        xmlView.setBackground(Color.yellow);
        xmlView.setEditable(true);
        return xmlView;
      }
      /**
       * creates  XMLTreeView object
       */
      static XMLTreeView setXMLTreeView(XMLDocument xmlDocument)
      {
        XMLTreeView xmlView = new XMLTreeView();

        xmlView.setXMLDocument(xmlDocument);
        xmlView.setBackground(Color.yellow);
        return xmlView;
      }

      static XMLDocument getXMLDocumentFromFile (String fileName)
      {
        XMLDocument doc = null;

        try  {
          DOMParser parser = new DOMParser();
          try {
             String dir= "" ;
             FileInputStream in = new FileInputStream(fileName);
             parser.setPreserveWhitespace(false);
             parser.setBaseURL(createURL(dir));
             parser.parse(in);
             in.close();
          } catch (Exception ex) {
             ex.printStackTrace();
             System.exit(0);
          }

          doc = (XMLDocument)parser.getDocument();

          try {
             doc.print(System.out);
          } catch (Exception ie) {
             ie.printStackTrace();
             System.exit(0);
          }

        }
        catch (Exception e) {
          e.printStackTrace();
        }
        return doc;
      }

      static URL createURL(String fileName)
      {
          URL url = null;
          try
          {
             url = new URL(fileName);
          }
          catch (MalformedURLException ex)
          {
             File f = new File(fileName);
             try
             {
                String path = f.getAbsolutePath();
                String fs = System.getProperty("file.separator");
                if (fs.length() == 1)
                {
                   char sep = fs.charAt(0);
                   if (sep != '/')
                      path = path.replace(sep, '/');
                   if (path.charAt(0) != '/')
                      path = '/' + path;
                }
                path = "file://" + path;
                url = new URL(path);
             }
             catch (MalformedURLException e)
             {
                System.out.println("Cannot create url for: " + fileName);
                System.exit(0);
             }
          }
          return url;
       }
    }

### Transviewer Bean Example 3: XMLTransformPanelSample.java

This example is an interactive application that uses XMLTransformPanel bean to do the following:

- Generate XML from database queries

- Transform the XML using XSL stylesheets

- View the results

- Store the results in CLOB tables in the database

      import java.awt.*;
      import java.awt.event.*;
      import javax.swing.*;
      import oracle.xml.transviewer.XMLTransformPanel;

      public class XMLTransformPanelSample
      {
        XMLTransformPanel transformPanel = new XMLTransformPanel();

        /**
         * Adjust frame size and add transformPanel to it.
         */
        public XMLTransformPanelSample ()
        {
          Frame     frame      = new JFrame();
          Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
          frame.setSize(510,550);
          transformPanel.setPreferredSize(new Dimension(510,550));
          Dimension frameSize = frame.getSize();

          if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
          }
          if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
          }
          frame.setLocation ((screenSize.width - frameSize.width)/2,
                            (screenSize.height - frameSize.height)/2);
          frame.addWindowListener(new WindowAdapter() {
             public void windowClosing(WindowEvent e) { System.exit(0); }
          });
          frame.setVisible(true);

          ((JFrame)frame).getContentPane().add (transformPanel);
          frame.pack();
        }

        /**
         *  main(). Only creates XMLTransformPanelSample object.
         */
        public static void main (String[] args)
        {
          new XMLTransformPanelSample ();
        }
      }

### Transviewer Bean Example 4a: DBViewer Bean -- DBViewClaims.java

This is an interactive example which lets you input the name or policy of an insurance claim. The appropriate claim is loaded as an XML buffer from the result set of an XML query. An XSL stylesheet is loaded from the file system. The DBViewer bean transforms the XML buffer using the XSL stylesheet to HTML. This HTML output can then be viewed.

    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.*;
    import oracle.jdeveloper.layout.*;
    import oracle.xml.dbviewer.*;

    public class DBViewClaims extends JPanel {
      DBViewer dbPanel= new DBViewer();
      JButton searchButton = new JButton();
      XYLayout xYLayout1 = new XYLayout();
      JLabel titleLabel = new JLabel();
      JLabel nameLabel = new JLabel();
      JLabel policyLabel = new JLabel();
      JTextField nameTF = new JTextField();
      JTextField policyTF = new JTextField();
      JButton viewXMLButton = new JButton();
      JButton viewXSLButton = new JButton();
      JButton viewHTMLButton = new JButton();
      public DBViewClaims() {
        super();
        try  {
          jbInit();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
      }
      private void jbInit() throws Exception {
        setBackground(SystemColor.controlLtHighlight);
        this.setLayout(xYLayout1);
        searchButton.setText("searchButton");
        searchButton.setLabel("Search");
        xYLayout1.setHeight(464);
        xYLayout1.setWidth(586);
        titleLabel.setText("List of Claims");
        titleLabel.setHorizontalAlignment(SwingConstants.CENTER);
        titleLabel.setBackground(new Color(192, 192, 255));
        titleLabel.setFont(new Font("Dialog", 1, 16));
        nameLabel.setText("Last Name");
        policyLabel.setText("Policy:");
        viewXMLButton.setText("viewXMLButton");
        viewXMLButton.setLabel("view XML");
        viewXMLButton.addActionListener(new java.awt.event.ActionListener() {
          public void actionPerformed(ActionEvent e) {
            viewXMLButton_actionPerformed(e);
          }
        });
        viewXSLButton.setText("viewXSLButton");
        viewXSLButton.setLabel("view XSL");
        viewXSLButton.addActionListener(new java.awt.event.ActionListener() {
          public void actionPerformed(ActionEvent e) {
            viewXSLButton_actionPerformed(e);
          }
        });
        viewHTMLButton.setText("viewHTMLButton");
        viewHTMLButton.setLabel("view HTML");
        viewHTMLButton.addActionListener(new java.awt.event.ActionListener() {

          public void actionPerformed(ActionEvent e) {
            viewHTMLButton_actionPerformed(e);
          }
        });

         searchButton.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(ActionEvent e) {
              searchButton_actionPerformed(e);
            }
         });

        this.add(dbPanel, new XYConstraints(16, 55, 552, 302));
        this.add(searchButton, new XYConstraints(413, 415, 154, 29));
        this.add(titleLabel, new XYConstraints(79, 10, 413, 31));
        this.add(nameLabel, new XYConstraints(333, 373, 72, -1));
        this.add(policyLabel, new XYConstraints(334, 395, 59, -1));
        this.add(nameTF, new XYConstraints(413, 368, 155, -1));
        this.add(policyTF, new XYConstraints(413, 391, 156, -1));
        this.add(viewXMLButton, new XYConstraints(19, 359, 94, 29));
        this.add(viewXSLButton, new XYConstraints(19, 390, 94, 29));
        this.add(viewHTMLButton, new XYConstraints(19, 421, 94, 29));
        updateUI();
      }
      void searchButton_actionPerformed(ActionEvent e) {
        String sqlText="select * from s_claim c ";
        try {
          if (!nameTF.getText().equals("")) {
             sqlText=sqlText+" where c.claimpolicy.primaryinsured.lastname="+
                     "'"+nameTF.getText()+"'";
          } else if (!policyTF.getText().equals("")) {
             sqlText=sqlText+" where c.claimpolicy.policyid="+
                     policyTF.getText();
          }
          dbPanel.setUsername("scott");
          dbPanel.setPassword("tiger");
          dbPanel.setInstancename("orcl");
          dbPanel.setHostname("localhost");
          dbPanel.setPort("1521");
          dbPanel.loadXMLBufferFromSQL(sqlText);
          dbPanel.loadXslBuffer("xslfiles","CLAIM.XSL");
          dbPanel.transformToRes();
          dbPanel.setResHtmlView(true);
        } catch (Exception e1) {
          System.out.println(e1);
        }
      }
      void viewXMLButton_actionPerformed(ActionEvent e) {
        dbPanel.setXmlSourceEditView(true);
      }
      void viewXSLButton_actionPerformed(ActionEvent e) {
        dbPanel.setXslSourceEditView(true);
      }
      void viewHTMLButton_actionPerformed(ActionEvent e) {
        dbPanel.setResHtmlView(true);
      }
    }

### Transviewer Bean Example 4b: DBViewer Bean -- DBViewFrame.java

This example provides a frame with a menu bar to access the DBView Claims functionality. Claims can then be loaded and displayed in HTML.

    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.*;
    import oracle.jdeveloper.layout.*;

    public class DBViewFrame extends JFrame {
      JMenuBar menuBar1 = new JMenuBar();
      JMenu menuFile = new JMenu();
      JMenuItem menuFileExit = new JMenuItem();
      JMenuItem menuListCustomerClaims = new JMenuItem();

      public DBViewFrame() {
        super();
        try  {
          jbInit();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
      }
      private void jbInit() throws Exception {
        this.getContentPane().setLayout(new GridLayout(1,1));
        this.setSize(new Dimension(600, 550));
        menuFile.setText("File");
        menuFileExit.setText("Exit");
        menuListCustomerClaims.setText("List Claims");
        menuFileExit.addActionListener(new ActionListener() {
          public void actionPerformed(ActionEvent e) {
            fileExit_ActionPerformed(e);
          }
        });
        menuListCustomerClaims.addActionListener(new ActionListener() {
          public void actionPerformed(ActionEvent e) {
             ListCustomerClaims_ActionPerformed(e);

          }
        });
        menuFile.add(menuFileExit);
        menuFile.add(menuListCustomerClaims);
        menuBar1.add(menuFile);
        this.setJMenuBar(menuBar1);
        this.setBackground(SystemColor.controlLtHighlight);
      }
      void fileExit_ActionPerformed(ActionEvent e) {
        System.exit(0);
      }
      void ListCustomerClaims_ActionPerformed(ActionEvent e) {
        this.getContentPane().removeAll();
        this.getContentPane().add(new DBViewClaims());
        this.getContentPane().paintAll(this.getGraphics());
      }
    }

### Transviewer Bean Example 4c: DBViewer Bean -- DBViewSample.java

This example simply provides a main function which instantiates DBViewFrame, giving it a specific look and feel.

    import java.awt.*;
    import java.awt.event.*;
    import javax.swing.*;
    public class DBViewSample {
      public DBViewSample() {
        DBViewFrame frame = new DBViewFrame();
        frame.setVisible(true);
      }
      public static void main(String[] args) {
        try  {
          UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
        }
        catch (Exception e) {
          e.printStackTrace();
        }
        new DBViewSample();
      }
    }

| Copyright © 2001, 2003 Oracle Corporation. All Rights Reserved. |
Home | Contents | Index