The Swift Bank Queueing System is a desktop application developed with Java in NetBeans, utilizing MySQL Workbench for database management. It's designed to efficiently manage customer queues and service operations within a bank.
This system streamlines customer flow, provides real-time service insights, and enhances overall branch efficiency.
The Swift Bank Queueing System provides the following core functionalities:
- Ticket Generation: Allows customers to generate numbered tickets for various banking services.
- Agent Interface: Provides tools for service agents to call customers and mark tickets.
- Service Analytics: Tracks the total customers served at each counter.
- Customer Display Integration: Support for displaying currently served ticket numbers.
The Swift Bank Queueing System is developed with the following technologies:
- Java: The primary programming language for application logic and GUI.
- MySQL: Relational database management system for persistent storage of queue, service, and user data.
- NetBeans IDE: Integrated Development Environment used for project development and UI design.
- MySQL Workbench: Visual tool for designing, developing, and managing MySQL databases.
- JDBC: Java Database Connectivity for connecting the Java application to MySQL.
These instructions detail the process of setting up and executing the Swift Bank Queueing System.
- Java Development Kit (JDK 8+ recommended): For compiling and running Java applications.
- NetBeans IDE (Optional): For project development and modification.
- MySQL Server: Installed and running.
- Git: For repository cloning (if applicable).
-
Clone Repository:
git clone https://github.com/angelb9967/SwiftBank-Queue-System.git cd SwiftBank-Queue-System -
Database Setup:
- Create Database: Using MySQL Workbench or a client, create your database (e.g.,
bank_queue_db). - Import Schema: Execute the provided SQL script (e.g.,
schema.sql) to create tables and initial data. - Configure Connection: Update database connection parameters (host, db name, user, password) in the Java application's configuration.
- Create Database: Using MySQL Workbench or a client, create your database (e.g.,
-
Open in NetBeans (Optional):
- Launch NetBeans IDE.
- Go to
File > Open Project...and navigate to the cloned repository.
-
Add JDBC Driver:
- Ensure the MySQL JDBC driver (
mysql-connector-java-x.x.x.jar) is added to your project's libraries in NetBeans.
- Ensure the MySQL JDBC driver (
-
Build the Project:
- Within NetBeans, right-click the project and select
Clean and Build.
- Within NetBeans, right-click the project and select
Upon successful building and database configuration, the Swift Bank Queueing System can be operated as follows:
- Execute Application:
- From NetBeans: Right-click the project and select
Run.
- From NetBeans: Right-click the project and select
- System Interaction:
- Interact with the application's GUI to manage queues, serve customers, generate tickets, and monitor operations.
For any inquiries or feedback regarding this project, please reach out:
| Contributor | Github Account |
|---|---|
| Angeline | ๐ฉโ๐ป angelb9967 |
Project Repository: https://github.com/angelb9967/SwiftBank-Queue-System.git
Get a quick look at the Swift Bank Queueing System in action!
