MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database.
MyJSQLView is the result of a condensed version of a larger project that was needed to access an inventory database. The project from inception was to be made available from code that could be run on most OS's, platform independent. In addition the selected database, MySQL, was also deemed to be chosen because of its open source nature. The final key was network enabled.
The application would need to be able to connect to the database either locally, same machine, or a server anywhere that was Internet accessable. Java and MySQL fit these needs. MyJSQLView only needs two other pieces of code, the JRE, Java Runtime, and Connector/J. Connector/J provides the driver interface between the Java SQL statements, and the MySQL database.
The database driver for Java is not limited to MySQL and can be easily modified for other databases. In addition the interface can also be made to interact through SSH. The application once installed can provide, I believe, a much quicker access/update to the database than a web based interface frontend and MyJSQLView will supports transaction locking. If you want to quickly access a MySQL database for viewing and editing I think MyJSQLView will provide an alternative that is simple and easy to use.
Here are some key features of "MyJSQLView":
· User Preferences Saving. (Not Implemented in Beta Release.)
· User Preferences Summary Table Column Selection.
· Access to All Tables in Database During Session.
· Viewing, Adding, Editing, and Deleting All Table Fields.
· Supports All MyJSQL Data Types, Including Blobs.
· Data Type Checking During Adding or Updates.
· Support for All Table Types, Including Transaction Locking.
· Printing of Summary Table Data, Screen View.
· Export of Summary Table Data or Complete Table.
· Simple Easy to Use Interface.
· Table Sorting and Searching.
Requirements:
· Java 2 Standard Edition Runtime Environment
· MySQL Connector/J
