LOCAL MYSQL DATABASE TESTER

A simple example of accessing local MySQL database with Java using MySQL Connector/J.

PREREQUISITES / TOOLS

• MySQL Workbench - manager of the database
• MySQL Server - runs the db server
• MySQL Connector/J - allows connection with MySQL and any Java application
• Apache Netbeans - creates the GUI of the application
• Java JDK

HOW IT WORKS

1. the main codes are stored in the src folder
2. the database should already be created and running with MySQL Server
3. the main code simply utilizes the Connector/J modules to connect with the database based on the credentials (server link, server username, server password) and runs sql statements through the connection.
4. the main code has been exported into jar but needs to locally refer to the connector/j jar file to access its functions. if exported.