?? shoppingcart.jsp
字號:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="Common.jsp" %><%!
// Filename: ShoppingCart.jsp
static final String sFileName = "ShoppingCart.jsp";
%><%
String cSec = checkSecurity(1, session, response, request);
if ("sendRedirect".equals(cSec) ) return;
boolean bDebug = false;
String sAction = getParam( request, "FormAction");
String sForm = getParam( request, "FormName");
String sItemsErr = "";
String sTotalErr = "";
String sMemberErr = "";
java.sql.Connection conn = null;
java.sql.Statement stat = null;
String sErr = loadDriver();
conn = cn();
stat = conn.createStatement();
if ( ! sErr.equals("") ) {
try {
out.println(sErr);
}
catch (Exception e) {}
}
if ( sForm.equals("Member") ) {
sMemberErr = MemberAction(request, response, session, out, sAction, sForm, conn, stat);
if ( "sendRedirect".equals(sMemberErr)) return;
}
%>
<html>
<head>
<title>Book Store</title>
<meta http-equiv="pragma" content="no-cache"/>
<meta http-equiv="expires" content="0"/>
<meta http-equiv="cache-control" content="no-cache"/>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body style="background-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helveticabackground-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica">
<jsp:include page="Header.jsp" flush="true"/>
<table>
<tr>
<td valign="top">
<% Member_Show(request, response, session, out, sMemberErr, sForm, sAction, conn, stat); %>
</td>
</tr>
</table>
<table>
<tr>
<td valign="top">
<% Items_Show(request, response, session, out, sItemsErr, sForm, sAction, conn, stat); %>
</td>
</tr>
</table>
<table>
<tr>
<td valign="top">
<% Total_Show(request, response, session, out, sTotalErr, sForm, sAction, conn, stat); %>
</td>
</tr>
</table>
<jsp:include page="Footer.jsp" flush="true"/>
</body>
</html>
<%%>
<%
if ( stat != null ) stat.close();
if ( conn != null ) conn.close();
%>
<%!
void Items_Show (javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, javax.servlet.http.HttpSession session, javax.servlet.jsp.JspWriter out, String sItemsErr, String sForm, String sAction, java.sql.Connection conn, java.sql.Statement stat) throws java.io.IOException {
String sWhere = "";
int iCounter=0;
int iPage = 0;
boolean bIsScroll = true;
boolean hasParam = false;
String sOrder = "";
String sSQL="";
String transitParams = "";
String sQueryString = "";
String sPage = "";
int RecordsPerPage = 20;
String sSortParams = "";
String formParams = "";
String pUserID="";
boolean bReq = true;
// Build WHERE statement
//-- Check UserID parameter and create a valid sql for where clause
pUserID = (String)session.getAttribute("UserID");
if ( ! isNumber (pUserID)) {
pUserID = "";
}
if (pUserID != null && ! pUserID.equals("")) {
hasParam = true;
sWhere += "member_id=" + pUserID;
}
else bReq = false;
if (hasParam) { sWhere = " AND (" + sWhere + ")"; }
// Build full SQL statement
sSQL = "SELECT order_id, name, price, quantity, member_id, quantity*price as sub_total FROM items, orders WHERE orders.item_id=items.item_id" + sWhere + " ORDER BY order_id";
String sNoRecords = " <tr>\n <td colspan=\"6\" style=\"background-color: #FFFFFF; border-width: 1\"><font style=\"font-size: 10pt; color: #000000\">No records</font></td>\n </tr>";
String tableHeader = "";
tableHeader = " <tr>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">詳細</font></td>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">訂單編號</font></td>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">書名</font></td>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">價格</font></td>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">數量</font></td>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">合計</font></td>\n </tr>";
try {
out.println(" <table style=\"\">");
out.println(" <tr>\n <td style=\"background-color: #336699; text-align: Center; border-style: outset; border-width: 1\" colspan=\"6\"><a name=\"Items\"><font style=\"font-size: 12pt; color: #FFFFFF; font-weight: bold\">定購書籍信息</font></a></td>\n </tr>");
out.println(tableHeader);
if ( ! bReq ) {
out.println(sNoRecords);
out.println(" </table>");
return;
}
}
catch (Exception e) {}
try {
java.sql.ResultSet rs = null;
// Open recordset
rs = openrs( stat, sSQL);
iCounter = 0;
java.util.Hashtable rsHash = new java.util.Hashtable();
String[] aFields = getFieldsName( rs );
// Show main table based on recordset
while ( rs.next() ) {
getRecordToHash( rs, rsHash, aFields );
String flditem_id = (String) rsHash.get("name");
String fldorder_id = (String) rsHash.get("order_id");
String fldprice = (String) rsHash.get("price");
String fldquantity = (String) rsHash.get("quantity");
String fldsub_total = (String) rsHash.get("sub_total");
String fldField1= "Details";
out.println(" <tr>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<a href=\"ShoppingCartRecord.jsp?"+transitParams+"order_id="+toURL((String) rsHash.get("order_id"))+"&\"><font style=\"font-size: 10pt; color: #000000\">"+toHTML(fldField1)+"</font></a>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<font style=\"font-size: 10pt; color: #000000\">"+toHTML(fldorder_id)+" </font>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<font style=\"font-size: 10pt; color: #000000\">"+toHTML(flditem_id)+" </font>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<font style=\"font-size: 10pt; color: #000000\">"+toHTML(fldprice)+" </font>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<font style=\"font-size: 10pt; color: #000000\">"+toHTML(fldquantity)+" </font>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">"); out.print("<font style=\"font-size: 10pt; color: #000000\">"+toHTML(fldsub_total)+" </font>");
out.println("</td>");
out.println(" </tr>");
iCounter++;
}
if (iCounter == 0) {
// Recordset is empty
out.println(sNoRecords);
iCounter = RecordsPerPage+1;
bIsScroll = false;
}
if ( rs != null ) rs.close();
out.println(" </table>");
}
catch (Exception e) { out.println(e.toString()); }
}
void Total_Show (javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response, javax.servlet.http.HttpSession session, javax.servlet.jsp.JspWriter out, String sTotalErr, String sForm, String sAction, java.sql.Connection conn, java.sql.Statement stat) throws java.io.IOException {
String sWhere = "";
int iCounter=0;
int iPage = 0;
boolean bIsScroll = true;
boolean hasParam = false;
String sOrder = "";
String sSQL="";
String transitParams = "";
String sQueryString = "";
String sPage = "";
int RecordsPerPage = 20;
String sSortParams = "";
String formParams = "";
String pUserID="";
boolean bReq = true;
// Build WHERE statement
//-- Check UserID parameter and create a valid sql for where clause
pUserID = (String)session.getAttribute("UserID");
if ( ! isNumber (pUserID)) {
pUserID = "";
}
if (pUserID != null && ! pUserID.equals("")) {
hasParam = true;
sWhere += "member_id=" + pUserID;
}
else bReq = false;
if (hasParam) { sWhere = " AND (" + sWhere + ")"; }
// Build full SQL statement
sSQL = "SELECT member_id, sum(quantity*price) as sub_total FROM items, orders WHERE orders.item_id=items.item_id" + sWhere + " GROUP BY member_id";
String sNoRecords = " <tr>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-width: 1\"><font style=\"font-size: 10pt; color: #000000\">No records</font></td>\n </tr>";
String tableHeader = "";
tableHeader = " <tr>\n <td colspan=\"1\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">總價</font></td>\n </tr>";
try {
out.println(" <table style=\"\">");
out.println(tableHeader);
if ( ! bReq ) {
out.println(sNoRecords);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -