Querying Oracle 10G XE using Sun Java Creator 2

In order to display the rows returned by the query you can add a table to the page and bind the data to the table. Drag and drop a table from the "palette" to the page. The table object gets added to the page in the design view. The default of five columns and three rows should be displaying as shown. Now right click the table, and from the context sensitive menu click on the Bind to data...short cut.

This opens the window named Table Layout showing the defaultTableDataProvider. You may click on the drop-down for data provider which will show the employeesDataProvider.

Choose the employeesDataProvider and click on the OK button. This opens the next window showing all the columns that were chosen to be displayed as shown. You may use the arrow keys as well as the up/down keys to reorder the columns as well as choose not to include some of the previously chosen columns. Here two of the previously chosen ID columns have been removed from display.

Displaying the web page

Now all that is necessary is to apply some style information to the page, modify the title, add some text for the page footer, and so forth. Some of these activities were discussed in the previous article. Here only the title of the table was changed and a footer was added. Now build the page and click on the run button in the main menu. The displayed page appears as shown below.

Summary

In addition to having an extremely user friendly data connectivity interface, Creator 2 has an equally impressive, user friendly query editor utility that makes it very easy to modify queries. There are hardly any differences between the Creator 2 interface and the VS 2005 interface with regard to modifying queries.

The creation of a validation table is only a small additional step which, once created, may be used for any number of connections. It should be noted that not once was the Java source shown to the user. The reader will benefit from reading the other Java-related articles at the DevArticles.com web site. Perhaps the only experience that is different from the Microsoft IDE is the slower speed with which the various windows show up during the design as well as the first time the page loads in the browser.