This tutorial introduces features of Netscape Application Builder by walking you through the creation of a simple application. This sample application enables users to purchase and sell compact discs.

• Task 1: Starting a New Project
• Task 2: Creating Static Links
• Task 3: Creating an Input Form
• Task 4: Creating a Login Sequence
• Task 5: Creating a Database Form
• Task 6: Creating Browse Activities
• Task 7: Creating a Search Activity
• Task 8: Using Queries and Result Sets
• Task 9: Inserting Form Data Into a Database
• Task 11: Creating Enterprise JavaBeans

• Launch Netscape Application Builder
• Create a New Project
• Create a Data Model
• Clean Up Project File
• Add Any Pre-Existing HTML Files
• Save Your Work

1. Name the new project "cdx1" in directory "<nasRoot>\cdx1".


Note that the sample tutorial created uses the directory "cdx", you cannot copy pieces of the cdx tutorial into your "cdx1" project without modifications, such as query (.gxq) paths, JavaServer Page (.jsp) paths, and class definitions.

2. Click Next to create each of the project starter files.


In this tutorial, you need not create index.html, because you will copy an existing file when you come to the section "Add Any Pre-Existing HTML Files" on page 89. The purpose of this dialog box is to allow you some flexibility in which files are created initially. For example, if you wanted to keep an existing index.html file in your web server's doc directory, you would uncheck this file; otherwise, your file would be overwritten by the empty index.html file created by this wizard.

3. Click Next. The New Project wizard shows you the files it will create.

4. Click Finish. Netscape Application Builder creates the following files:

File Type	File Names
Project	cdx1.gxm
HTML start page	index.html
JavaScript source code	validate.js
Java source code	AppResource.java, BaseServlet.java
NTV	appInfo.ntv

1. Click the Yes, Add a Data Model button in the Create Data Model dialog.

2. Double-click the Data Model icon under New file(s).

3. Under "Insert Tables" specify the following values for the listed fields:

Field	Value
Driver	ODBC
Data Src	cdx
User name	netscape
Password	netscape



Note that if you select "ORACLE_OCI" for the table, Netscape Application Builder displays an additional field, "Database"; the proper value you should supply is "nsample".

4. Click OK and the Add Tables dialog appears.
5. Add cdxinventory and cdxuser to the Data Model by selecting them from the available tables and clicking the right-arrow button to move them to the "Tables in data model" pane.

6. Click OK to finish.

1. Right-click the cdxinventory table and select Insert Table Alias from the pop-up menu.

Netscape Application Builder displays the table cdxinventory_2.

2. Repeat this step to create another table (cdxinventory_3).

1. Click the cdxuser.id field and drag it to cdxinventory.owner. This step creates a one-to-many join from cdxuser.id to cdxinventory.owner.
2. Next, drag the cdxuser.id field to cdxinventory_2.buyer.
3. Finally, drag the cdxuser.id field to cdxinventory_3.xlock.


The data model now allows one user to own many titles, purchase many titles, and have many purchases pending.

4. Click the close box [x] to close the data model editor; type the name "cdx.kdm" for this data model, when prompted.

1. Yes, Add a Data Model.
2. Click the Existing tab.
3. Select cdx\cdx.kdm.
4. Double click cdx.kdm in the project tree to view the data model.

1. Right-click index.html in the Netscape Application Builder Project tree, and select "Remove".
2. Check Remove the file from the File System so that the file is deleted.

1. Using Windows Explorer, copy the files and sub-folders in <NABroot>\tutorial\starters to the working project directory under <WebRoot>\docs\cdx1.


2. Using Netscape Application Builder, select Project - Add File(s) then select the Existing tab to add existing files to the project.
3. Select the Existing tab and, Under Web Server root\cdx1, select the following files:

• index.html
• UserMenu.html
• Instructions.html
• cdx_logo.gif


4. Click Add. Netscape Application Builder adds the files to the project.

1. From the Project tree, double-click the HTML Page "index.html" to open it in Netscape Application Builder's integrated HTML editor.

