16.10. WEB-INF/classes/com/cybertrails/admin

This folder contains the GetOrderBean, which allows the site merchant or administrator (in conjunction with the viewCompletedOrder JSP) to view all of the orders that have been placed but not yet processed. This allows the merchant to charge the card and fulfill the order.

16.10.1. GetOrderBean.java

 package com.cybertrails.admin; import java.util.*; import java.sql.*; import javax.servlet.http.*; import javax.servlet.*; public class GetOrderBean { //variables private Connection con; private String error; // constructor public GetOrderBean() { } public ResultSet getNewOrders() throws SQLException, Exception { ResultSet rs = null; String SQL; SQL = "SELECT o.orderid, o.customerid, o.shipinfoid, o.subtotal, ...

Get Java™ for ColdFusion® Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.