Prerrequisitos: clases y objetos en Java , instrucción Switch Case en Java
Declaración del problema:
Escriba un programa para construir una aplicación simple para el servicio de viaje en autobús usando JAVA 8, MYSQL Database y JDBC que pueda realizar las siguientes operaciones:
- Reserve boletos para usuarios/pasajeros en rutas determinadas a través de varios métodos de pago.
- Cancelar el billete reservado por los usuarios/pasajeros utilizando los detalles del billete y las credenciales de usuario
- Imprima el ticket a través de los detalles del ticket y las credenciales de usuario.
- Actualice los detalles del pasajero en el boleto reservado a través de la identificación del boleto o la identificación del correo electrónico y las credenciales de usuario que están registradas.
Enfoque: Inicialmente, necesitamos configurar una base de datos para almacenar la información de los autobuses y la reserva. Aquí, se utiliza la base de datos MySQL. Inicialmente, necesitamos configurar la base de datos. Entonces, se siguen los siguientes pasos para configurar la base de datos:
- Inicialmente, se crea una base de datos en la base de datos MySQL usando el banco de trabajo.
- Después de crear la base de datos, se crean múltiples tablas que significan múltiples servicios de viaje donde cada tabla contiene detalles del pasajero. Las tablas se crean de la siguiente manera:
- Ahora, dado que cada tabla debe contener los detalles de los pasajeros, cada tabla tiene los siguientes atributos:
Ahora, necesitamos crear una conexión entre la base de datos creada anteriormente y el programa Java. Para ello se siguen los siguientes pasos:
- Inicialmente, necesitamos recopilar la base de datos y la información del controlador en la clase en la que desarrollaríamos la aplicación. La sintaxis para hacer esto es:
String driverClassName = “com.mysql.jdbc.Driver”;
String url=”jdbc:mysql://localhost/jdbc”;
String usuario=”raíz”;// La contraseña predeterminada es root.
// Pero podemos configurar cualquier contraseña
// para la base de datos MYSQL
String pwd= “root”; - Ahora, necesitamos cargar el controlador JDBC. Esto se lleva a cabo mediante la siguiente instrucción:
// El método Class.forName devuelve el
// objeto Class asociado con la
// clase o la interfaz
Class.forName(driverClassName).newInstance(); - Después de inicializar la base de datos, necesitamos conectarnos a ella. Entonces, necesitamos crear una conexión. La conexión se crea como:
Conexión con = DriverManager.getConnection(url, usuario, pwd);
System.out.println(“con—->”+con); - Después de conectarnos, deberíamos poder ejecutar declaraciones SQL para obtener los datos, actualizarlos o publicarlos en la base de datos. Para ejecutar las sentencias se utiliza la siguiente sintaxis:
Declaración st = con.createStatement();
// Creando consulta SQL
String sql= “” ;// Ejecutando la consulta
st.executeUpdate(sql); - Finalmente, después de completar la ejecución, debemos cerrar la conexión. La conexión a la base de datos se cierra como:
st.cerrar();
con.cerrar();
Hasta ahora, hemos inicializado la base de datos y creado una conexión entre la base de datos y el programa Java. Ahora, necesitamos definir todos los métodos basados en la funcionalidad. Los métodos en el programa son los siguientes:
- Reservar billete: Para reservar un billete, primero debemos elegir la ruta. Esta opción se le da al usuario para elegir una ruta entre el conjunto de rutas predefinidas. Para todas las rutas, los usuarios deben ingresar sus detalles como nombre, edad, número de teléfono móvil, correo electrónico, etc. Ahora, el usuario obtiene una lista de viajes disponibles en la ruta en particular. Según la elección de los usuarios, los datos se almacenan en esa tabla respectiva de la base de datos creada anteriormente. Para hacer esto, se utiliza switch-case donde cada caso es elección del proveedor de viajes.
- Cancelar boleto: similar al método anterior, debemos implementar la funcionalidad de cancelación donde los usuarios podrán cancelar el boleto reservado. Para hacer esto, primero debemos obtener los detalles de los usuarios cuyos boletos deben cancelarse y esto se valida con el número de teléfono móvil y la identificación de correo electrónico del usuario que se proporciona durante la entrada.
- Imprimir Ticket: Ahora, la función de impresión está implementada. Para imprimir el boleto, se toman los detalles del usuario, como el autobús en el que se reservó el boleto, y se toma la identificación del correo electrónico como entrada para encontrar los detalles del boleto e imprimir los detalles.
- Actualizar Ticket: Para actualizar el ticket, el usuario debe tener un ticket reservado en primer lugar. Por lo tanto, la identificación de correo electrónico del usuario se toma como entrada para verificar si el ticket existe o no. Después de obtener la identificación del correo electrónico, la operación de búsqueda se realiza en la base de datos para buscar el boleto y luego los nuevos detalles actualizados se toman como entrada que luego se actualiza en la base de datos.
A continuación se muestra la implementación completa de las funciones anteriores junto con la conexión a la base de datos:
// Java program to implement CLI
// based application of travel agency
import java.sql.*;
import java.util.*;
import javax.swing.JOptionPane;
// Travel class
class My_Travels {
public static void main(String[] args)
throws Exception
{
String driverClassName
= "com.mysql.jdbc.Driver";
String URL
= "jdbc:mysql:// localhost/"
+ "My_Travels_travel_service";
String user = "root";
String pwd = "mysql";
Class.forName(driverClassName)
.newInstance();
Connection con
= DriverManager.getConnection(
url, user, pwd);
System.out.println("con---->" + con);
Statement st = con.createStatement();
Scanner zz = new Scanner(System.in);
System.out.println(
"\n"
+ "\n"
+ "*********************"
+ "******************** ");
System.out.println(
"** WELCOME TO My_Travels"
+ " TRAVELS SERVICES ** ");
System.out.println(
"*********************"
+ "******************** ");
System.out.println(
"Here you have several"
+ " tasks to perform -- "
+ "\n"
+ "\n");
System.out.println(
"Press 1 for ticket booking "
+ "\n"
+ "\n"
+ "Press 2 for "
+ "ticket cancellation"
+ "\n"
+ "\n"
+ "Press 3 for updating "
+ "Passenger detail"
+ "\n"
+ "\n"
+ "Press 4 to print "
+ "ticket details");
int mainCH = zz.nextInt();
switch (mainCH) {
case 1:
System.out.println(
" Please choice the route : ");
System.out.println(
"For DEHRADUN <---> KANPUR "
+ "via Haridwar, press 1"
+ "\n"
+ "\n"
+ "For DEHRADUN <---> DELHI "
+ "via Roorkee, press 2");
int route_ch = zz.nextInt();
switch (route_ch) {
case 1:
System.out.println(
" Welcome <--> DEHRADUN"
+ " - KANPUR route "
+ "via Haridwar ");
System.out.println(
"Please enter your detail"
+ " so we can book "
+ "your ticket");
String w
= JOptionPane
.showInputDialog(
"Enter the Journey Date:");
String x
= JOptionPane
.showInputDialog(
"Enter Passenger Name:");
String y
= JOptionPane.showInputDialog(
"Enter Passenger Age:");
String z
= JOptionPane.showInputDialog(
"Enter Bus Type:");
String a
= JOptionPane.showInputDialog(
"Enter Source City:");
String b
= JOptionPane.showInputDialog(
"Enter Destination City:");
String c
= JOptionPane.showInputDialog(
"Enter Seat Type:");
String cc
= JOptionPane.showInputDialog(
"Enter Email address:");
System.out.println(
" In this route, we have "
+ "type of bushes for you "
+ "(Both AC and Non-AC "
+ "buses available "
+ "in this route ");
System.out.println(
"For Shatbdi Travels "
+ "Departure: 5 PM "
+ "Arrival: 6:15 AM "
+ "Journey time: 13Hr. 15 Min., "
+ "press 1"
+ "\n"
+ "\n"
+ "For Mahalaxmi Travels, "
+ "Departure: 6 PM "
+ "Arrival: 7:30 AM "
+ " Journey time: 13Hr. 30 "
+ "Min.press 2"
+ "\n"
+ "\n"
+ "For Blueworld Travels, "
+ "Departure: 8 PM "
+ "Arrival: 10:15 AM "
+ "Journey time: 14Hr. 15 "
+ "Min. press 3"
+ "\n"
+ "\n"
+ "For UP Govt. UPSRTC bushes, "
+ "Departure: 10:15 PM "
+ "Arrival: 12:45 AM "
+ "Journey time: 14Hr. 30 "
+ "Min. press 4");
int Bus_ch_r1 = zz.nextInt();
switch (Bus_ch_r1) {
case 1:
String sql1
= "INSERT INTO "
+ "shatabdi_travels_bus"
+ "(JourneyDate, P_Name, "
+ "P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ "Email) VALUE(?, ?, ?, ?, "
+ "?, ?, ?, ?)";
PreparedStatement ps1
= con.prepareStatement(sql1);
ps1.setString(1, w);
ps1.setString(2, x);
ps1.setString(3, y);
ps1.setString(4, z);
ps1.setString(5, a);
ps1.setString(6, b);
ps1.setString(7, c);
ps1.setString(8, cc);
ps1.executeUpdate();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shatabdi Travels. "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 2:
String sql2
= "INSERT INTO "
+ "mahalaxmi_travels_bus("
+ "JourneyDate, P_Name, "
+ "P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ "Email) VALUE(?, ?, ?, ?, "
+ "?, ?, ?, ?)";
PreparedStatement ps2
= con.prepareStatement(sql2);
ps2.setString(1, w);
ps2.setString(2, x);
ps2.setString(3, y);
ps2.setString(4, z);
ps2.setString(5, a);
ps2.setString(6, b);
ps2.setString(7, c);
ps2.setString(8, cc);
ps2.executeUpdate();
System.out.println(
"Your ticket "
+ "is booked successfully "
+ "in Mahalaxmi Travels. "
+ "This operator accept "
+ "m-ticket, please show "
+ "ticket to bus staff "
+ "during journey. "
+ "Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "Mahalaxmi Travels. "
+ "Happy and safe Journey");
break;
case 3:
String sql3
= "INSERT INTO "
+ "blueworld_travels_bus("
+ "JourneyDate, P_Name, "
+ "P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ " Email) VALUE(?, ?, ?, ?, "
+ " ?, ?, ?, ?)";
PreparedStatement ps3
= con.prepareStatement(sql3);
ps3.setString(1, w);
ps3.setString(2, x);
ps3.setString(3, y);
ps3.setString(4, z);
ps3.setString(5, a);
ps3.setString(6, b);
ps3.setString(7, c);
ps3.setString(8, cc);
ps3.executeUpdate();
System.out.println(
"Your ticket "
+ "is booked successfully "
+ "in Blueworld Travels. "
+ "This operator accept "
+ "m-ticket, please show "
+ "ticket to bus staff during "
+ "journey. Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "Blueworld Travels. "
+ "Happy and safe Journey");
break;
case 4:
String sql4
= "INSERT INTO "
+ "upsrtc_bus(JourneyDate, "
+ " P_Name, P_Age, BusType, "
+ " Source, Destination, "
+ "SeatType, Email)"
+ " VALUE(?, ?, "
+ "?, ?, ?, ?, ?, ?)";
PreparedStatement ps4
= con.prepareStatement(sql4);
ps4.setString(1, w);
ps4.setString(2, x);
ps4.setString(3, y);
ps4.setString(4, z);
ps4.setString(5, a);
ps4.setString(6, b);
ps4.setString(7, c);
ps4.setString(8, cc);
ps4.executeUpdate();
System.out.println(
"Your ticket "
+ "is booked successfully "
+ "in UP govt. UPSRTC Bus."
+ " This operator does not "
+ "accept m-ticket, please "
+ "take a print of ticket & "
+ "show bus staff during "
+ "journey. Have a nice day !");
System.out.println(
"Thanks for "
+ "choosing UPSRTC."
+ " Happy and safe Journey");
break;
default:
System.out.println(
"Invalid Bus choice."
+ " Try again Dear !");
break;
}
break;
case 2:
System.out.println(
" Welcome to DEHRADUN"
+ " <---> DELHI route"
+ " via Roorkee ");
System.out.println(
"Please enter your detail, "
+ " so we can book"
+ " your ticket");
String n
= JOptionPane.showInputDialog(
"Enter the Journey Date:");
String s
= JOptionPane.showInputDialog(
"Enter Passenger Name:");
String m
= JOptionPane.showInputDialog(
"Enter Passenger Age:");
String o
= JOptionPane.showInputDialog(
"Enter Bus Type:");
String p
= JOptionPane.showInputDialog(
"Enter Source City:");
String q
= JOptionPane.showInputDialog(
"Enter Destination City:");
String r
= JOptionPane.showInputDialog(
"Enter Seat Type:");
String cd
= JOptionPane.showInputDialog(
"Enter Email address:");
System.out.println(
" In this route, "
+ "we have 5 type of "
+ "bushes for you "
+ "(Both AC and "
+ "Non-AC buses available "
+ "in this route ");
System.out.println(
"For Shreenath Travels, "
+ " Departure: 5 PM "
+ "Arrival: 11:15 PM "
+ "Journey time: "
+ "6 Hr. 15 Min.press 1"
+ "\n"
+ "\n"
+ "For Shatabdi Travels, "
+ " Departure: 8:5 PM "
+ "Arrival: 2:10 AM "
+ "Journey time: 6 Hr. 10 "
+ "Min.press 2"
+ "\n"
+ "\n"
+ "For Mahalaxmi Travels, "
+ "Departure: 11 PM "
+ "Arrival: 6:15 AM "
+ "Journey time: 7Hr."
+ " 15 Min. press 3"
+ "\n"
+ "\n"
+ "For UP Govt. "
+ "UPSRTC bushes, "
+ "Departure: 9:30 PM "
+ "Arrival: 4 AM "
+ "Journey time: 6 Hr. 30 "
+ "Min. press 4"
+ "\n"
+ "\n"
+ "For Royal Travels Pvt. Ltd."
+ ", Departure: 12 PM "
+ "Arrival: 6:15 PM "
+ "Journey time: 6 Hr. 15 "
+ "Min. press 5");
int Bus_ch_r2 = zz.nextInt();
switch (Bus_ch_r2) {
case 2:
String sql5
= "INSERT INTO "
+ "shatabdi_travels_bus"
+ "(JourneyDate, P_Name, "
+ " P_Age, BusType, Source, "
+ "Destination, SeatType, "
+ "Email) VALUE(?, ?, ?, ?, "
+ " ?, ?, ?, ?)";
PreparedStatement ps5
= con.prepareStatement(sql5);
ps5.setString(1, n);
ps5.setString(2, s);
ps5.setString(3, m);
ps5.setString(4, o);
ps5.setString(5, p);
ps5.setString(6, q);
ps5.setString(7, r);
ps5.setString(8, cd);
ps5.executeUpdate();
System.out.println(
"Your ticket is "
+ "booked successfully in "
+ "Statabdi Travels. "
+ "This operator accept "
+ "m-ticket, please show "
+ "ticket to bus staff "
+ "during the journey. "
+ "Have a nice day !");
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shatabdi Travels."
+ " Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 3:
String sql6
= "INSERT INTO "
+ "mahalaxmi_travels_bus("
+ "JourneyDate, P_Name, "
+ "P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ "Email) VALUE(?, ?, ?, ?, "
+ " ?, ?, ?, ?)";
PreparedStatement ps6
= con.prepareStatement(sql6);
ps6.setString(1, n);
ps6.setString(2, s);
ps6.setString(3, m);
ps6.setString(4, o);
ps6.setString(5, p);
ps6.setString(6, q);
ps6.setString(7, r);
ps6.setString(8, cd);
ps6.executeUpdate();
System.out.println(
"Your ticket is booked "
+ "successfully in Mahalaxmi "
+ "Travels. This operator accept "
+ "m-ticket, please show ticket "
+ "to bus staf during journey. "
+ "Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "Mahalaxmi Travels. "
+ "Happy and safe Journey");
break;
case 1:
String sql7
= "INSERT INTO "
+ "shreenath_travels_bus"
+ "(JourneyDate, P_Name, "
+ " P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ "Email) VALUE(?, ?, ?, ?, "
+ "?, ?, ?, ?)";
PreparedStatement ps17
= con.prepareStatement(sql7);
ps17.setString(1, n);
ps17.setString(2, s);
ps17.setString(3, m);
ps17.setString(4, o);
ps17.setString(5, p);
ps17.setString(6, q);
ps17.setString(7, r);
ps17.setString(8, cd);
ps17.executeUpdate();
System.out.println(
"Your ticket is booked "
+ "successfully in "
+ "Shreenath Travels. "
+ "This operator accept "
+ "m-ticket, please show "
+ "ticket to bus staff "
+ "during journey. "
+ "Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "Shreenath Travels. "
+ "Happy and safe Journey");
break;
case 4:
String sql8
= "INSERT INTO "
+ "upsrtc_bus("
+ "JourneyDate, P_Name, "
+ " P_Age, BusType, "
+ "Source, Destination, "
+ "SeatType, Email) "
+ "VALUE(?, ?, ?, ?, "
+ "?, ?, ?, ?)";
PreparedStatement ps8
= con.prepareStatement(sql8);
ps8.setString(1, n);
ps8.setString(2, s);
ps8.setString(3, m);
ps8.setString(4, o);
ps8.setString(5, p);
ps8.setString(6, q);
ps8.setString(7, r);
ps8.setString(8, cd);
ps8.executeUpdate();
System.out.println(
"Your ticket is booked "
+ "successfully in UP govt. "
+ "UPSRTC Bus. This operator "
+ "does not accept m-ticket, "
+ "please take a print of ticket "
+ "& show bus staf during journey."
+ " Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "UPSRTC. Happy "
+ "and safe Journey");
break;
case 5:
String sql9
= "INSERT INTO "
+ "royal_travels_bus("
+ "JourneyDate, P_Name, "
+ "P_Age, BusType, Source, "
+ " Destination, SeatType, "
+ " Email) VALUE(?, ?, ?, ?, "
+ " ?, ?, ?, ?)";
PreparedStatement ps9
= con.prepareStatement(sql9);
ps9.setString(1, n);
ps9.setString(2, s);
ps9.setString(3, m);
ps9.setString(4, o);
ps9.setString(5, p);
ps9.setString(6, q);
ps9.setString(7, r);
ps9.setString(8, cd);
ps9.executeUpdate();
System.out.println(
"Your ticket is booked "
+ "successfully in Royal "
+ "Travels Bus. This operator "
+ "does not accept m-ticket, "
+ " please take a print of ticket "
+ "& show bus staff during journey."
+ " Have a nice day !");
System.out.println(
"Thanks for choosing "
+ "UPSRTC. "
+ "Happy and safe Journey");
break;
default:
System.out.println(
"Invalid Bus choice. "
+ "Try again Dear !");
break;
}
break;
}
System.out.println(
"Proceed to payment ---- "
+ "don't refresh the page :"
+ "\n"
+ "\n"
+ "You have 3 options -->");
System.out.println(
"1 : By Net Banking"
+ "\n"
+ "\n"
+ "2 : By Debit Card"
+ "\n"
+ "\n"
+ "3 : By Paytm Account");
int pay_ch = zz.nextInt();
switch (pay_ch) {
case 1:
System.out.println(
"Enter your Net Banking "
+ "ID and Password");
String id = zz.next();
String pass = zz.next();
break;
case 2:
System.out.println(
"Enter your 16 digit "
+ "debit card number, "
+ "cvv and OTP which "
+ "is sent to your "
+ "linked mobile number");
String dc = zz.next();
String cvv = zz.next();
String OTP = zz.next();
break;
case 3:
System.out.println(
"Enter your PAYTM "
+ "mobile number, "
+ "password and OTP");
String PaytmNo = zz.next();
String PtmPass = zz.next();
String PtmOTP = zz.next();
break;
default:
System.out.println(
"Invalid Payment choice, "
+ " try again !");
break;
}
System.out.println(
"Your ticket is booked "
+ "successfully. This "
+ "operator accept m-ticket, "
+ "please show ticket to "
+ "bus staff during journey. "
+ "Have a nice day !");
break;
case 2:
System.out.println(
"Select bus in which you "
+ "want to cancel your ticket");
System.out.println(
" 1: Shatabdi Travels"
+ "\n"
+ "\n"
+ " 2: Blueworld Travels"
+ "\n"
+ "\n"
+ " 3: Mahalaxmi Travels"
+ "\n"
+ "\n"
+ " 4: Shreenath Travels"
+ "\n"
+ "\n"
+ " 5: UP govt. upsrtc bus"
+ "\n"
+ "\n"
+ " 6: Royal Travels"
+ "\n"
+ "\n"
+ " Select any one");
int cnclCH = zz.nextInt();
String P_name
= JOptionPane.showInputDialog(
"Enter the Passenger name "
+ "who want to delete ticket");
String Email
= JOptionPane.showInputDialog(
"Enter the Passenger's"
+ " Email want to delete ticket");
switch (cnclCH) {
case 1:
String sql12
= "DELETE FROM "
+ "shatabdi_travels_bus "
+ "where P_name=? and Email=?";
PreparedStatement ps12
= con.prepareStatement(sql12);
ps12.setString(1, P_name);
ps12.setString(2, Email);
ps12.executeUpdate();
System.out.println(
"Your ticket is cancelled "
+ "successfully from "
+ "Shatabdi Travels");
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shatabdi Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 2:
String sql13
= "DELETE FROM "
+ "blueworld_travels_bus "
+ "where P_name=? and Email=?";
PreparedStatement ps13
= con.prepareStatement(sql13);
ps13.setString(1, P_name);
ps13.setString(2, Email);
ps13.executeUpdate();
System.out.println(
"Your ticket is "
+ "cancelled successfully "
+ "from Blueworld Travels");
System.out.println(
"Thanks for choosing"
+ "Blueworld Travels.... "
+ "Happy and safe Journey");
break;
case 3:
String sql14
= "DELETE FROM "
+ "mahalaxmi_travels_bus"
+ " where P_name=? and Email=?";
PreparedStatement ps14
= con.prepareStatement(sql14);
ps14.setString(1, P_name);
ps14.setString(2, Email);
ps14.executeUpdate();
System.out.println(
"Your ticket is "
+ "cancelled successfully "
+ "from Mahalaxmi Travels");
System.out.println(
"Thanks for choosing "
+ "Mahalaxmi Travels. "
+ "Happy and safe Journey");
break;
case 4:
String sql15
= "DELETE FROM "
+ "shreenath_travels_bus "
+ "where P_name=? and "
+ "Email=?";
PreparedStatement ps15
= con.prepareStatement(sql15);
ps15.setString(1, P_name);
ps15.setString(2, Email);
ps15.executeUpdate();
System.out.println(
"Your ticket is "
+ "cancelled successfully "
+ "from Royal Travels");
System.out.println(
"Thanks for choosing "
+ "Shreenath Travels.... "
+ "Happy and safe Journey");
break;
case 5:
String sql16
= "DELETE FROM "
+ "upsrtc_bus where "
+ "P_name=? and Email=?";
PreparedStatement ps16
= con.prepareStatement(sql16);
ps16.setString(1, P_name);
ps16.setString(2, Email);
ps16.executeUpdate();
System.out.println(
"Your ticket is cancelled "
+ "successfully from UP "
+ "govt. UPSRTC bus");
System.out.println(
"Thanks for choosing "
+ "UP govt. UPSRTC bus."
+ " Happy and safe Journey");
break;
case 6:
String sql11
= "DELETE FROM "
+ "royal_travels_bus "
+ "where P_name=? and Email=?";
PreparedStatement ps11
= con.prepareStatement(sql11);
ps11.setString(1, P_name);
ps11.setString(2, Email);
ps11.executeUpdate();
System.out.println(
"Your ticket is "
+ "cancelled successfully "
+ "from Royal Travels");
System.out.println(
"Thanks for choosing "
+ "Royal Travels.... "
+ "Happy and safe Journey");
break;
default:
System.out.println(
"Invalid cancellation choise");
break;
}
break;
case 3:
System.out.println(
"Select bus in which you "
+ "want to update your detail");
System.out.println(
" 1: Shatabdi Travels"
+ "\n"
+ "\n"
+ " 2: Blueworld Travels"
+ "\n"
+ "\n"
+ " 3: Mahalaxmi Travels"
+ "\n"
+ "\n"
+ " 4: Shreenath Travels"
+ "\n"
+ "\n"
+ " 5: UP govt. upsrtc bus"
+ "\n"
+ "\n"
+ " 6: Royal Travels"
+ "\n"
+ "\n"
+ " Select any one");
int udtCH = zz.nextInt();
String Email1
= JOptionPane.showInputDialog(
"Enter the Passenger's Email"
+ " who want to delete ticket");
String P_name1
= JOptionPane.showInputDialog(
"Enter the correct "
+ "name to update ticket");
String age1
= JOptionPane.showInputDialog(
"Enter the correct "
+ "age to update ticket");
switch (udtCH) {
case 1:
String sql12
= "UPDATE shatabdi_travels_bus "
+ "SET P_Name=?, P_Age=? where Email=?";
PreparedStatement ps12
= con.prepareStatement(sql12);
ps12.setString(1, P_name1);
ps12.setString(2, age1);
ps12.setString(3, Email1);
ps12.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from "
+ "Shatabdi Travels");
System.out.println("\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shatabdi Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 2:
String sql13
= "UPDATE blueworld_travels_bus"
+ " SET P_Name=?, P_age=? where Email=?";
PreparedStatement ps13
= con.prepareStatement(sql13);
ps13.setString(1, P_name1);
ps13.setString(2, age1);
ps13.setString(3, Email1);
ps13.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from "
+ "Blueworld Travels");
System.out.println(
"Thanks for choosing "
+ "Blueworld Travels.... "
+ "Happy and safe Journey");
break;
case 3:
String sql14
= "UPDATE mahalaxmi_travels_bus "
+ "SET P_Name=?, P_Age=? where Email=?";
PreparedStatement ps14
= con.prepareStatement(sql14);
ps14.setString(1, P_name1);
ps14.setString(2, age1);
ps14.setString(3, Email1);
ps14.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from "
+ "Mahalaxmi Travels");
System.out.println(
"Thanks for choosing "
+ "Mahalaxmi Travels.... "
+ "Happy and safe Journey");
break;
case 4:
String sql15
= "UPDATE shreenath_travels_bus "
+ "SET P_Name=?, P_Age=? where Email=?";
PreparedStatement ps15
= con.prepareStatement(sql15);
ps15.setString(1, P_name1);
ps15.setString(2, age1);
ps15.setString(3, Email1);
ps15.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from "
+ "Royal Travels");
System.out.println(
"Thanks for choosing "
+ "Shreenath Travels.... "
+ "Happy and safe Journey");
break;
case 5:
String sql16
= "UPDATE upsrtc_bus "
+ "SET P_Name=?, P_Age=? "
+ "where Email=?";
PreparedStatement ps16
= con.prepareStatement(sql16);
ps16.setString(1, P_name1);
ps16.setString(2, age1);
ps16.setString(3, Email1);
ps16.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from UP "
+ "govt. UPSRTC bus");
System.out.println(
"Thanks for choosing "
+ "UP govt. UPSRTC bus...."
+ " Happy and safe Journey");
break;
case 6:
String sql11
= "UPDATE royal_travels_bus"
+ " SET P_Name=?, P_Age=? "
+ "where Email=?";
PreparedStatement ps11
= con.prepareStatement(sql11);
ps11.setString(1, P_name1);
ps11.setString(2, age1);
ps11.setString(3, age1);
ps11.executeUpdate();
System.out.println(
"Your ticket is updated "
+ "successfully from "
+ "Royal Travels");
System.out.println(
"Thanks for choosing "
+ "Royal Travels.... "
+ "Happy and safe Journey");
break;
default:
System.out.println(
"Invalid cancellation choise");
break;
}
break;
case 4:
System.out.println(
"Select bus in which "
+ "you want to print your ticket");
System.out.println(
" 1: Shatabdi Travels"
+ "\n"
+ "\n"
+ " 2: Blueworld Travels"
+ "\n"
+ "\n"
+ " 3: Mahalaxmi Travels"
+ "\n"
+ "\n"
+ " 4: Shreenath Travels"
+ "\n"
+ "\n"
+ " 5: UP govt. upsrtc bus"
+ "\n"
+ "\n"
+ " 6: Royal Travels"
+ "\n"
+ "\n"
+ " Select any one");
int PrntCH = zz.nextInt();
String PEmail
= JOptionPane.showInputDialog(
"Enter the Email to print ticket");
switch (PrntCH) {
case 1:
String sql21
= "SELECT JourneyDate, "
+ "P_Name, P_Age, Source, "
+ "Destination, BusType, "
+ "Email, SeatType FROM "
+ "shatabdi_travels_bus "
+ "WHERE Email= ?";
PreparedStatement ps21
= con.prepareStatement(sql21);
ps21.setString(1, PEmail);
ResultSet rs1 = ps21.executeQuery();
while (rs1.next()) {
System.out.println(
"Journey Date : "
+ rs1.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs1.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs1.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs1.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs1.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs1.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs1.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs1.getString("SeatType"));
}
rs1.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shatabdi Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 2:
String sql22
= "SELECT JourneyDate, "
+ "P_Name, P_Age, Source, "
+ " Destination, BusType, "
+ "Email, SeatType FROM "
+ "blueworld_travels_bus "
+ "WHERE Email= ?";
PreparedStatement ps22
= con.prepareStatement(sql22);
ps22.setString(1, PEmail);
ResultSet rs2 = ps22.executeQuery();
while (rs2.next()) {
System.out.println(
"Journey Date : "
+ rs2.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs2.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs2.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs2.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs2.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs2.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs2.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs2.getString("SeatType"));
}
rs2.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Blueworld Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 3:
String sql23
= "SELECT JourneyDate, P_Name, "
+ "P_Age, Source, Destination, "
+ " BusType, Email, "
+ "SeatType FROM "
+ "mahalaxmi_travels_bus "
+ "WHERE Email= ?";
PreparedStatement ps23
= con.prepareStatement(sql23);
ps23.setString(1, PEmail);
ResultSet rs3 = ps23.executeQuery();
while (rs3.next()) {
System.out.println(
"Journey Date : "
+ rs3.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs3.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs3.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs3.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs3.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs3.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs3.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs3.getString("SeatType"));
}
rs3.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Mahalaxmi Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 4:
String sql24
= "SELECT JourneyDate, P_Name, "
+ "P_Age, Source, Destination, "
+ "BusType, Email, SeatType "
+ "FROM shreenath_travels_bus "
+ "WHERE Email= ?";
PreparedStatement ps24
= con.prepareStatement(sql24);
ps24.setString(1, PEmail);
ResultSet rs4 = ps24.executeQuery();
while (rs4.next()) {
System.out.println(
"Journey Date : "
+ rs4.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs4.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs4.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs4.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs4.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs4.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs4.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs4.getString("SeatType"));
}
rs4.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Shreenath Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 6:
String sql25
= "SELECT JourneyDate, P_Name, "
+ "P_Age, Source, Destination, "
+ "BusType, Email, SeatType "
+ "FROM royal_travels_bus "
+ "WHERE Email= ?";
PreparedStatement ps25
= con.prepareStatement(sql25);
ps25.setString(1, PEmail);
ResultSet rs5 = ps25.executeQuery();
while (rs5.next()) {
System.out.println(
"Journey Date : "
+ rs5.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs5.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs5.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs5.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs5.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs5.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs5.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs5.getString("SeatType"));
}
rs5.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing "
+ "Royal Travels.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
case 5:
String sql26
= "SELECT JourneyDate, P_Name, "
+ " P_Age, Source, Destination, "
+ "BusType, Email, SeatType "
+ "FROM upsrtc_bus WHERE "
+ "Email= ?";
PreparedStatement ps26
= con.prepareStatement(sql26);
ps26.setString(1, PEmail);
ResultSet rs6 = ps26.executeQuery();
while (rs6.next()) {
System.out.println(
"Journey Date : "
+ rs6.getString("JourneyDate") + "\n"
+ "\n"
+ "Passenger Name : "
+ rs6.getString("P_Name") + "\n"
+ "\n"
+ "Passenger Age : "
+ rs6.getInt("P_Age") + "\n"
+ "\n"
+ "Source City : "
+ rs6.getString("Source") + "\n"
+ "\n"
+ "Destination City : "
+ rs6.getString("Destination") + "\n"
+ "\n"
+ "Bus Type : "
+ rs6.getString("BusType") + "\n"
+ "\n"
+ "Passenger's Email : "
+ rs6.getString("Email") + "\n"
+ "\n"
+ "Seat Type : "
+ rs6.getString("SeatType"));
}
rs6.close();
System.out.println(
"\n"
+ "\n"
+ "\n"
+ "Thanks for choosing UP govt. "
+ "UPSRTC.... "
+ "Happy and safe Journey"
+ "\n"
+ "\n"
+ "\n"
+ "\n");
break;
}
break;
}
st.close();
con.close();
System.out.println("---SQL executed successfully---");
System.out.println("Adars11h Shukla "
+ "R134218010");
}
}
Nota: El código anterior no funciona en el IDE en línea. Utilice un IDE sin conexión para ejecutar el código anterior.
Salida: Los siguientes dos videos explican el funcionamiento del código anterior.
Publicación traducida automáticamente
Artículo escrito por adarsh_shukla y traducido por Barcelona Geeks. The original can be accessed here. Licence: CCBY-SA