JDBC Compliant Applet Demos
ScrollDemo
This program demonstrates JDBC functionality via an Applet.
It also demonstrates the additional Resultset navigation functionality provided by
Utilization Steps:
1.
Start the
2. Start up your Web Browser
3.
Enter one of the following URLs into your browser depending on the location of your
Local To you:
http://localhost:8000
Remote Server:
http://<hostname or IP address of remote server>:8000
Note: Port "8000" presumes that you provide this value when prompted during your OpenLink Sever components installation.
4. Follow the Admin Assistant's Menu tree to the location of the "JDBC Applet Demos" menu item. The graphic below depicts this process.
Figure: 8.5.3.1.
5.
Click on the hyperlink that reads "Applet demonstration with
6.
Use the Applet's File->Set Connection URL menu item set a URL pointing to an ODBC or UDBC DSN.
If uncertain follows the instructions laid out in the section covering
The line below depicts the URL construction dialog presented:
jdbc:openlink://localhost/DSN{{{=}}}WebScrollDemo
7. Enter a valid SQL statement for the back end database that you are connecting to via JDBC and then click on the "Query" button. The screen shot below depicts this process:
Figure: 8.5.3.1.
8.
JDBC 1.1 functionality provides Forward-Only as opposed to Bi-Directional Resultset Scrolling,
Table: 8.5.3.1. Scroll Demo Keys Explained
Button | Explanation |
First | takes you to first record in the Resultset |
Next | takes you to the next record in the Resultset from your current position |
Prior | takes you to the previous record in the Resultset from your current position |
Last | takes you to the last record in the Resultset |
Lock | locks the current record |
Unlock | unlocks the current record |
Add | add a new record to database |
Update | change current record |
Delete | remove current record from database |
Get Bookmark | mark current record position for future revisit |
Set Bookmark | revisit previous marked position in current ResultSet |
Go To | go directly to a specific record number within the current ResultSet |
Refresh | Reopen current resultset |
Referenced by...