<%@page import="java.sql.DriverManager" %> <%@page import="java.sql.ResultSet" %> <%@page import="java.sql.Statement" %> <%@page import="java.sql.Connection" %> <% if ((session.getAttribute("userid") == null) || (session.getAttribute("userid") == "")) { %> You are not logged in
Please Login <%} else { %> Welcome <%=session.getAttribute("userid")%> Log out S R | The Events Company


<% String thisUser = (String) session.getAttribute("userid");%> <% try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","srk","sunnyrk"); Statement st=con.createStatement(); ResultSet rs4=st.executeQuery("select * from customer where username='"+thisUser+"'"); rs4.next(); String username=rs4.getString(2); int cust_id=rs4.getInt(1); %>


Profile


<%=username %>

@<%=thisUser %>


Events


Booked Events

<% ResultSet rs5=st.executeQuery("SELECT b.book_id,e.event_name,h.h_name,s.day,s.month,s.year FROM booking b,event_type e,hall h,status s where (((( b.cust_id='"+cust_id+"' and b.status=1) and s.status_id=b.status_id) and h.h_id=s.hall_id) and b.event_id=e.event_id)"); while(rs5.next()) { %> <% } %>
BOOKING ID EVENT VENUE DATE
<%= rs5.getInt(1)%> <%= rs5.getString(2)%> <%= rs5.getString(3)%> <%= rs5.getString(4)%>/<%=rs5.getString(5)%>/<%=rs5.getString(6)%> Cancel Booking


Canceled Events

<% ResultSet rs6=st.executeQuery("SELECT b.book_id,e.event_name,h.h_name,s.day,s.month,s.year FROM booking b,event_type e,hall h,status s where (((( b.cust_id='"+cust_id+"' and b.status=0) and s.status_id=b.status_id) and h.h_id=s.hall_id) and b.event_id=e.event_id)"); while(rs6.next()) { %> <% } con.close(); } catch(Exception e){ e.printStackTrace(); } %>
BOOKING ID EVENT VENUE DATE
<%= rs6.getInt(1)%> <%= rs6.getString(2)%> <%= rs6.getString(3)%> <%= rs6.getString(4)%>/<%=rs6.getString(5)%>/<%=rs6.getString(6)%>



<% } %>