<%@page import="java.sql.SQLException"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="java.util.ArrayList"%> <%-- This line is necessary of you want to handle session in a JSP code by yourself --%> <%@page language="java" session="false" %> Shoppe Bootstarp Website Template | Buy :: w3layouts

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) { %>
create account
<% }%>

    • Your cart : <% HttpSession sess_emp = request.getSession(true); if(sess_emp.getAttribute("shopping") != null) { %>

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

      <%} else { %>

      empty

      • <%}%>
<% ArrayList arr = (ArrayList )request.getAttribute("List"); int i = 0 ; int total_price = 0 ; while(i < arr.size()) { String src = null; String price = null; String desc = null; Connection conn = null; Statement stmt = 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"; ResultSet rs = stmt.executeQuery(sql); //STEP 5: Extract data from result set while(rs.next()) { int id = rs.getInt("ID"); if(Integer.toString(id).equals(arr.get(i)) ) { src = rs.getString("Src"); price = rs.getString("Price"); desc = rs.getString("Description"); break; } } 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 } total_price = total_price + Integer.parseInt(price); %>
<% i++ ; %>

<%=desc%>

size xl   qty 1 | code :1175

           <%=price %>

<% } %>

gift wrap for rs. 25

place order

total   <%=total_price %>