Java Database Connector SQL Client

The source code is available here

Getting Started

First, make sure that you have the following things installed:

• Java
• Maven
  • Make sure it is properly configured on your system
• MySQL
  • This program was tested using MySQL 9.1
  • Ensure your MySQL database is running through Port 3306

Getting started

Starting off, make sure you are only using a database that has up to six columns!

• When the program boots, you will be met with a login panel. Ensure that you enter the database that you want to use
• If your MySQL service is not running, make sure you start the service before attempting to log in, otherwise it cannot connect

The main panel

• This is the section that will show you all of your database's entries. There are a few elements at the top to take note of.
  • Enter the table you wish to view that is in the database you entered earlier into the text field on the left.
  • The select 'Select Table/Show All'
  • If you wish to specify what column to base your query off of, you can select that in the drop down menu, and then enter a key term into the text field to the left
  • After doing so, you can hit the search button, and the results will update

• You can use the left and right buttons to flip view more entries

Database Options

The options panel on the left side of the main panel are used to do basic modifications to your database. These are the following: - Updating, inserting, and deleting data entries - Creating, editing, and deleting tables - Changing, creating, and deleting databases

Modifying Entries

• In order to update an entry in your database, you must enter a table in your database, and then hit the 'get columns button'.

• You are able to entier the different columns are want to modify, and then there is a specifying statement at the end of the panel where you can tell the program to update entries that are greater than, less than, or equal to the column with a specified value.

Inserting new information is as simple as entering your table's name, and then entering your desired information to enter into your database.

• Deleting entries is largely the same, just be careful, as deleted information cannot be recovered. You will be required to verify your credentials before deleting anything.

Modifying The Table

• In order to create a table, you must enter a table name, and then use the drop down boxes to specify the values in the table. The text fields are used for column names.

• Enter your table name, and then you can change the data type a column uses. Make sure that you do not attempt to convert numeric types to string types, or the database will refuse the transaction.

• Deleting a table will require you to login to prevent any accidental modifications.

|

Modifying The Database

• Changing databases effects all other aspects of the program. Make sure when verifying your credentials that you enter the same table name if you want to continue to modify it.

• NOTE: You will have to enter a table name to update the main panel.

• You can directly create a new database, however you must use the previous 'change database' option to use it. You will have to login to verify your credentials.

• When deleting a databse, make sure you swap to another database as to ensure you can safely delete it without causing any issues.