QueryForm is a robust Java application that provides a powerful GUI front end for JDBC-enabled databases. It creates forms on-the-fly through which you can query tables and browse the results with just a few keystrokes or mouse clicks. It also lets you insert, update and delete table rows without typing any SQL statements.
If you're a developer who writes database-centric software, QueryForm can save you the tedium of typing or pasting hundreds of SQL statements into an ISQL window each day to create test data or to verify that updates were peformed properly.
The latest release features full support for pluggable look-and-feels. Enjoy a little eye candy, and use QueryForm with one of the many available third-party look-and-feel modules, a number of which are free. (QueryForm is shown above using the free, open-source Oyoaha look-and-feel.)
Also, check out the newly-enhanced program documentation, which comes bundled with QueryForm, or is available here.
Features include:
- It supports multiple concurrent connections to different databases.
- Tables can be queried through a simple form-based interface or
with a custom WHERE-clause editor.
- Query results can be browsed one row at a time with the the form
interface, or viewed in a scrollable grid.
- Query results can be exported to CSV files or INSERT statements.
- Table rows can be created, updated or deleted.
- Table rows can be "cloned" (except for the primary key and other unique fields), which makes generating test data quick and easy.
- Table metadata -- column types and sizes, and primary and foreign
key fields -- can be viewed for each table in a database.
|
|
|