<%@page import="java.sql.ResultSet"%> <%@page import="java.sql.SQLException"%> <%@page import="java.sql.SQLException"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%-- This line is necessary of you want to handle session in a JSP code by yourself --%> <%@page language="java" session="false" %> electronic devices

50%off use coupon code "big61" and get extra 33% off on orders above rs 2,229

  • Recently viewed
  • <% HttpSession sess = request.getSession(false); if(sess == null|| sess.getAttribute("username")== null) { %>
  • Contact
  • <%} else { %>
  • Welcome <%=sess.getAttribute("username") %>
  • logout
  • <%}%>
<% if (sess==null|| sess.getAttribute("username") == null) { %> <% }%>
    • Your cart : <% HttpSession sess_emp = request.getSession(true); if(sess_emp.getAttribute("shopping") != null) { %>

      <%=sess_emp.getAttribute("shopping")%>

      <%} else { %>

      empty

    • <%}%>

filter by

catogories

brand

colour

discount

<% Connection conn = null; Statement stmt = null; int id = 0; String src = null; String cat = null; String name = null; int price = 0; String desc = null; try { Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); conn=DriverManager.getConnection("jdbc:ucanaccess:////C:\\Users\\faheem\\Documents\\NetBeansProjects\\WebApplication2\\Database1.accdb"); stmt = conn.createStatement(); String sql; sql = "SELECT * FROM images_desc where Catagory LIKE('electronic devices')"; ResultSet rs = stmt.executeQuery(sql); //STEP 5: Extract data from result set while(rs.next()) { id = rs.getInt("ID"); src = rs.getString("Src"); cat = rs.getString("Catagory"); name = rs.getString("Item_Name"); price = rs.getInt("Price"); desc = rs.getString("Description"); %>

Duis autem

<%=desc%>

<%=price%>

<% } rs.close(); stmt.close(); conn.close(); } catch(ClassNotFoundException e){ } catch (SQLException e) { } finally{ //finally block used to close resources try{ if(stmt!=null) stmt.close(); }catch(SQLException se2){ }// nothing we can do try{ if(conn!=null) conn.close(); }catch(SQLException se){ }//end finally try } //end try %>