Note: You may use an HTML editor of your choice by specifying a third- party HTML editor in the Tools - Development Options dialog. However, to create or modify links, especially those that call servlets, it is much easier to use the Netscape Application Builder "built-in" HTML editor.

Next, perform the following steps to convert the static text "Instructions" to a hyperlink to the instructions.html page:

2. Select the text of the first bullet: Instructions.
3. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.

The text becomes a link.

4. In the Properties inspector, click the Destination URL property editor button .
5. In the HTML File drop-down, select the file Instructions.html.
6. Click OK to complete the link.

• Generate a Data Entry Form and Associated Servlet
• Edit the JavaServer Page
• Edit the Query File
• Edit the Servlet File
• Add the Main Menu Link

1. Select File - New - Input.
2. Type "CreateAccount" for Name.

3. Store to a database table.

4. Select the project data model (cdx.kdm).

5. Select Use the existing connection and verify that the name is "cdx".

6. Select the table cdxuser to specify name, email, phone, and password fields for stored input data (uncheck "id" so it does not appear on the form).

7. Click Next.

8. Click Finish.

Netscape Application Builder generates the following project files, which are identified in the project window:

• CreateAccount.html
• CalledCreateAccount.jsp
• CalledCreateAccount.java
• CalledCreateAccount.gxq
• CalledCreateAccount.ntv

1. To create link, drag Data-bound HTML HyperLink icon from palette.
2. Change link text to "Main Menu".
3. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.

The text becomes a link.

4. In the Properties inspector, click the Destination URL property editor button .
5. In the HTML File drop-down, select the file "index.html".
6. Click OK to complete the link.

1. Double-click CalledCreateAccount.gxq in Project tree to open the query file.
2. Double-click the CalledCreateAccount_Insert query.

Netscape Application Builder displays the InsertQuery Properties Dialog.

3. Click the Fields tab, and set the Value for the "id" column to be :id.

