JDBCTest Tool
The JDBCTest Tool may be used for a variety of database-related
applications, as described below.
JDBC Driver Testing
The JDBCTest Tool was primarily designed and built to allow users
to test any feature of any JDBC driver and their supported databases.
To that end, each step in the function sequence can be controlled
by the user, allowing both correct and incorrect operations to occur.
The JDBCTest Tool covers all methods defined in the JDBC specification.
A Simple Query Tool
In addition to it's testing features, the JDBCTest Tool can be used for
simple query and update processing. With only a small number of inputs,
a user can connect to a database, submit an SQL statement, and view the
results. To make that process even easier, the "Load And Go" command
takes a given SQL statement, creates a JDBC Statement object,
executes the statement, and then displays the contents of the JDBC
ResultSet, all without further user input.
The JDBCTest Tool also has convenient features for retrieving previous
SQL inputs and database outputs, as well as saving all database outputs
to a log file.
A JDBC Teaching Tool
The JDBCTest Tool can be used to teach programmers about the JDBC
itself. Every time a JDBC method call is executed from the JDBCTest
Tool, the corresponding Java code is written into a text window. That
window can be displayed or not, depending on the task at hand. If
desired, a log file can be specified so that all Java code is
simultaneously written to an output file as well.