Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
- pageEncoding="ISO-8859-1"%>
- <!--Import some libraries that have classes that we need -->
- <%@ page import="java.io.*,java.util.*,java.sql.*,java.lang.*"%>
- <%@ page import="javax.servlet.http.*,javax.servlet.*"%>
- <!DOCTYPE html>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
- <title>Airlines</title>
- </head>
- <body>
- <%
- String flightNumber = request.getParameter("flightNumber");
- String flightClass = request.getParameter("class");
- String meal = request.getParameter("meal");
- int customerID = Integer.parseInt(request.getParameter("customerID"));
- try{
- //Create a connection string
- String url = "jdbc:mysql://mydbinstance.cmus0s9aswng.us-east-2.rds.amazonaws.com:3306/mydb";
- Class.forName("com.mysql.jdbc.Driver");
- Connection con1 = DriverManager.getConnection(url, "admin", "password");
- // New Reservation Number
- String maxReservation = "SELECT max(reservation_Number) as val FROM Reservation";
- PreparedStatement ps1 = con1.prepareStatement(maxReservation);
- ResultSet numAcc = ps1.executeQuery();
- numAcc.next();
- int newReservationNumber = numAcc.getInt("val");
- newReservationNumber +=1;
- con1.close();
- int flightFee = 0;
- Connection con4 = DriverManager.getConnection(url, "admin", "password");
- ps1 = con4.prepareStatement("SELECT * FROM Flight WHERE flight_Number=" + flightNumber);
- ResultSet fl = ps1.executeQuery();
- fl.next();
- int price = fl.getInt("fare");
- con4.close();
- // Create Reservation
- Connection con3 = DriverManager.getConnection(url, "admin", "password");
- ps1 = con3.prepareStatement("INSERT INTO Reservation (reservation_Number, date, customerRep, passengers, specialMeal, class, bookingFee, totalFare) VALUES (?, CURRENT_TIMESTAMP, 0, 1, ?, ?, 50, ?)");
- ps1.setInt(1, newReservationNumber);
- ps1.setString(2, meal);
- ps1.setString(3, flightClass);
- ps1.setInt(4, price + 50);
- ps1.executeUpdate();
- con3.close();
- // Create Purchase
- Connection con2 = DriverManager.getConnection(url, "admin", "password");
- ps1 = con2.prepareStatement("INSERT INTO W_Purchase (resFk1, accountNumberFk2, flightFk1) VALUES (?, ?, ?)");
- ps1.setInt(1, newReservationNumber);
- ps1.setInt(2, customerID);
- ps1.setInt(3, Integer.parseInt(flightNumber));
- ps1.executeUpdate();
- con2.close();
- out.print("Reserved a seat on flight: " + flightNumber);
- }
- catch(Exception ex)
- {
- out.print("Could not reserve a seat on flight: " + flightNumber);
- }
- %>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement