🗄️🗄️🖥️ Two-Tier Client-Server Application With MySQL and JDBC 🖥️🗄️🗄️

Introduction

Objectives

To develop a two-tier Java based client-server application interacting with a MySQL database utilizing JDBC for the connectivity. The project is designed to utilise various features of JDBC and its interaction with a MySQL DB Server environment.

Gui

Description

• It is a Java-based GUI front-end (client-side) application that will connect to your MySQL server via JDBC.
  
• The database contains two users; the root user(having all privileges) and client user(having only select privileges)
• To generate database run the script script in MySQL workbench

Resources and packages

The application utilises the following resources and packages

• Java Swing -for building the graphical user inteface
• MySQL workbench - Database creation and Management
• DbUtils -populate result in table form. utilises the net.proteanit.sql.DbUtils package.First add rs2xml.jar file in the project libraries
• Sql -Database queries
• MySQL server - Connection to localhost

Screenshots

• From queris by root user in script
  • select *
  • select specified
  • insert
  • delete
  • update
• From queris by client user in script
  • select *
  • select specified
  • insert
  • delete
  • update