This is a demonstration of an applet using OpenLink's JDBC Driver with the OpenLink Scrollable Cursor RowSet Extension to the JDBC specification.
When the Web browser has finished loading the Java applet, a window containing the JDBC applet will appear:
When it is running, click on the "Query" button to execute a SQL query against the default connection URL. If successful, you should see the first rowset of the resultset filling the applet window:
Click on the "Next" button to retrieve the next rowset, "Prior" to go back a rowset, "First" to move directly to the first rowset, and "Last" to move to the last rowset.
"Delete", "Refresh", "Lock", "Unlock", "Add" and Update" work on the principle of a current row in the rowset. To indicate the current row to the applet, you must click on any column of a particular row and then press a key. The status panel will then display "Current Row = 2" or similar, indicating that the current row is set.
Clicking "Delete" will attempt to delete the row from the database. Clicking on "Refresh" will now retrieve the latest values from the database to refresh that row. However this may not be successful dependent on the restrictions place on the resultset by the underlying database.
"Lock" and "Unlock" will attempt to perform those operations on the current row, which again, may or may not be successful, dependent on the restrictions of the underlying database.
"Add" will attempt to add the contents of the current row as a new row to the relevant tables forming the resultset. "Update" will attempt to update the modified contents of the current row to the database. Again the success of these two operations depend on the restrictions placed on the underlying database.
"Get Bookmark" will attempt to retrieve a bookmark for the current rowset position, which "Set Bookmark" will attempt to return to.
To move to a particular position in the resultset, enter that position into the edit box next to the "Goto" button and click the "Goto" button.
To pick the connection URL, select "File|Pick Connection URL.." from the menu. A dialog box will appear, enabling you to pick the Server Type, and set initial values for Database, Username and Password. These values all overwrite the current connection URL:
To change the connection URL, select "File|Set Connection URL.." from the menu. A dialog box will appear, enabling you to edit the connection URL:
Please note that due to the applet security restrictions, it is only possible to connect to the same server IP as the Web server.
The Java source for this applet