Train Concession System

Description

Train Concession System is a terminal based project especially made for colleges where their students can get Travelling Concession on their Season Passes.

As per your role in this project, you can access any one of login metioned below:

• Admin Login
• Student Login

Key Features

Below is the list of features that each login provides:

1. Admin Login

• Retrieve form data from database
• Approve application (If information is correct)
• Generate concession letter and send it to user (If form is approved)
• Send Grievance (If information is not valid)

Form data of student gets deleted from database once it is processed by admin

2. Student Login

• Create new account (Store information in database)
• Apply for application (Form gets added in Queue after submitting it)
• Submit application

Results

You can view the output results of this project by clicking on the Google-drive link given below:

https://drive.google.com/drive/folders/1onbI4armLuRy4p53OSjA6VFfVTy3M4kF?usp=sharing

Project Setup

• First install Java on your computer (JDK).
• You can use any java IDE such as IntelliJ, Eclipse, VS Code etc.
• You need to have one database server such as MySQL, MariaDB, Oracle etc.
• Install .jar file of your database in order to use JDBC. (Do check version of .jar files)
• Clone this repository and connect your .jar file with programme.
• Run Test_TrainConcessionSystem.java to run project.

Concepts Involved

• Data Structures

  • Queue
  • String

• Object Oriented Programming (OOP)

• Java Database Connectivity (JDBC)

• MariaDB

Progress

• Admin Progress

  • Creating Admin Login
  • Verifying authorized admin with help of Security Key
  • Checking application forms one by one by retrieving data from database
  • Sending Concession Letter to applicant if form is valid
  • Sending grievances if found any

• Student Login

  • Creating Student Login
  • Creating new account and storing the data in database
  • Applying for concession scheme
  • Submit the form

Application

This project can be used by college students to get concession on their travelling Local Train passes.

Eligible Students

Students from various courses such as Diploma, B.Tech, M.Tech, PhD can apply for scheme

Future Scope

New features can be added such as:

• Students being able to upate their personal data
• Adding valid time period for generated letter by admin