Skip to content

Latest commit

 

History

History
22 lines (16 loc) · 1.43 KB

README.md

File metadata and controls

22 lines (16 loc) · 1.43 KB

MySQLRemoteGUI

A two-tier Java based client-server application interacting with a MySQL database utilizing JDBC for the connectivity. This project was designed to gain you some experience using the various features of JDBC and its interaction with a MySQL DB Server environment.

How it Works

GUI allows client or root user to execute SQL commands against an SQL server that the client selects. The user selects the JDBC driver to use and the database URL which corresponds to the database on which commands should be executed. The GUI has UI elements for the user to connect to the database, enter commands, execute commands, and see the results.

Simple SELECT

Command #2C

Complex SELECT

Command #1

Client user prevented from making database changes

Command #2B

Root User Has Elevated Permissions

Root User UPDATE UPDATE Result
Command #8B Command #8C