B - Sģʽϵͳ¿ª·¢ÊµÑµÖ¸µ¼Êé120524 - ͼÎÄ

if (username != null && username != \ String sql = \ ResultSet rs = conn.executeQuery(sql); int id = -1; String truename = \ String PWD = \ String city = \ String address = \ String postcode = \ String cardNO = \ String cardType = \ String tel = \ String email = \ if (rs.next()) { id = rs.getInt(1); truename = rs.getString(3); PWD = rs.getString(4); city = rs.getString(5); address = rs.getString(6); postcode = rs.getString(7); cardNO = rs.getString(8); cardType = rs.getString(9); tel = rs.getString(12); email = rs.getString(13); } %>

if(cardType.equals(\Éí·ÝÖ¤\%>> Éí·ÝÖ¤  > ¾ü¹ÙÖ¤

if(cardType.equals(\ѧÉúÖ¤\

%>> ѧÉúÖ¤

<% } else { out .println(\ÇëÏȵǼ£¬ÔÙÐ޸ĸöÈËÐÅÏ¢!'); window.location.href='index.jsp';\ } %>

£¨8£©¶©µ¥ÐÅÏ¢Ò³ÃæÉè¼Æorder.jsp

Ôڸù¦ÄÜÄ£¿é»áÔ±¿ÉÒԲ鿴×Ô¼ºÒÑÌá½»µÄËùÓж©µ¥£¬¿ÉÒԲ鿴¶©µ¥µÄÏêϸÇé¿ö£¬¸ÃÒ³ÃæµÄЧ¹ûÈçͼ 28 Ëùʾ£º

ͼ 3-15 ¶©µ¥ÐÅÏ¢order.jspµÄЧ¹ûͼ

¶©µ¥ÐÅÏ¢order.jsp¹Ø¼ü´úÂëÈçÏ£º¡¢

<%@ page contentType=\<%@ page import=\

<%@ page import=\<% String username = \ username = (String) session.getAttribute(\ if (username == \ out.println(\ÇëÏȵǼ!'); window.location.href='index.jsp';\ } else { connDB conn = new connDB(); ResultSet rs = conn.executeQuery(\ int orderID = 0; int bnumber = 0; String truename = \ String pay = \ String carry = \ float rebate = 1; String orderDate = \%>

<% while (rs.next()) { orderID = rs.getInt(\ bnumber = rs.getInt(\ truename = rs.getString(\ pay = rs.getString(\ carry = rs.getString(\ rebate = rs.getFloat(\ orderDate = rs.getString(\ %>

<%=bnumber%>

Top

<%=truename%>	<%=pay%>	<%=carry%>	<%=rebate * 100%>%