i have a project on how to make  FlyAway An Airline Booking Portal by using HTML and jsp and servelet and MySQL database 

<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>
<%@page import="java.sql.*"%>
<%@page import="servlet.Login"%>

<% try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } Connection connection = null; Statement statement = null; ResultSet resultSet = null; %>





FlyAway Airlines


<% if (Login.isLoggedIn) { %>

Admin Dashboard

You are LoggedIn as : <%=Login.email%>. Your Password is : <%=Login.password%>





Flight T

<%@page import="java.sql.*"%>
<%@ page import="com.model.Booking" %>
<% Booking.flight_booking_id=request.getParameter("flight_id"); %>



Booking Details – FlyAway Airlines

Booking Details – FlyAway Airlines

Booking Details

Enter Passenger Details






<%@page import="java.sql.*"%>
<%@ page import="com.model.search" %>
<% String query = search.getQuery(); try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } Connection connection = null; Statement statement = null; ResultSet resultSet = null; %>





Search Results


Showing available flights from <%=search.source%> to <%=search.destination%>
Date of travel : <%=search.date%>
No of travellers : <%=search.passengers%>

flight_id date day source destination passengers ticket_price

Select a flight

<% try{ connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/flyaway","root", "root123"); statement=connection.createStatement(); resultSet = statement.executeQuery(query); while(resultSet.next()){ %>

flight_id date day source destination passengers ticket_price
<%=resultSet.getString("flight_id") %> <%=resultSet.getString("date") %> <%=resultSet.getString("day") %> <%=resultSet.getString("source") %> <%=resultSet.getString("destination") %> <%=resultSet.getString("passengers") %> <%=resultSet.getString("ticket_price") %>

<%@page import="servlet.Login"%>
<% Login.isLoggedIn = false; %>



Admin – Login FlyAway Airlines


Admin Login




  Email : admin@flyaway.com



   Current Password :  “Admin”



FlyAway Ticket Booking

Date

Source

Saudi Arabia
USA
UK

Destination

USA
UK
Saudi Arabia

No of Passengers

1
2
3
4
5

Search Flights

Developer : Shahad Abduallah

shahadabduallah1999@gmail.com

<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>




Show Booking

Past Bookings

Showing all bookings

Coming Soon


<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>
<%@ page import="com.model.Booking" %>
<%@ page import="com.model.search" %>
<% Booking.passenger_name = request.getParameter("pname"); Booking.passenger_email= request.getParameter("email"); Booking.passenger_phone= request.getParameter("phone"); %>




Payment Details – FlyAway Airlines

Checkout

Enter Payment Details



Total fare = <%=Booking.ticket_price%> X <%=search.passengers%>
persons = SAR.<%=Booking.ticket_price*search.passengers%>



<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>
<%@ page import="com.model.search" %>
<%@ page import="com.model.Booking" %>
<% Booking.name_on_card = request.getParameter("name_on_card"); Booking.card_details = request.getParameter("card_details"); %>





Thank You – FlyAway Airlines

Thank You

Your ticket has been booked. The summary/details are as follows

Ticket Summary

<%=search.source%> to <%=search.destination%> | <%=search.date%> (<%=search.day%>)

<%=Booking.flight_booking_id%> – <%=Booking.flight_name%> (Travellers <%=search.passengers%>)

Passenger Summary

Booking Name-<%=Booking.passenger_name%> | Email- <%=Booking.passenger_email%> | Phone- <%=Booking.passenger_phone%>

Payment Summary

Payment By-<%=Booking.name_on_card%> | Card No- <%=Booking.card_details%>

Total Paid- SAR.<%=search.passengers*Booking.ticket_price%>


<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>
<%@page import="servlet.Login"%>




change Password


Password Change

<% if (Login.isLoggedIn) { %>




   Current Password : <%= Login.password %>


<% } else { out.print("You must Login first"); } %>


<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256"%>




Add a new Flight – FlyAway Airlines


Add a new Flight

Coming Soon


..FlyAway Airline..

>>Book a Flight

>>Admin Login

Developer : Shahad Abduallah

shahadabduallah1999@gmail.com

package servlet;

import java.io.IOException;

import java.time.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.model.search;

public class bookResult extends HttpServlet {
private static final long serialVersionUID = 1L;

public bookResult() {
super();
}

@Override
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
search.date=request.getParameter(“date”);
search.day=request.getParameter(“day”);
search.source=request.getParameter(“source”);
search.destination=request.getParameter(“destination”);
search.passengers=Integer.parseInt(request.getParameter(“passengers”));

response.sendRedirect(“book-result.jsp”);
}

public String getDay(String dateInp)
{
LocalDate ld= LocalDate.parse(“dateInp”);

return ld.getDayOfWeek().toString();
}

}

package servlet;
import javax.servlet.http.*;
import java.io.IOException;
import java.io.PrintWriter;

public class Login extends HttpServlet {
public static boolean isLoggedIn = false;
public static String password = “Admin”;
public static String email = “admin@flyaway.com”;

@Override
public void doPost (HttpServletRequest req, HttpServletResponse resp) throws IOException {
PrintWriter out = resp.getWriter();

String email = req.getParameter(“emailEntered”);
String pass = req.getParameter(“passwordEntered”);

if (email.equals(Login.email) && pass.equals(Login.password)){
isLoggedIn = true;
out.println(“You have LoggedIn”);
resp.sendRedirect(“admin-dashboard.jsp”);
}
else {
isLoggedIn = false;
out.println(“Login Failed : Incorrect email or Password”);
}
out.close();
}
}

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class ChangePassword extends HttpServlet {
private static final long serialVersionUID = 1L;

public ChangePassword() {
super();
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
PrintWriter out = resp.getWriter();
String pass = req.getParameter(“passwordEntered”);
if (!Login.isLoggedIn){
out.println(“You must login first”);
}
else if (pass.equals(“”)){
out.println(“Password can’t be empty”);
}
else if (Login.isLoggedIn && !pass.equals(“”)){
Login.password = pass;
out.println(“Password changed. New Password is “+Login.password);
}
else {
out.println(“Sorry, Something went wrong”);
}
out.close();
}

}

package com.model;

public class Booking {

public static String flight_booking_id;
public static int ticket_price;
public static String flight_name;

public static String passenger_name;
public static String passenger_email;
public static String passenger_phone;

public static String name_on_card;
public static String card_details;

}

package com.model;
import java.sql.*;

public abstract class search {

public static String date;
public static String day;
public static String source;
public static String destination;
public static int passengers;

public static String getQuery() {
return “SELECT * FROM flight WHERE date='”+date+”‘ AND source='”+source+”‘ AND destination ='”+destination+”‘”;
}
}




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.