• Topic
  • Discussion
  • UdaWikiWeb.ScrollDemo2Applet(Last) -- Owiki? , 2016-08-19 15:00:55 Edit owiki 2016-08-19 15:00:55

    JDBC Compliant Applet Demos

    ScrollDemo

    This program demonstrates JDBC functionality via an Applet. It also demonstrates the additional Resultset navigation functionality provided by OpenLink's Scrollable Resultset & RowSet Extensions for JDBC on a Record by Record Basis.

    Utilization Steps:

    1. Start the OpenLink Request Broker.

    2. Start up your Web Browser

    3. Enter one of the following URLs into your browser depending on the location of your OpenLink Request Broker:

    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. WebJDBC Applet Demo WebJDBC Applet Demo

    5. Click on the hyperlink that reads "Applet demonstration with OpenLink Software JDBC Scrollable Cursor extensions"

    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 OpenLink JDBC URL formats which shows you how to construct Type 1, 2, and 3 URL formats for your OpenLink Drivers for JDBC.

    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. WebScroll Applet Demo WebScroll Applet Demo

    8. JDBC 1.1 functionality provides Forward-Only as opposed to Bi-Directional Resultset Scrolling, OpenLink's Scrollable Resultset Extensions for JDBC enable Bi-Directional Resultset Scrolling. This is why this applet has an additional set of Resultset Navigation buttons: "First","Next", "Prior","Last", "Lock", "Unlock", "Add", "Update", "Get Bookmark", "Set Bookmark", "and Go To". The existence of Bi-directional Scrollable Result sets (or Cursors) is often presumed by end-users and developers alike, its importance rarely understood prior to embarking upon JDBC application development or product selection, the unfortunate consequence being complex application re-writes or implementation of sub par JDBC solutions. Each of the button in the applet demo is explained below so as to understand the magnitude of this issue:

    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...