📄 cart.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:useBean id="cart" class="cart.Cart" scope="session"/>
<html>
<link rel="stylesheet" type="text/css" href="style.css"/>
<body background="images/bg01.gif">
<p><center>
<table width="95%" cellpadding="3" cellspacing="0" border bordercolor="blue" bordercolorlight="#FFFFFF">
<tr>
<th colspan="6" align="center" background="images/bg04.gif" height="26">查看购物车</th>
<%
String[] id = cart.getItems();
if(id.length==0)
out.println("<tr><td><h3>您的购物车暂时为空！</h3><a href='list.jsp'>返回</a></td>");
else
{
%>
<tr>
<td colspan="6">您的购物车中目前有如下书籍：</td>
<tr align="center">
<th>
序号</th><th>书名</th><th>作者</th><th>出版社</th><th>价格</th><th>从购物车中删除</th>
<%
String sql="";
ResultSet rs=null;
for (int i=0; i<id.length; i++)
{
out.println("<tr align='center'>");
out.println("<td>"+(i+1)+"</td>");
sql="select * from book where bookid="+id[i];
rs=conn.executeQuery(sql);
if(rs.next())
{
out.println("<td>"+rs.getString("bookname")+"</td>");
out.println("<td>"+rs.getString("author")+"</td>");
out.println("<td>"+rs.getString("pubhouse")+"</td>");
out.println("<td>"+rs.getString("price")+"</td>");
out.println("<td><a href='dealcart.jsp?dealid="+id[i]+"&act=remove'>从购物车中删除</a></td>");
}
rs.close();
}
%>
<tr align="center">
<td colspan="6">
<a href="buy.jsp">立即购买</a>
<a href="list.jsp">返回</a>
</td>
<%
}
%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -