<%@page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="java.util.*" %> <%@ page import="javax.servlet.http.*" %> <%! int number; String bookingdate,packagename,pname,name,email,password,street,state,city,country,packtype,numberadult,numberchild,phone,month,day,year,date,comment; %> <% try { String id1=(String)session.getAttribute("email"); Class.forName("com.ibm.db2.jcc.DB2Driver"); Connection Conn= DriverManager.getConnection("jdbc:db2://localhost:50000/BUNDIDB","db2admin","db2admin"); Statement s=Conn.createStatement(); ResultSet rst=s.executeQuery("SELECT * from ADMIN.USERS where USEREMAIL='"+id1+"'"); while(rst.next()) { name=rst.getString(1); email=rst.getString(2); street=rst.getString(4); state=rst.getString(5); city=rst.getString(6); country=rst.getString(7); packtype=rst.getString(8); numberadult=rst.getString(9); phone=rst.getString(10); date=rst.getString(11); comment=rst.getString(12); numberchild=rst.getString(13); packagename=rst.getString(14); bookingdate=rst.getString(15); } pname=request.getParameter("packagename"); number=Integer.parseInt(numberadult); Conn.close(); } catch (Exception e) { e.printStackTrace(); } %> Booking
<%! String str; %> <% str=(String)session.getAttribute("name"); %> <% if (session.isNew()==true || str==null) { %>
Email: Password:
<%} else if(session.isNew()==false) {%> Welcome, <% str=(String)session.getAttribute("name"); out.println(str); String email=(String)session.getAttribute("email"); %>    History |Change Password | Logout <%}%>

Book your trip ...
Your Booking history is as follows

Name* <%= name %>
Email* <%= email %>
Street* <%= street %>
State* <%= state %>
City* <%= city %>
Country* <%= country %>
Package Type* <%= packtype %>
Package Name <%= packagename %>
No. of People Traveling* Adults* <%= numberadult %> Children <%= numberchild %>
Contact Number* <%= phone %>
Tentative date to start your trip* <%= date %>
Date of Booking <%= bookingdate %>
Travel related comments <%= comment %>