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.
-
Requirements:
-
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)
Downloads
- Source code is jdbentry.java. Or just grab
the class file if you dont want to hassle with
compiling it.
- http://www.gjt.org is the NORMAL place to
get mm.mysql (JDBC support), but it's broken right now. So temporarily, I
am making the JDBC jar file for
mysql available on my site. (It's GPL'd software)