MyJSQLView is an easy-to-use Java GUI, graphical user interface, frontend DML, data manipulation language, tool for the HSQL, MySQL, Oracle, PostgreSQL, & SQLite databases. A query tool allows the building & executing of complex SQL statements. Easy data sorting & searching, import/export either in CSV, comma separated values, or DDL, data definition language.

All user tables and basic data type fields are available for access in the selected database. MyJSQLView only needs two other pieces of code, the Java Runtime Environment, and a Java Database Connectivity driver. The JDBC provides the interface between the Java SQL statements, and the database.

The JDBC driver for MySQL is called Connector/J, for Oracle just JDBC, and PostgreSQL JDBC3. The HSQL database has an integrated JDBC that is part of the application. The Connection Manager for MyJSQLView has been given default entries to help the user select the proper configuration for the desired database access.

The ability to connect to other databases has been fully build into the core architecture. The software has been purposely built to provide data access and is not a database management tool. All users including small to medium size businesses will find setup and using the tool to be simple and straight forward.

MyJSQLView once installed can provide a much quicker access/update to a database than a web based interface frontend and MyJSQLView supports transaction locking. If you want to quickly access a local or server based database for viewing, editing, and searching MyJSQLView provides an alternative that is simple and easy-to-use.

MyJSQLView Features:
1. Plugin Framework.
2. Internationalization Support.
3. User Connection Preferences Saving/Managing.
4. User Preferences Summary Table Column Selection & Sizing.
5. User Preferences Summary Table Row Sizing.
6. Summary Table State Saving/Loading.
7. Access to All User Tables in Database During Session.
8. Viewing, Adding, Editing, and Deleting All Table Fields.
9. Update Multiple Rows of Selected Table Field.
10. Support for Table Field Function Operations.
11. Supports All Basic Data Types, Including Blob/Bytea/Binary.
12. Data Type Checking During Adding or Updates.
13. Support for All Table Types, Including Transaction Locking.
14. Support for Flushing Privileges for User root on mysql database.
15. Printing of Summary Table Data, Screen View.
16. Export of CSV Summary or Complete Table Data.
17. Export of SQL Summary or Complete Table Structure/Data.
18. Export of SQL Current Open Database/Scheme.
19. Import of SQL Statement File.
20. Import of CSV data File Into Selected Database Table via Insert/Update.
21. Query Frame for Building Complex Select SQL Statements.
22. Search Frame for Running Generic LIKE Queries on All Tables in Database.
23. Simple Easy to Use Interface.
24. Simple and Advanced Table Sorting and Searching.

Requirements:
* Java
* MySQL Connector/J, JDBC3 or JDBC driver

The license of this software is Free, you can free download and free use this database management software.