Previous Next Contents


Database Forms/Reports Wizard

The database forms/reports wizard allows you to generate a servlet that processes form or search data from generated HTML files, uses the data model and query file to retrieve data from a relational database, and merges this data with the generated JSP to display the results as a static report or an editable form.

The following steps are included in this wizard:

Related Topics

Specify Base Name and Location
Description
Decide what to label the servlet, specify the directory where it is stored, and specify the super class upon which to base it.

Properties
Field
Value
Example
Name
Name of the servlet.
DataAccess
Directory
Directory in which to store the servlet.
C:\nab\apps\HelloWld\
Super class
Class on which to base the servlet.
Project1.BaseServlet

Related Topic

Specify Data Access
Description
Specify a query file for your forms and reports.

Properties
Choose one of the following:

Related Topic

Select Records Display Options
Description
Select the radio button corresponding to how retrieved records are displayed.

Properties
Field
Description
Single
Display one record per page.
Multiple
Display multiple records per page.

Related Topic

Create Input Page
Description
The database page wizard creates a servlet and JavaServer Page (JSP) automatically. To create an input page in addition to these, you can enable the Create Input Page checkbox.

Related Topics

Select Pages to Create
Description
Choose the type of page(s) to create.

Properties
Field
Description
Single page
Multiple, linked pages
Create a search page
You can enable the checkbox to create an additional page by which to search the master page created by the wizard.

Related Topic

Specify Data Model
Description
Select a data model.

Properties
Field
Description
Example
Data Model
You can select a data model found in the current project from the Data Model drop-down list or click Browse to locate a data model found elsewhere.
MessageBoard.kdm
Create a New Data Model
Exit the wizard and create a new data model.

Related Topic

Specify Data Connection
Description
Select the data connection through which your application accesses the database.

Properties
You can specify which data connection to use by choosing one of the following:

Related Topic

New Database Connection
Description
Select the database to log into.

Field
Value
Example
Driver
Database driver type.
ODBC
Data sources
Name of the data source.
Employee Database
Database name
Name of the database to which you connect.

User name
User ID required by the data source.

Password
User password required by the data source.


Select Display Fields
Description
Select the fields to display on the JavaServer Page (JSP).

Properties
Field
Value
Example
Table
Table from which you choose fields to display.
chatMessages
Fields
Field(s) to display.
UserId, Password
>
Move selected field to Fields to Display.

>>
Move all fields to Fields to Display.

<<
Remove all fields from Fields to Display.

<
Remove selected field from Fields to Display.

Fields to Display
Fields selected for display on the page.
chatUsers.UserID
chatUser.Password

Related Topic

Select Table Format
Description
Click the radio button corresponding to the page style to create.

Properties
Field
Description
Editable fields (Database Form) from table
Display-only fields (Database Report)
See Database Report.
Display all records at once
Display all retrieved records at the same time.
Browse n records at a time
Display only a limited number of retrieved records at the same time. Enter the number of records to view at once in the text box.

Related Topic

Database Form
Description
The database form wizard allows you to create a page with fields that may be edited. To create a database report with read-only fields, see Database Report.

The following steps are included in the database form wizard:

Related Topic

Specify Primary Key(s)
Description
Specify the primary key(s) for your master page. A primary key is a field or set of fields used by the database backend to identify a record in the database.

Properties
Field
Value
Example
Columns
All columns available for use in the key.
UserId
Nickname
Primary Key
Columns selected for use in the key.
chatUsers.UserId
chatUsers.Nickname
>
Move a selected column to Primary Key.

<
Remove a selected column from Primary Key.

>>
Move all fields to Primary Key.

<<
Remove all fields from Primary Key.


Select Sort Fields
Description
Specify the order in which retrieved data is organized by creating a sort key.

Properties
Field
Value
Example
Table
Table from which you choose fields to sort by.
chatUsers
Fields
One or more fields to use as a sort key.
Mail, FullName
>
Move selected field(s) to the Sorted Fields column.

<
Remove selected fields from the Sorted Fields column.

<<
Remove all fields from the Sorted Fields column.

>>
Move all fields to the Sorted Fields column.

Sorted Fields
Fields by which to sort.
(A-Z)chatUsers.Mail
A-Z
Sort the selected field in ascending order.
(A-Z)chatUsers.Mail
Z-A
Sort the selected field in descending order.
(Z-A)chatusers.Fullname

Related Topic

Select Display Fields (Detail)
Description
See Select Display Fields.


Select Table Format
See Select Table Format.


Specify Primary Key(s)
See Specify Primary Key(s).


Select Sort Fields (Detail)
Description
See Select Sort Fields.


Select Drilldown Field
Description
Select a field on your master page to appear as a hyperlink, linking your master page to your detail page.

Properties
Field
Value
Example
Display field
Field to appear as a hyperlink on your master page, linking it to your detail page.
chatUsers.UserId
Master column
Column on your master page to relate to a column on your detail page.
chatUsers.UserId
Join
Relationship between master and detail columns.
=
Detail column
Column on your detail page to relate to a column on your master page.
chatUsers.UserId
Insert Row
Add a row.

Delete Row
Remove selected row.

Related Topic

Select Columns for Search Page
Description
Select the field(s) to appear on the search page created with your database form(s).

Properties
Field
Value
Example
Search Fields
Field(s) by which to search.
chatUser.UserId
Operation
Operation used to compare search criteria and data found in the database.
=
Insert Row
Insert additional rows.

Delete Row
Delete selected row.

Related Topic

Finish
Description
Click Finish to complete the wizard. A Java file is created with generated code that performs the function you designated in previous steps.


Database Report
Description
The database report wizard allows you to create a database report with fields that may not be edited. To create a database form with editable fields, see Database Form.

The following steps are included in this wizard:

Related Topics

Select Sort Fields
Description
See Select Sort Fields.


Select Display Fields (Detail)
Description
See Select Display Fields.


Select Table Format
See Select Table Format.


Specify Primary Key(s)
See Specify Primary Key(s).


Select Sort Fields (Detail)
Description
See Select Sort Fields.


Select Drilldown Field
Description
See Select Drilldown Field.


Select Columns for Search Page
Description
See Select Columns for Search Page.


Finish
Description
See Database Form, Finish.


Select Join Fields
Description
Add a join between a master field and detail field. A join sets the relationship between two tables or two queries A master record is the primary target of a query. A detail record is the result of a secondary query, based on the master record.

Properties
Field
Value
Example
Master Fields
Choose a field from the drop-down list of all available master fields to join with a detail field
cdxinv.id
Operation
Choose an operation from the drop-down list that will join the master and detail fields.
=
Detail Fields
Choose a field from the drop-down list of all available details fields to join with the master field.
cdxinv.owner
Insert Row
Add additional joins.

Delete Row
Remove selected joins.

Related Topic

Create an Input Page
Description
The database page wizard creates a servlet and JavaServer Page (JSP) automatically. To create an input page in addition to these, you can enable the Create Input Page checkbox.

Related Topics
 

© Copyright 1999 Netscape Communications Corp.