📄 bookdatasave.jsp
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<jsp:useBean id="cart" scope="session" class="beans.CartBean" />
<html>
<head>
<title>欢迎光临E-BOOK网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@ include file="incoming/header.jsp"%>
<%
request.setCharacterEncoding("GB2312");
Collection<CartItemBean> cl = cart.getItems();
if (cl.size() <= 0) {
out.println("购物车中没有图书<p>");
%>
<%@ include file="incoming/footer.jsp"%>
<%
return;
}
Iterator<CartItemBean> it = cl.iterator();
float pricenum = cart.getTotalPrice();
String userid = (String) session.getAttribute("userid");
DBSQLManager dbsm = new DBSQLManager();
String sql = "INSERT INTO tb_myorder(USER_ID, PRICE_NUM, ORDER_DATE) VALUES('"
+ userid + "'," + pricenum + ",'" + _dateString + "')";
dbsm.setSqlStr(sql);
dbsm.executeUpdate();
dbsm.close();
DBSQLManager dbsm_ = new DBSQLManager();
String sql_ = "SELECT ORDER_ID FROM tb_myorder WHERE USER_ID='"
+ userid + "' AND ORDER_DATE='" + _dateString + "'";
dbsm_.setSqlStr(sql_);
dbsm_.executeQuery();
ResultSet rs_ = dbsm_.getRs();
rs_.next();
String orderid = rs_.getString("ORDER_ID");
dbsm_.close();
int i = 0;
while (it.hasNext()) {
CartItemBean cartItem = (CartItemBean) it.next();
BookBean book = cartItem.getBook();
int Buynum = cartItem.getQuantity();
DBSQLManager _dbsm = new DBSQLManager();
String _sql="INSERT INTO tb_orderitem(ORDER_ID, BOOK_ID, BOOK_NUM) VALUES('"+orderid+"','"+book.getId()+"','"+Buynum+"')";
_dbsm.setSqlStr(_sql);
_dbsm.executeUpdate();
_dbsm.close();
i++;
}
%>
<br>
<a class="title">谢谢您购买！</a>
<br>
<%@ include file="incoming/footer.jsp"%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -