An Example Project

In this example we'll create two ways of presenting the same data:

in an HTML table
In a Java Applet embedded into an HTML screen, with a popup for details

: 1. Create a new Sapphire/Web project and call it JavaT3.
: 2. Create a new HTML document in the Document Manager called home.html.
: 3. Add the following between the <BODY> and </BODY> tags

<A HREF="Table">HTML Table</A><BR>
<A HREF="Class">Class</A><BR>

: These are the links to your display pages.
: 4. Save your work.

HTML Table Display

: 1. Create a new HTML document called table.html.
: 2. Add the following between the <BODY> and </BODY> tags

<BR>
<TABLE BORDER>
<CAPTION>Authors</CAPTION>
##Sa_authors##
</TABLE>

: This HTML orders your data into a table.
: 3. Bind the HREF=Table link from home.html to table.html with the DSQL Object BD_Authors which you will find in the Sapphire Tutorial pubs2 database.
: 4. Select the output fields you wish to see, binding them to data site authors, and use the Detail population call SaPopulateTable, which will provide all the internal HTML formatting for the contents of a table

Test

: 1. Use Sapphire's Test button to make and load the project into your browser
: 2. Select the HTML Table link; clicking it should give you this:

Figure 4-1 Listing the authors in an HTML table (Navigator for UNIX)

Class

This example adds a Java Applet, Sa.SaJavaDrill.class, to the project.

: 1. Create a new HTML document called class.html.
: 2. Add the following between the <BODY> and </BODY> tags

<h2>Class</h2><hr>
<applet		code=Sa.SaJavaDrill.class 
		codebase="/saclasses"
		width=390 
		height=320>
<param name="rsurl" value=" saact='Class' ">
<param name=indexCols value="0">
</applet><hr>

: This HTML will invoke an applet to present your data.
: 3. Bind the HREF=Class link from home.html to class.html with a NULL binding.

Figure 4-2 Binding home.html to class.html

: 4. Open the Object Bind Editor (New Activator) and in the Activator Selector select the activators from the class.html document. From these, select saact=class.
: 5. For this binding, you select no template at all, so it appears to go nowhere.

Figure 4-3 Binding class.html<a>class

: a. Use BD_Authors as the Data Access Object for this binding.
: b. Leave the output template blank.
: c. Leave the Data Site column blank in the Results Columns.
: d. In the first row, pop up the Results Detail Dialog, as shown, and select SaPopUrlRowSet.

Figure 4-4 The Results Detail editor

<applet		code=Sa.SaJavaDrill.class 
		codebase="/saclasses"
		width=390 height=320>
<param name="rsurl" 
value=" saact='http://HeartOfGold/Scripts/JavaT3/
	JavaT3.exe?FNC=JavaEmbeddedRowset__Aclass_html' ">
<param name=indexCols value="0">
</applet>

The first three lines of code just define where to get the class and how much space to give it on the form.
The <param> line (split into three parts here, unfortunately) defines an saact assignment for the value. The assignment is like this:

saact='<CGI Program>?FNC=JavaEmbeddedRowset__A<Template>'

The Sa.SaJavaDrill.class provides the split screen, the display of the fields, and the controls.
The JavaEmbeddedRowset provides the data to be displayed.

Adding a Popup to the Class

Now let's add a popup display to show some more information about the record we are inspecting with the rowset and the class.

: 1. Make a copy of class.html, calling it class2.html. Add this document to the project. Add a new anchor to home.html and bind it with a null binding to class2.html. Check that this new page functions correctly, as did class.html.
: 2. Add the following lines to the class2.html template just before the </applet> tag, without deleting the old lines.

<param name="rsurl1" value=" saact='JClassPop' ">
<param name="label1" value="JClass LiveTable View">
<param name="title1" value="JClass Table View">
<param name="rsview1" value="SaJTablePop">
<param name="visibleCols" value="5">
<param name="visibleRows" value="10">