<%@page import="java.sql.*"%>
Order Items
<%
String ordid = request.getParameter("ordid");
String status = request.getParameter("status");
String cmd = "select oi.isbn,title, oi.price,qty, oi.price * qty amount from orderitem oi, books b where b.isbn = oi.isbn and ordid = " + ordid;
Connection con = user.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(cmd);
%>
| ISBN
| Title
| Price
| Quantity
| Amount
|
<%
while ( rs.next())
{
%>
| <%=rs.getInt(1)%>
| <%= rs.getString(2)%>
| <%= rs.getInt(3)%>
| <%= rs.getString(4)%>
| <%= rs.getString(5)%>
|
<%
}
rs.close();
st.close();
con.close();
%>
<%
if ( status.equals("n"))
{
%>
Cancel This Order
<%
}
%>
Back