<%@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);
session.setAttribute("cust_id", cust_id);
%>
<%=username %>
@<%=thisUser %>
Cancel Booking
<%
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}
%> 