Downloads

SERVICES     TUTORIALS     BOOKS

Downloads from LMBrown.com, Inc. are available for free and unrestricted use.

Note: right-click or shift-click on the links to download the associated file.

• WebClient (webclient.jar) - WebClient is a simple browser (standalone Swing application) to interactively connect to Web servers, send requests, and receive replies. WebClient support both SSL and proxy servers.

  WebClient is bundled as an executable JAR file. To run this program, enter the following line at the command prompt.

  PROMPT> java -jar webclient.jar
  
  

• Scrollable Queries (scroller.war) - Web application illustrating custom tag to perform database queries and present the result in a scrollable HTML table. Implementation is based on JDBC Rowset Implementations 1.0.

  Adapted from Core Servlets and JavaServer Pages, Vol. 2

  The custom tag supports two scrollable query approaches:

  • Cached Query - The query result is cached in memory. Paging through table rows accesses the cached data.
  • Uncached Query - The query is executed for each request. Paging through the table rows forces reexecution of the query.

  Source code for scrollable query example.

  • ScrollableQueryBean.java An abstract class for scrolling through a result set and generating an HTML table. The ResultSet, which could be cached or not cached, is controlled by a concrete subclass.
  • CachedScrollableQueryBean.java Bean (subclass of ScrollableQueryBean) to execute a database query and store the result in a CachedRowSet.
  • UncachedScrollableQueryBean.java Bean to execute a database query and store the result in an uncached ResultSet. As the data is not cached, subsequent requests for additional table rows results in reexecution of the query. Subclass of ScrollableQueryBean.
  • csajsp-jdbc-taglib.tld Tag Library Descriptor file for ConnectionServletContextListener and ScrollableQueryTag.
  • ScrollableQueryTag.java Query tag to scroll through a result set and return a block of rows from the result set as an HTML table. The result set is obtained from a ScrollableQueryBean located in the SESSION scope.
  • CachedScrollableQueryExample.jsp JSP page illustrating a scrollable query based on a cached result set. Example queries the Employee table in the Microsoft Access Northwind database. Modify ConnectionServletContextListener to configure for your database.
  • UnachedScrollableQueryExample.jsp JSP page illustrating a scrollable query based on an uncached result set. Example queries the Employee table in the Microsoft Access Northwind database. Modify ConnectionServletContextListener to configure for your database.
    • Images for JSPs: first.gif, next.gif, prev.gif, last.gif
    • JSP-Styles.css Style sheet for JSPs.
  • ConnectionServletContextListener.java Listener that stores ConnectionInfoBeans in the servlet context. Three ConnectionInfoBeans are preconfigured for an Microsoft Access, MySQL, and Oracle database.
  • ConnectionInfoBean.java Stores information to create a JDBC connection to a database. Stored information includes the connection name, description of the connection, driver classname, URL to connect to the host, username, and password.
  • ServletUtilities.java Utility (helper) class used to filter data before building HTML table.
  • JDBC Rowset 1.0 Reference implementations for JDBC Rowset 1.0.