This action tells Netscape Application Builder to bind the id column to the value of the `id' valList parameter.

4. Click Finish
Screen shot is out-of-date for Beta II.

1. Double-click the CalledCreateAccount.java file to open it.
2. Find the defaultAction() method and before the stmt.executeUpdate() statement, add the following code to the servlet file:

String sname = (String) req.getParameter("name");

int code = sname.hashCode();

stmt.setInt(parameterNames.getValInt("id"), code);

Screen is out-of-date for Beta II

3. Save all modified files.
4. Compile (and Test, if desired).

1. Select "Create New Account" text in index.html.
2. Click the link icon.
3. Select the destination URL Property Editor .
4. Select the html page CreateAccount.html.

• Create the Login Page and Servlet to Process Login Data
• Modify CalledLogin.java File
• Compile
• Edit CalledLogin.jsp
• Link the Login Page to the Main Menu

1. Select File - New - Login.

2. Type "Login" for Name.

3. The username and Password parameters are already specified; select Next.

4. Check Authenticate with a Database Table.

5. Select the project's data model (cdx.kdm).

6. Select Use the existing connection and verify that the name is "cdx".

7. Select Table "cdxuser" and bind Username and Password to name and pswd columns, respectively; click Next.

8. Make sure "id" and "name" are checked to save to session.

9. Click Next.

10. Click Finish.

Netscape Application Builder creates the following files:

• Login.html
• CalledLogin.jsp
• CalledLogin.java
• CalledLogin.gxq
• CalledLogin.ntv

session.setid(loginRS.getString("id")); 

To:

long id = loginRS.getLong("id"); 

session.setid(String.valueOf(id)); 

1. To compile, select Build - Compile File.

1. Open index.html.
2. Select Log In and specify it as a link.
3. Click the link icon.
4. Select the destination URL Property Editor .
5. Select the html page Login.html.

1. Select File - New - Database Forms.
2. Type "ListUsers" for Name.

3. Click Next.

4. Click Next to use an existing data model.
5. Select Single page, Multiple record master.

6. Specify the project's data model (cdx.kdm).
7. Select Use the existing connection and verify that the name is "cdx".

8. Select the cdxuser table and the name, email, and phone fields.

9. Select display all records at once.

10. Select cdxuser.name to sort.

11. Click Next.

12. Click Finish.

Netscape Application Builder creates the following files:

• ListUsers.jsp
• ListUsers.java
• ListUsers.gxq
• ListUsers.ntv
13. Open ListUsers.jsp and add a link back to the main menu:

Type the text "Main Menu", select it, click the Link icon, and set destination URL property to index.html; or drag index.html to the page, and change text to "Main Menu".



14. Open index.html and convert List Users static text to a link:

Select the text, then click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Edit Destination URL in Properties . Select the ListUsers servlet from the Servlet drop-down and click OK.

Note that you can also right-click the highlighted text and choose Create Link from the pop-up menu to create the link.

• Create Browse Titles By Artist Activity
• Create Browse Titles By Price Activity
• Connect Main Menu Links to the Browse Activities

1. Select File - New - Database Forms.
2. Type "BrowseArtist" for Name.
3. Click Use a data model.
4. Select Single page, Multiple Record Master.
5. Specify the project's data model (cdx.kdm).
6. Select Use the existing connection and verify that the name is "cdx".
7. Select table: cdxinventory.
8. Select table fields: id, artist, title, and price.

9. Select Browse 20 records at a time.

10. Select Sort by cdxinventory.artist.
11. Click Next.

12. Click Finish. Netscape Application Builder creates the following files:

• BrowseArtist.jsp
• BrowseArtist.java
• BrowseArtist.gxq
• BrowseArtist.ntv

1. Open the query, BrowseArtist.gxq; double-click the BrowseArtist select query; and select the Conditionals tab on the query properties dialog.
2. Click Add Condition.
3. Select the cdxinventory table, buyer field, and = operator, and enter "0" as the value. Note that you must not include quotes around the values.

4. Click OK, then repeat steps 1 and 2 for the xlock field. The Conditions panel of the Query Designer displays the new query conditions; then click Finish.

1. Open BrowseArtist.jsp.
2. Select BrowseArtist.id data-bound label.
3. Delete it.
4. Enter text "Buy!".
5. Select the text "Buy!".
6. Click the Create Link icon at the far right of the toolbar. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.

1. Select File - New - Database Forms.
2. Type "BrowsePrice" for Name.
3. Click Use a data model.
4. Select Single page, Multiple Record Master.
5. Specify the project's data model (cdx.kdm).
6. Select Use the existing connection and verify that the name is "cdx".
7. Select table: cdxinventory.
8. Select table fields: id, artist, title, and price.
9. Select Browse 20 records at a time.
10. Select Sort by cdxinventory.price.
11. Click Next.

12. Click Finish. Netscape Application Builder creates the following files:

• BrowsePrice.jsp
• BrowsePrice.java
• BrowsePrice.gxq
• BrowsePrice.ntv

1. Open the query, BrowsePrice.gxq; double-click the BrowsePrice select query; and select the Conditionals tab on the query properties dialog.
2. Click Add Condition.
3. Select the cdxinventory table, buyer field, and = operator, and enter "0" as the value. Note that you must not include quotes around the values.
4. Click OK, then repeat steps 1 and 2 for the xlock field. The Conditions panel of the Query Designer displays the new query conditions; then click Finish.

1. Open the BrowsePrice.jsp file.
2. Select BrowsePrice.id data-bound label.
3. Delete it.
4. Enter text "Buy!".
5. Select text "Buy!".
6. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.

1. Open UserMenu.html.
2. Select the text to become a link, either Browse Available Titles [Sorted by Price] or Browse Available Titles [Sorted by Artist].
3. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.
4. Bring up Destination URL Property Editor from Properties
5. Select BrowseArtist or BrowsePrice servlet as necessary.
6. Repeat steps 2-5 for the other link.

1. Select File - New - Database Forms.
2. Type CDBrowser for Name; click Next.

3. Select the option "Use a data model" to use cdx.kdm and click Next.

4. Select Multiple record master and single record detail.
5. Select the "Create a search page" checkbox.

6. Specify the project's data model (cdx1.kdm).

7. Select "Use an existing connection" and verify that the name is cdx.

8. Select fields to display in master in the following order:

cdxinventory.id, artist, title, price, cdxuser.name, and cdxinventory.notes. (Note that id will be converted to the Buy! link later.)



9. Select browse 20 records at a time.

10. Select sort by cdxinventory.artist and cdxinventory.title.

11. Select fields to display on detail:

From cdxuser: name, email, and phone.



12. Leave detail fields display-only.

13. Select cdxuser.name for Display Field; this is the drill-down field.
14. Specify join as (Master) cdxinventory.owner = (Detail) cdxuser.id.
15. Specify columns for search page: title and artist.
Screen is out-of-date for Beta II
16. Click Next.

17. Click Finish.

Netscape Application Builder creates the following files:

• CDBrowser.jsp
• CDBrowserDetail.jsp
• CDBrowser.java
• CDBrowserDetail.java
• CDBrowser.gxq
• CDBrowserDetail.ntv
• CDBrowser_Search.html
• CDBrowser.ntv

1. Open the CDBrowser.gxq query file.
Screen is out-of-date for Beta II
2. Double-click the CDBrowser select query. This time, the Conditionals panel is disabled because the query includes the variable ":Whereclause" and is considered a custom query.
3. Select the SQL panel where you can enter the additional where conditions directly into the SQL SELECT statement.

4. Edit the statement to include the conditions:

cdxuser.id = cdxinventory.owner

cdxinventory.xlock = 0 and cdxinventory.buyer = 0

and :WhereClause

1. Delete the "id" text in column header.
2. Select CDBrowser.id data-bound label.
3. Delete it.
4. Enter text "Buy!".
5. Select text "Buy!".
6. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.

• Create SELECT Query
• Create UPDATE Query
• Create New Database Form
• Edit BuyCD JavaServer Page
• Edit BuyCD Servlet
• Edit BuyCD ResultSet
• Edit DefaultAction Method
• Create Transaction Confirmation Page

1. Select File - New - Query.
2. Type cdrecord for Name.

3. Specify the project's data model (cdx.kdm).
4. Specify Select for Type.

5. Using the SelectQuery Properties dialog, perform the following actions:

Under the Name Tab, specify cdrecord then click Continue.



Under the Fields Tab, specify All from cdxinventory, then click Next.



Under the Conditionals Tab, select Add Condition and set cdxinventory.id to :id.



Click OK to continue.

6. Click Finish.

Netscape Application Builder creates the cdrecord.gxq SELECT query file.

1. Select File - New - Query.
2. Type updatelock for Name.
3. Specify the project's data model (cdx.kdm).
4. Select Update for the query type.

5. Using the UpdateQuery Properties dialog, perform the following steps:

• Under the Name Tab, specify updatelock.
• Under the Fields Tab, specify xlock = :lock.
• Under Conditionals Tab, click Add Condition.
• Set cdxinventory.id to :id.
• Click OK.
• Click Finish.

1. Select File - New - Database Forms.
2. Type BuyCD for Name.
3. Select cdrecord.gxq query.

4. Select "Multiple Records" to get a tabular layout.

5. Do not check the "Create input page" checkbox.

6. Click Next.

7. Click Finish.

1. Open the BuyCD.jsp file to remove unwanted columns from the page.

2. Place cursor in the first row, first column of the table, and select Format - Table - Delete Column to remove the id column.
3. Repeat step 2 to delete the owner, buyer, xlock, and genre columns.

4. From the Palette Form tab, drag a push button component below the table.

5. Use the Properties editor to change the Label property to Buy It!.

1. Open up BuyCD.java file.
2. From the properties inspector, using the parameter properties editor, add a required session parameter named id.
3. Using the properties editor, add the required session variable, id, by clicking the expand box next to the Required Sessions property and selecting id as the value of [new item].

1. Open the BuyCD.java file.
2. Using the Properties editor, edit the BuyCD Output ResultSet.

3. Select the Inputs tab and make the following selections for the Query:

• Specify id for the query parameter.
• Specify id for the source.
• Specify Int for Dest Type.
• Check Bind On Load.
Screen is out-of-date for Beta II

if (((HttpServletRequest2) req).validate()) { 

   return IServletErrorHandler.SUCCESS; 

} else { 

   ((HttpServletRequest2) req).setDefaultTemplate

                                                ("cdx1/NoLogin.jsp"); 

   return IServletErrorHandler.SUCCESS;    } 

}

• Launch Results Wizard to Create BuyCommit Page
• Link BuyCommit to the BuyCD Confirmation Page
• Link Buy! to BuyCD Servlet

1. Select File - New - Results.

2. Type BuyCommit for Name.

3. Enter the input parameter id and check Required.

4. Click Next.

5. Click Finish.

Netscape Application Builder creates the BuyCommit.jsp, BuyCommit.java, and BuyCommit.ntv files.

1. Add code to your BuyCommit.java file. This code contains the defaultAction() method. You will find this code in the completed file installed in <NASRoot>\Apps\cdx\BuyCommit.java.
2. In this code, you must change the directories for cdrecord.gxq, updatelock.gxq, and CDBrowser.gxq from cdx to cdx1:

cdx1/cdrecord.gxq

cdx1/updatelock.gxq

cdx1/CDBrowser.gxq

1. Open the BuyCD.jsp file.
2. Select Form: Form1.
3. Open Action property editor:

1. Select Action.
2. Click within the rightmost part of a blank field to activate the custom property button .
3. Click the property button .

Select BuyCommit from the servlet drop-down list.



4. Click the Get Arguments button.
5. Click in value field and click the Data-Bind Value button.
6. Netscape Application Builder displays the cell editor dialog box with ResultSet BuyCD and DataField id already selected. Click Add and then click OK to specify the data-binding expression.

7. Click OK on the main property editor dialog.

1. Open the BrowseArtist.jsp file.
2. Select Buy! to edit the Destination URL property.
3. Select the BuyCD servlet.
4. Click the Get Arguments button, select value cell, and select Data Bind-Value.
5. In the cell editor dialog box, select BrowseArtist in the ResultSet drop-down list and select id in the DataField drop-down list; click Add.
6. Netscape Application Builder displays the GX tag data-binding expression; click OK.

7. Click OK in the main dialog box.

1. Select File - New - Input.
2. Type "CreateEntry" for Name.
3. Store to a database table.
4. Specify the project's data model (cdx.kdm).
5. Use an existing connection (cdx).
6. Select table cdxinventory; select the following fields: price, title, artist, and notes, to appear on the form.

7. Click Next.

8. Click Finish.

Netscape Application Builder creates the following files:

• CreateEntry.html
• CalledCreateEntry.java
• CalledCreateEntry.ntv
• CalledCreateEntry.gxq
• CalledCreateEntry.jsp

1. Open CalledCreateEntry.java, in the properties editor and add the required session variable, id.

2. Enter the following code prior to the stmt.executeUpdate() in the CalledCreateEntry.java file to bind the CD inventory id and owner id to the query parameters:

String recCount = (String) req.getParameter("notes"); 

int code = recCount.hashCode(); 

stmt.setInt(parameterNames.getValInt("id"), code); 

String curUser = req.getSession().getValue("id").toString(); 

stmt.setInt(parameterNames.getValInt("owner"),

            Integer.valueOf(curUser).intValue()); 

1. Open the CalledCreateEntry.gxq file.
2. Right-click the view and select the Insert Select Query pop-up menu item.
3. In the SelectQuery Properties dialog, name the query "CalledCreateEntry_Count".

4. Select the SQL tab and edit the SQL statement to read:

   /* CalledCreateEntry_Count:  */

   query CalledCreateEntry_Count using (ODBC, cdx, netscape) is 

   select count(*) 

   from cdxinventory


5. Click Finish. The query is now a custom query.

1. Select to the SQL tab and edit the SQL statement to contain the following code:

/* CalledCreateEntry_Insert:  */

query CalledCreateEntry_Insert using (ODBC, cdx, netscape) is

insert into cdxinventory (id,

owner,

buyer,

xlock,

price,

title,

artist,

notes)

values (:id,

:owner,

0,

0,

:price,

:title,

:artist,

:notes)

Screen is out-of-date for Beta II

1. Open the UserMenu.html file.
2. Select the text "Add CD for Sale/Exchange".
3. Click the Create Link icon, or right-click the text selection and choose Create Link from the pop-up menu.
4. From the Properties editor, open the Destination URL property editor.
5. Select CreateEntry.html from the HTML File drop-down list.

6. Click OK to complete the link.

• Create SELECT Query
• Create UPDATE Query
• Build Pending Sales Report
• Create AcceptSale Servlet
• Edit Servlet to Load and Execute Update Query
• Create CancelSale Servlet
• Edit Servlet to Load and Execute Update Query
• Connect Links to Servlets
• Link View Pending Transactions Activity to User Menu

1. Select File - New - Query.
2. Type PendingSeller for Name.
3. Specify the project's data model (cdx.kdm).
4. Specify Select for Type.

1. Type PendingSeller for Name.

2. Select the title, artist, and price fields from the cdxinventory_3 table. Note that you choose the cdxinventory_3 table to display related information about the prospective buyer.
3. Select name from the cdxuser table.
4. Select id and xlock from the cdxinventory_3 table.

1. Click Add Condition to add the following conditions:

• cdxinventory_3.owner = :owner
• cdxinventory_3.xlock <> 0


2. Click Finish.

1. With the PendingSeller query view still active, select Insert - Update Query from the menu or by right-clicking in the query window.
2. Type AcceptSale for Name.
3. Fields: using the cdxinventory table, set fields buyer and xlock to:

buyer = :buyer

xlock = 0



4. Click Add Condition to add the following condition:

cdxinventory.id = :id



5. Click Finish.

1. With the PendingSeller query view still active, select Insert - Update Query from the menu or by right clicking in the query window.
2. Type CancelSale for Name.
3. Fields: set field xlock to:

xlock = 0



4. Click Add Condition to add the following condition:

cdxinventory.id = :id



5. Click Finish.

1. Select File - New - Database Form.
2. Type PendingSeller for Name.
3. Specify the existing query file: PendingSeller.gxq.

4. Specify Parent query: PendingSeller.
5. Specify Multiple records.
6. Do not check "Create input page".
7. Click Next.

8. Click Finish.

1. Open the PendingSeller.java file and using the property editor, add a new required session variable: id.
2. Select the Inputs tab and following selections for the Query Parameter owner:cdrecord:

• Specify the source as id.
• Specify the Dest Type as Int.
• Specify SESSION_BINDING for Binding.


3. Click Finish.

1. Open the PendingSeller.jsp file.
2. Edit the column headers for the last two columns by selecting the field identifier text, and replacing it with "Accept" (5th column) and "Cancel" (last column).
3. Right-click the PendingSeller.id4 data-bound label and, using the pop-up menu, select Change Type - Data-Bound Link.
4. Repeat step 2 for the PendingSeller.xlock data-bound label.
5. Now, click again on the PendingSeller.id4 data-bound label and, in the Properties editor, clear the ResultSet property by selecting and deleting the text "PendingSeller".
6. Now you can enter the Link text: Cancel.
7. Similarly, set the Link text for Accept link to Sold!.

1. Select File - New - Results.
2. Type AcceptSale for Name.
3. To execute the AcceptSale query, you need the id and buyer inputs, so specify these parameters as required inputs.

4. Click Finish.

1. In AcceptSale.java, change the directories for PendingSeller.gxq and AcceptSale.jsp from cdx to cdx1:

cdx1/PendingSeller.gxq

cdx1/AcceptSale.jsp

1. Select File - New - Results.
2. Type CancelSale for Name.
3. For inputs, add the required parameter, id.

4. Click Finish.

1. In CancelSale.java, change the directories for PendingSeller.gxq and SellerCancel.jsp from cdx to cdx1:

cdx1/PendingSeller.gxq

cdx1/SellerCancel.jsp

1. In the Servlet drop-down list, select the AcceptSale servlet.
2. Click the Get Arguments button.
3. Click in the id value cell, then click the Data-bind value button.
4. In the cell editor drop-down lists, select the PendingSeller ResultSet and the DataField, id4.
5. Click Add, then click OK.

6. Repeat steps 3-5 for the buyer value, selecting xlock3 in the cell editor as the source DataField.

7. Click OK on the main property editor to complete the Sold! URL specification.

1. In the Servlet drop-down list, select the CancelSale servlet.
2. Click the Get Arguments button.
3. Click in the id value cell, then click the Data-bind value button.
4. In the cell editor drop-down lists, select PendingSeller ResultSet and the DataField, id4.
5. Click Add, then click OK.


1. Click OK on the main property editor to complete the Cancel URL specification.

1. Open the usermenu.html file.
2. Select the text of the "View pending transactions on your CDs" bullet.
3. Click the Create Link icon at the far right of the toolbar. If the Create Link icon is not present, then select View - Toolbars - Standard. Note that you can also right-click the highlighted text and choose "Create Link" from the pop-up menu to create the link.
4. Display the Destination URL property editor, and select the servlet PendingSeller.
5. Click OK.

1. Replace the source of CalledLogin.jsp with a copy of UserMenu.html.
2. Open the source view of UserMenu.html; select all of the text and copy.

3. Open the source view of CalledLogin.jsp, select all text.

4. Paste.

1. Choose CreditCheckBean for the name of the bean.
2. Create it in the myBeans directory at a level parallel to the cdx directory. Note that Netscape Application Builder does not create the folder for you.

1. Click Next.

1. Choose Stateless.

2. Click next to finish the wizard and create the files.

3. Click Finish.
4. Edit the bean's interface file to define the CheckCredit() method.

5. Add an implementation of the CheckCredit() method to the CreditCheckBeanBean.java file.

6. Rebuild your project.

7. Modify the BuyCD class to use the credit check session bean.

...

// Import from your beans

import myBeans.*;

public class BuyCD extends cdx.BaseServlet

{

    myBeans.ICreditCheckBeanHome home = null;

    myBeans.ICreditCheckBean remote = null;

    String JNDI_NAME = "myBeans/CreditCheckBean";

public int defaultAction(HttpServletRequest req, HttpServletResponse 
res)

             throws ServletException, IOException

     {

         if (((HttpServletRequest2) req).validate()) {

          // Locate Session Bean and apply credit check

            cdx.AppResource session = (cdx.AppResource) 
((HttpServletRequest2)req).getHttpSessionBean();

            String sName = session.getname();

            try{

               home = (ICreditCheckBeanHome) 
getEJBHomeByJNDIName(JNDI_NAME);

            }catch(Exception e){}

            try {    

               remote = home.create();

            }catch(javax.ejb.CreateException e){}     

            boolean bCreditOK = remote.checkCredit(sName);

            if (!bCreditOK) {

               error(req, res, "Insuffecient Credit " + sName);

               return IServletErrorHandler.FAIL_DONT_STREAM_ERROR;

            }

            return IServletErrorHandler.SUCCESS;

          } else {

            ((HttpServletRequest2) req).setDefaultTemplate("cdx/
NoLogin.jsp");

            return IServletErrorHandler.SUCCESS;

          }

        //return super.defaultAction(req, res);

    }

}