Wolf Parking Management System

We designed and implemented the Wolf Parking Management System to efficiently manage parking lots and their users on a university campus. The key information to be maintained in the database includes driver details, parking lot information, zone information, space information, permit information, vehicle information, and citation information. The system will cater to the needs of administrators responsible for overseeing parking services like managing parking lots and permits, the security for handling citations, and the drivers to view and pay or appeal their citations. These tasks are implemented through four major categories: information processing, maintaining permits and vehicle information for each driver, generating and maintaining citations, and generating reports for citations, current violations, the list of assigned permits, and other statistics related to parking information.

Given that multiple users will be simultaneously accessing and updating information within the parking system, we require a robust database system instead of relying on a simple file system. It enables concurrent access and ensures data integrity, allowing multiple users to interact with the system without the risk of overwriting or conflicting with each other's updates. This guarantees that driver details, permit information, and citation records remain accurate and consistent, even when accessed and modified by administrators, security personnel, and drivers concurrently. Moreover, databases facilitate efficient data management and retrieval. Queries can swiftly extract specific information, eliminating the need to manually search through potentially outdated files. Unlike traditional file systems, which may require reloading or rewriting entire files, databases provide real-time access to the most up-to-date information.

Installation

Follow these steps to install and set up the Wolf Parking Management System.

Prerequisites

Make sure you have the following installed on your system:

• Java Development Kit (JDK) (version 8 or higher)
• Eclipse IDE
• PuTTY

Database Configuration

There are two ways to access the MariaDB database on the remote server. The course project can be done with JDBC. Using the MariaDB terminal on the remote server

1. You need an SSH client. We recommend Putty for windows. For Mac users use the Terminal app.

   • May require a VPN connection for off-campus (https://oit.ncsu.edu/campus-it/campus-data-network/network-security/vpn/)
   • Remote Host: Putty: remote.eos.ncsu.edu
   • Terminal app: ssh yourUnityID@remote.eos.ncsu.edu

2. Launch your SSH client and open a secured connection to the remote host

   • enter your unity ID (if applicable)
   • enter your unity ID password

3. Access the database: /mnt/apps/public/CSC/Mysql-Shell/bin/mysql -u agarg27 -p -h classdb2.csc.ncsu.edu

4. Enter password

   MySQL Shell 8.0.25  
   Copyright (c) 2016, 2021, Oracle and/or its affiliates.
   Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
   Other names may be trademarks of their respective owners.
   Type '\help' or '\?' for help; '\quit' to exit.
   Creating a session to 'uid@classdb2.csc.ncsu.edu'
   Fetching schema names for autocompletion... Press ^C to stop.
   Your MySQL connection id is xxxxx
   Server version: 5.5.68-MariaDB MariaDB Server
   No default schema selected; type \use to set one.
   MySQL classdb2.csc.ncsu.edu:3306 JS >
   

5. At the MySQL classdb2.csc.ncsu.edu:3306 JS > prompt type \sql. This will switch your command line to SQL instead of JS.

6. To exit the command line, type \q and press Enter.

7. Type use agarg27; to activate database.

8. Type show tables; and other SQL commands.

Build and Run

Setup Eclipse with a JDBC connector to connect to a MariaDB Server version 5.5.68

1. Clone the repository:

   git clone https://github.com/amantra/WolfParkingManagementSystem.git

2. Navigate to the project directory:

   cd WolfParkingManagementSystem

3. Open Eclipse IDE (You can install Eclipse following https://www.eclipse.org/downloads/packages/installer)

4. Install Maria DB connector JAR file from https://downloads.mariadb.com/Connectors/java/latest/mariadb-java-client-2.3.0.jar

5. Right-click on the project > build path > add external archives > select the JAR file you just downloaded

6. Run App.java to run the program and you should get no errors.

Usage

The system has a main menu that gives the user the following options:

1. Create Schema and Load Demo Data
2. Information Processing
3. Maintaining Permits/Vehicles
4. Maintaining Citations
5. Report Generation
6. Exit App When prompted, the user enters a number 0-6 corresponding with what kind of action they would like to take. For each menu option in numbers 2-5, there is a submenu displayed that has specific operations listed. Our system has a public App class (App.java) that facilitates switching between the main menu options and separate classes for each related group of operations. This was done to break the application into more manageable and maintainable pieces of code.

Our program also contains helper classes:

1. InitDB: to create and initialize database schema, and load demo data into the database.
2. ConnHelper: for establishing and closing a connection to a MariaDB database.
3. InsertHelper, UpdateHelper, SelectHelper, and DeleteHelper: to handle the preparation and execution of the queries, displaying a success message if rows are inserted, and printing any SQL exceptions that occur during the process.

License

This project is licensed under the MIT License.