-
Notifications
You must be signed in to change notification settings - Fork 11
/
add_flight_validation.jsp
57 lines (51 loc) · 3.11 KB
/
add_flight_validation.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>
<%@page import="java.util.*,java.text.*"%>
<%
String flight_id=request.getParameter("flight_id");
String flight_no=request.getParameter("flight_no");
String flight_name=request.getParameter("flight_name");
String from_city=request.getParameter("from_city");
String to_city=request.getParameter("to_city");
String date_of_flight=request.getParameter("date_of_flight");
String flight_arrival_time=request.getParameter("flight_arrival_time");
String flight_reach_time=request.getParameter("flight_reach_time");
//String duration=request.getParameter("duration");
String first_class_seat=request.getParameter("first_class_seat");
String first_class_seat_booked="0";
String first_class_seat_aval=request.getParameter("first_class_seat");
String buss_class_seat=request.getParameter("buss_class_seat");
String buss_class_seat_booked="0";
String buss_class_seat_aval=request.getParameter("buss_class_seat");
String eco_class_seat=request.getParameter("eco_class_seat");
String eco_class_seat_booked="0";
String eco_class_seat_aval=request.getParameter("eco_class_seat");
String first_class_price=request.getParameter("first_class_price");
String buss_class_price=request.getParameter("buss_class_price");
String eco_class_price=request.getParameter("eco_class_price");
String time1 = request.getParameter("flight_arrival_time");
String time2 = request.getParameter("flight_reach_time");
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("HH:mm:ss");
Date date1 = simpleDateFormat.parse(time1);
Date date2 = simpleDateFormat.parse(time2);
long differenceInMilliSeconds = Math.abs(date2.getTime() - date1.getTime());
long differenceInHours = (differenceInMilliSeconds / (60 * 60 * 1000)) % 24;
long differenceInMinutes = (differenceInMilliSeconds / (60 * 1000)) % 60;
long differenceInSeconds = (differenceInMilliSeconds / 1000) % 60;
String duration = differenceInHours + ":" + differenceInMinutes + ":" + differenceInSeconds;
session.setAttribute("flight_id",flight_id);
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/AIRRESERVE", "root", "");
Statement st=conn.createStatement();
int i=st.executeUpdate("insert into flight_details values('"+flight_id+"','"+flight_no+"','"+flight_name+"','"+from_city+"','"+to_city+"','"+date_of_flight+"','"+flight_arrival_time+"','"+flight_reach_time+"','"+duration+"',"+first_class_seat+","+first_class_seat_booked+","+first_class_seat_aval+","+buss_class_seat+","+buss_class_seat_booked+","+buss_class_seat_aval+","+eco_class_seat+","+eco_class_seat_booked+","+eco_class_seat_aval+","+first_class_price+","+buss_class_price+","+eco_class_price+")");
response.sendRedirect("add_flight_suucess.jsp");
}
catch(Exception e)
{
response.sendRedirect("addflights_failed.jsp");
}
%>