<%@ include file="!include/var.jsp" %> <% order.setConnectionPool(htnPool); %> <%@ include file="checkSession.jsp" %> <% DBResult dbresult = order.selOrder(); int iRowCount = dbresult.getRowCount(); String action = request.getParameter("action"); if(action==null) { action = ""; } %> display orders
Orders

Log off
<%----%> <% //SiteDirectory siteDir = new SiteDirectory(); for(int i=0; i <%-- --%> <% } %>
 id date  time  contact  company  address  city  postcode  country  phone  fax  email  product  quantity  per  delivery  destination  comment  delete
 <%=clientId %> <%=orderDay %>_<%=orderMonth %>_<%=orderYear %>  <%=orderHour %>:<%=orderMinute %>  <%=orderGender %> <%=orderContact %>  <%=orderCompany %>  <%=orderAddress %>  <%=orderCity %>  <%=orderPostal %>  <%=orderCountry %>  <%=orderPhone %>  <%=orderFax %>  <%=orderEmail %>  <%=orderProduct %>  <%=orderQuantity %>  <%=orderPer %>  <%=orderDelivery %>  <%=orderDestination %>  <%=orderComment %>  delete
<% if(action.equals("delete")) { //SiteDirectory siteDir = new SiteDirectory(); String strOrderId = request.getParameter("orderId"); int order_id = Integer.parseInt(strOrderId); if(order.delete(order_id)) { %> <%-- --%> Successful deletion of order record <% response.sendRedirect("dispOrder.jsp"); } } %>