import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class WSMenu extends HttpServlet {
public static Connection conn;
public static Statement stmt;
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String cno[] = request.getParameterValues("customerId");
String uAccess[] = request.getParameterValues("uAccess");
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch(ClassNotFoundException e){
out.println("Error loading the Driver:"+e.getMessage());
return;
}
Connection conn = null;
try {
conn = DriverManager.getConnection (
MyUtilities.CONNECTSTRING,MyUtilities.ID,MyUtilities.PASSWORD);
} catch (SQLException e1) {
out.println("Error connecting to Oracle:"+e1.getMessage());
return;
}
if (conn == null) {
out.println("Null Connection");
return;
}
Statement stmt = null;
try {
stmt = conn.createStatement ();
} catch (SQLException e) {
out.println("createStatement " + e.getMessage());
try {conn.close();} catch (SQLException e2) {};
return;
}
ResultSet rset = null;
// String query = "select cartno from cart where cno='"+cno[0]+"'";
// try {
// rset = stmt.executeQuery(query);
// } catch (SQLException e) {
// out.println("executeQuery " + e.getMessage());
// return;
// }
// boolean hasCart = false;
// try {
// if (rset.next()) {
// hasCart = true;
// }
// } catch (SQLException e) {
// }
out.println("");
out.println(" Customer Menu");
out.println(" ");
out.println(" ");
out.println("Customer Menu
");
out.println("CheckOut
");
out.println("Check Order Status
");
out.println("Update Profile
");
out.println("View/Edit Cart
");
out.println("Logout");
out.println("
");
out.println("
");
out.println("");
out.println("");
out.println(" ");
out.println("");
out.close();
}
public String getServletInfo() {
return "This Servlet generates Member Menu";
}
}