Train Ticket Reservation System

About:

This project is about the Train-Ticket-Reservation-System which is used to view Train Schedule, search trains, Seat availability, Train timings. We can also enquire about fare of different trains. We can get information about train between two stations. We can book seats online. This provides a safe and secure seat reservation system.

Online Train Information and Reservation

This Website is built for following purpose:-

• View Trains Schedule
• Search Trains
• Seat Availability
• Train Timings
• Fare Enquiry
• Trains Between Stations
• Booking seats online.
• Login and Logout Security
• Password Changes
• Payment Gateway
• Ticket Booking History

The Admin have the following access to this website:-

• Login
• Add Trains
• Update Trains
• Remove or cancle Trains
• View Trains
• Profile Edit
• Logout

The Users have the following Access:-

• Register
• Login
• View Trains
• Check Seat Availability
• Search Trains
• Train Avaiablity and Fare Between Stations
• Books Tickets
• View Booking History
• View Profile
• Update Profile
• Change Password
• Logout

Technologies used:-

1. Front-End Development:

• HTML
• CSS
• Bootstrap

2. Back-End Development

• Java [J2EE]
• JDBC
• Servlet
• MySQL ( SQL )

==== Software And Tools Required ======

• : Git
• : Java JDK 8+
• : Eclipse EE
• : Apache Maven
• : Tomcat v8.0+
• : MySQL database

========== Dummy Database Initialization ===========

STEP 1: Open Mysql database

STEP 2: Login and connect to database using administrator username and password

STEP 3 : Create a new user:

STEP 4: Now execute the below sql query in query tools in created database

-- Create the user
CREATE USER 'RESERVATION'@'%' IDENTIFIED BY 'Manager@123';

-- Grant all privileges (equivalent to DBA role in Oracle)
GRANT ALL PRIVILEGES ON *.* TO 'RESERVATION'@'%' WITH GRANT OPTION;

-- Apply the changes
FLUSH PRIVILEGES;

CREATE TABLE CUSTOMER (	
    MAILID VARCHAR(40) PRIMARY KEY, 
    PWORD VARCHAR(20) NOT NULL, 
    FNAME VARCHAR(20) NOT NULL, 
    LNAME VARCHAR(20), 
    ADDR VARCHAR(100), 
    PHNO BIGINT NOT NULL  -- MySQL does not have NUMBER(12), so use BIGINT
);

CREATE TABLE ADMIN (	
    MAILID VARCHAR(40) PRIMARY KEY, 
    PWORD VARCHAR(20) NOT NULL, 
    FNAME VARCHAR(20) NOT NULL, 
    LNAME VARCHAR(20), 
    ADDR VARCHAR(100), 
    PHNO BIGINT NOT NULL
);

CREATE TABLE TRAIN (	
    TR_NO INT PRIMARY KEY, 
    TR_NAME VARCHAR(70) NOT NULL, 
    FROM_STN VARCHAR(20) NOT NULL, 
    TO_STN VARCHAR(20) NOT NULL, 
    SEATS INT NOT NULL, 
    FARE DECIMAL(6,2) NOT NULL 
);

CREATE TABLE HISTORY (	
    TRANSID VARCHAR(36) PRIMARY KEY, 
    MAILID VARCHAR(40), 
    TR_NO INT, 
    DATE DATE, 
    FROM_STN VARCHAR(20) NOT NULL, 
    TO_STN VARCHAR(20) NOT NULL, 
    SEATS INT NOT NULL, 
    AMOUNT DECIMAL(8,2) NOT NULL,
    FOREIGN KEY (MAILID) REFERENCES CUSTOMER(MAILID),
    FOREIGN KEY (TR_NO) REFERENCES TRAIN(TR_NO)
);

INSERT INTO ADMIN VALUES ('admin@demo.com', 'admin', 'System', 'Admin', 'Demo Address 123 colony', 9874561230);
INSERT INTO CUSTOMER VALUES ('sajal@demo.com', 'sajal', 'Sajal', 'Garg', 'Kolkata, West Bengal', 954745222);

INSERT INTO TRAIN VALUES (10001, 'JODHPUR EXP', 'HOWRAH', 'JODHPUR', 152, 490.50);
INSERT INTO TRAIN VALUES (10002, 'YAMUNA EXP', 'GAYA', 'DELHI', 52, 550.50);
INSERT INTO TRAIN VALUES (10003, 'NILANCHAL EXP', 'GAYA', 'HOWRAH', 92, 451.00);
INSERT INTO TRAIN VALUES (10004, 'JAN SATABDI EXP', 'RANCHI', 'PATNA', 182, 550.00);
INSERT INTO TRAIN VALUES (10005, 'GANGE EXP', 'MUMBAI', 'KERALA', 12, 945.00);
INSERT INTO TRAIN VALUES (10006, 'GARIB RATH EXP', 'PATNA', 'DELHI', 1, 1450.75);

INSERT INTO HISTORY VALUES ('BBC374-NSDF-4673', 'sajal@demo.com', 10001, '2024-02-02', 'HOWRAH', 'JODHPUR', 2, 981.00);
INSERT INTO HISTORY VALUES ('BBC375-NSDF-4675', 'sajal@demo.com', 10004, '2024-01-12', 'RANCHI', 'PATNA', 1, 550.00);
INSERT INTO HISTORY VALUES ('BBC373-NSDF-4674', 'sajal@demo.com', 10006, '2024-07-22', 'PATNA', 'DELHI', 3, 4352.25);

STEP 5: Now Execute the below query one by one to check if the tables are created successfully

SELECT * FROM ADMIN;
SELECT * FROM CUSTOMER;
SELECT * FROM TRAIN;
SELECT * FROM HISTORY;

Note: If any of the above commands fails, please try to fix it first and then proceed to next step

====== Importing and Running the Project Through Eclipse EE ===========

Step 0: Open Eclipse Enterprise Edition. [Install if not available]

Step 1: Click On File > Import > Git > Projects From Git > Clone Uri > Paste: Repository Url> Next > Select Master Branch > Next > Finish

Step 2.A: Right Click on Project > Run as > Maven Build > In the goals field enter "clean install" > apply > run

Step 2.B: Right Click On Project > Build Path > Configure Build Path > Libraries > Remove And Update Any Libraries With Red Mark > Finish

Step 3: [Only if Tomcat v8.0 is not Configured in Eclipse]: Right Click On Project > Run As > Run On Server > Select Tomcat v8.0 > (Select Tomcat V8.0 Installation Location If Asked) Next > Add > Finish

Step 4: In The Server Tab > Double Click On Tomcat Server > Ports > Change The Port Number For Http/1.1 To 8083 > Close And Save

Step 5: Right Click On Project > Run As > Run On Server > Select Tomcat V8.0 > Next > Add All> Done

Step 6: Check Running The Site At http://localhost:8083/trainbook/

Step 7: Default Username And Password For Admin Is "admin@demo.com" And "admin"

Step 8: Default Username And Password For User Is "sajal@demo.com" And "Sajal"

The Screenshots of some of the webPages of this project are Here:

1. Search Trains Between Stations

2. View Trains

3. Book Trains

4. Payment Gateway

5. Booked Ticket Information

6. Ticket Booking History

7. Fare Enquiry

8. Change Password

9. Add Trains By Admin

"Suggestions and project Improvement are Invited"

Sajal Garg

Project Leader