Menu-Driven program to implement Travel Agency

Prerequisites: Classes and Objects in Java, Switch Case statement in Java

Problem Statement:
Write a program to build a simple application for the bus travelling service using JAVA 8, MYSQL Database and JDBC which can perform the following operations:

1. Book ticket for users/passengers on given routes via the various payment method.
2. Cancel the ticket booked by the users/passengers using the ticket details and the user credentials
3. Print the ticket via ticket details and the user credentials.
4. Update the passenger details on the booked ticket via ticket ID or E-mail ID and user credentials which are registered.

Approach: Initially, we need to set up a database in order to store the information of the buses and the booking. Here, the MySQL database is used. Initially, we need to set up the database. So, the following steps are followed to set up the database:

1. Initially, a database is created in MySQL database using the workbench.
2. After creating the database, multiple tables are created signifying multiple travel services where each table contains details of the passenger. The tables are created in the following way:

   

3. Now, since each table must contain the details of the passengers, each table has the following attributes:

   

Now, we need to create a connection between the database created above and the java program. In order to do this, the following steps are followed:

1. Initially, we need to collect the database and driver info in the class which we would be developing the application. The syntax for doing this is:
   

   String driverClassName = “com.mysql.jdbc.Driver”;
   String url=”jdbc:mysql://localhost/jdbc”;
   String user=”root”;

   // The default password is root.
   // But we can set up any password
   // for MYSQL database
   String pwd= “root”;

2. Now, we need to load the JDBC driver. This is performed by the following statement:
   

   // Class.forName method returns the
   // Class object associated with the
   // class or the interface
   Class.forName(driverClassName).newInstance();

3. After initializing the database, we need to connect to it. So, we need to create a connection. The connection is created as:
   

   Connection con = DriverManager.getConnection(url, user, pwd);
   System.out.println(“con—->”+con);

4. After connecting, we should be able to execute SQL statements in order to get the data or update it or post it on the database. In order to execute the statements, the following syntax is used:
   

   Statement st = con.createStatement();

   // Creating SQL query
   String sql= “” ;

   // Executing the query
   st.executeUpdate(sql);

5. Finally, after completing the execution, we need to close the connection. The connection to the database is closed as:
   

   st.close();
   con.close();

Till now, we have initialized the database and created a connection between the database and the Java program. Now, we need to define all the methods based on functionality. The methods in the program are as follows:

1. Book ticket: In order to book a ticket, we first need to choose the route. This option is given to the user to choose a route among the set of predefined routes. For all the routes, users have to enter his details like name, age, mobile number, email, etc. Now, the user gets a list of available travels in the particular route. Based on the users choice, the data is stored in that respective table of the database created above. In order to do this, switch-case is used where every case is the choice of the travel provider.
2. Cancel Ticket: Similar to the above method, we need to implement the cancel functionality where users will be able to cancel the booked ticket. In order to do this, we need to first get the details of the users whose tickets need to be cancelled and this is validated with the mobile number and email ID of the user which is given during the input.
3. Print Ticket: Now, the print function is implemented. In order to print the ticket, the user details are taken, like the bus in which the ticket has been booked and the email ID is taken as the input to find the ticket details and print the details.
4. Update Ticket: In order to update the ticket, the user must have a booked ticket in the first place. Therefore, the email id of the user is taken as the input to verify if the ticket exists or not. After the email id is obtained, the search operation is performed on the database to search the ticket and then the new updated details are taken as the input which is then updated in the database.

Below is the complete implementation of the above functions along with the database connection:

Note: The above code does not work on the online IDE. Please use an offline IDE to run the above code.

Output: The following two videos explain the working of the above code.