jdbentry java tool

This can be used as a standalone "application", or as part of a larger program. It creates a top-level Frame, and connects to a mysql database.table. (Although in principle, it should be trivially usable with other databases, if you get the right JDBC driver, and adjust getConn())

It looks up existing values for each of the columns, and allows the user to input a new row, either from scratch, or as a mix of new column data and selected old column data.

In a way, you could consider it a "quicken" type data-entry system. You can look up pre-existing entries, and fill out the remaining values, one line(row) at a time.

The name of a local MySQL database and a table.
The gjt.org JDBC driver in a .jar file (added to your classpath)
Permission for the user running this to modify the database, without password. (or you could change the code, of course)


If you have any suggestions, comments, or "hey, it works on platform xxx, cool", drop me a line! phil@bolthole.com