Advertisement
Guest User

Untitled

a guest
Aug 9th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.02 KB | None | 0 0
  1. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  2.     pageEncoding="ISO-8859-1"%>
  3. <!--Import some libraries that have classes that we need -->
  4. <%@ page import="java.io.*,java.util.*,java.sql.*,java.lang.*"%>
  5. <%@ page import="javax.servlet.http.*,javax.servlet.*"%>
  6. <!DOCTYPE html>
  7. <html>
  8. <head>
  9. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  10. <meta name="viewport" content="width=device-width, initial-scale=1">
  11. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  12. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  13. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  14. <title>Airlines</title>
  15. </head>
  16. <body>
  17.     <%
  18.    
  19.     String flightNumber = request.getParameter("flightNumber");
  20.     String flightClass = request.getParameter("class");
  21.     String meal = request.getParameter("meal");
  22.     int customerID = Integer.parseInt(request.getParameter("customerID"));
  23.    
  24.      try{
  25.         //Create a connection string
  26.         String url = "jdbc:mysql://mydbinstance.cmus0s9aswng.us-east-2.rds.amazonaws.com:3306/mydb";
  27.         Class.forName("com.mysql.jdbc.Driver");
  28.  
  29.         Connection con1 = DriverManager.getConnection(url, "admin", "password");
  30.        
  31.         // New Reservation Number
  32.         String maxReservation = "SELECT max(reservation_Number) as val FROM Reservation";
  33.         PreparedStatement ps1 = con1.prepareStatement(maxReservation);
  34.         ResultSet numAcc = ps1.executeQuery();
  35.         numAcc.next();
  36.         int newReservationNumber = numAcc.getInt("val");
  37.         newReservationNumber +=1;
  38.         con1.close();  
  39.        
  40.         int flightFee = 0;
  41.         Connection con4 = DriverManager.getConnection(url, "admin", "password");
  42.         ps1 = con4.prepareStatement("SELECT * FROM Flight WHERE flight_Number=" + flightNumber);
  43.         ResultSet fl = ps1.executeQuery();
  44.         fl.next();
  45.         int price = fl.getInt("fare");
  46.         con4.close();
  47.        
  48.             // Create Reservation
  49.         Connection con3 = DriverManager.getConnection(url, "admin", "password");
  50.             ps1 = con3.prepareStatement("INSERT INTO Reservation (reservation_Number, date, customerRep, passengers, specialMeal, class, bookingFee, totalFare) VALUES (?, CURRENT_TIMESTAMP, 0, 1, ?, ?, 50, ?)");
  51.         ps1.setInt(1, newReservationNumber);
  52.         ps1.setString(2, meal);
  53.         ps1.setString(3, flightClass);
  54.         ps1.setInt(4, price + 50);
  55.         ps1.executeUpdate();
  56.         con3.close();
  57.        
  58.            
  59.         // Create Purchase
  60.         Connection con2 = DriverManager.getConnection(url, "admin", "password");
  61.         ps1 = con2.prepareStatement("INSERT INTO W_Purchase (resFk1, accountNumberFk2, flightFk1) VALUES (?, ?, ?)");
  62.             ps1.setInt(1, newReservationNumber);
  63.             ps1.setInt(2, customerID);
  64.             ps1.setInt(3, Integer.parseInt(flightNumber));
  65.             ps1.executeUpdate();
  66.             con2.close();
  67.        
  68.         out.print("Reserved a seat on flight: " + flightNumber);
  69.     }
  70.      catch(Exception ex)
  71.      {
  72.         out.print("Could not reserve a seat on flight: " + flightNumber);
  73.      }
  74.          
  75.     %>
  76. </body>
  77. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement