Skip Headers

Oracle® COM Automation Feature Developer's Guide
10g Release 1 (10.1)

Part Number B10116-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

5 Oracle COM Automation Java Demos

This chapter describes how to use the demonstration program designed for Oracle COM Automation Feature for Java.

This chapter contains these topics:

Oracle COM Automation Feature Java Demos Overview

Oracle COM Automation Feature for Java includes an example that demonstrates how to use the feature to build solutions. The demo provides base functionality and can serve as a foundation on which to build more customized, complex applications that use COM Automation. This demo is based on the human resources schema available with the sample schema.

The demo exposes a core set of APIs that enable you to do simple operations using COM Automation Feature. Each COM Automation server, such as Word and Excel, provides more advanced capabilities than what is offered through the demo APIs. To take advantage of these advanced features, you must design and code your own Java classes.

In this release, COM Automation has provided the following demo:

Microsoft Word Java Demo

The following sections describe how to install the Microsoft Word Java demo and the APIs that it exposes. This demo is provided as an example of the types of solutions that can be built with Oracle and Microsoft Word.

The demo creates a Microsoft Word document containing the names of employees in the database.

The Microsoft Word Java demo is installed in the ORACLE_BASE\ORACLE_HOME\com\java\demos directory and provides the following:

Installing the Microsoft Word Java Demo

Microsoft Word must be installed on the local computer before installing this demo.

To install the demo:

  1. Run loadjava from the command line:

    loadjava -force -resolve -user hr/hr ORACLE_BASE\ORACLE_HOME\com\java\demos\TestWORD.class
    
    
  2. Start SQL*Plus.

    C:\> sqlplus /NOLOG
    
    
  3. Connect to the Oracle database instance as the user that will use the Microsoft Word demo. For example:

    SQL> connect hr/hr
    
    
  4. Run TestWORD.sql to create the call spec:

    SQL> @ORACLE_BASE\ORACLE_HOME\com\java\demos\TestWORD.sql
    

    See Also:

    Oracle Database Java Developer's Guide for further information on the loadjava tool and call specs

Using the Microsoft Word Java Demo

To use the Word demo:

  1. Set SERVEROUTPUT on at the SQL*Plus prompt:

    SQL> SET SERVEROUTPUT ON
    
    
  2. Call TestWORD() at the SQL*Plus prompt:

    SQL> CALL TestWORD();
    
    

    This creates a Microsoft Word document (worddemoj.doc) in the C:\directory. The document contains data from the EMPLOYEES and JOBS tables. These tables are available in the human resources schema in the sample schema.

  3. Open wordemoj.doc to see its contents.

Creating a Custom Application

public class TestWORD as described in "Core Functionality" , provides a wrapper around the Word.Basic COM Automation class as well as some sample code which demonstrates how to use the wrapper. This code was written to be run on the Oracle database server.

To create a custom application which uses this wrapper:

  1. Instantiate an object of this class.

  2. Create the Word.Basic object by calling the method CreateWordObject.

  3. Create a new Microsoft Word document with the method FileNew, or open an existing document with the method FileLoad.

  4. Use the methods FormatFontSize, InsertText, InsertNewLine to add text and formatting to the document.

  5. Save the document with FileSaveAs or FileSave.

  6. Call the method FileClose when you are finished with the document.

  7. Call the method DestroyWordObject when you are finished with the Word.Basic object.

Core Functionality

The following subsections describe the APIs that the Microsoft Word Java demo exposes. These APIs are primitive. Be aware that much of the functionality that Microsoft Word exposes through COM Automation is not exposed through these APIs.


TestWORD

The constructor. It does nothing.


Syntax
public TestWORD()

CreateWordObject

Creates the Word.Basic COM object.


Syntax
public void CreateWordObject(java.lang.String servername)

Where Is
servername the server on which to create the COM object. Specify null or the empty string for the local server.


DestroyWordObject

Destroys the Word.Basic COM object.


Syntax
public void DestroyWordObject()

FileNew

Creates a new Microsoft WORD document.


Syntax
public void FileNew()

Remarks

Wrapper for the FileNewDefault COM method of the Word.Basic COM object.


FileLoad

Loads an existing Microsoft WORD document.


Syntax
public void FileLoad(java.lang.String filename)

Where Is
filename the name of the file to load.


Remarks

Wrapper for the FileOpen COM method of the Word.Basic COM object.


FormatFontSize

Sets the font size.


Syntax
public void FormatFontSize(long fontsize)

Where Is
fontsize the new font size.


Remarks

Wrapper for the FormatFont COM method of the Word.Basic COM object.


InsertText

Inserts text into the Microsoft Word document.


Syntax
public void InsertText(java.lang.String textstr)

Where Is
textstr the text to insert.


Remarks

Wrapper for the Insert COM method of the Word.Basic COM object.


InsertNewLine

Inserts a newline into the Microsoft Word document.


Syntax
public void InsertNewLine()

Remarks

Wrapper for the InsertPara COM method of the Word.Basic COM object.


FileSaveAs

Saves the Microsoft Word document using a specified name.


Syntax
public void FileSaveAs(java.lang.String filename)

Where Is
filename the name of the file.


Remarks

Wrapper for the FileSaveAs COM method of the Word.Basic COM object.


FileSave

Saves the Microsoft Word document.


Syntax
public void FileSave()

Remarks

Wrapper for the FileSave COM method of the Word.Basic COM object.


FileClose

Closes the Microsoft Word document, and exits Microsoft Word.


Syntax
public void FileClose()

Remarks

Wrapper for the FileClose and FileExit COM methods of the Word.Basic COM object.