📄 checkout.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../incoming/common.jsp"%>
<%@ include file="../incoming/check.jsp"%>
<html>
<head>
<title>音乐天堂</title>
<style type="text/css">
<!--
body {
background-image: url(../Images/bg01.gif);
}
.style9 {
font-size: 12pt;
font-weight: bold;
}
.style11 {font-size: 14px}
-->
</style>
<link href="../theme/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
Vector buylist = (Vector)session.getValue("shopcar");
if(buylist==null||buylist.size()<1)
{
%>
<jsp:forward page="index.jsp"></jsp:forward>
<%}
String userid = (String)session.getValue("userid");
float pricenum =0;
for(int i=0;i<buylist.size();i++)
{
Book book = (Book)buylist.elementAt(i);
pricenum = pricenum + book.getBuynum()*book.getPrice();
}
DBSQLManager dbsm = new DBSQLManager();
String sql="INSERT INTO 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 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();
for(int j=0; j<buylist.size(); j++)
{
Book book = (Book)buylist.elementAt(j);
DBSQLManager _dbsm = new DBSQLManager();
String _sql="INSERT INTO orderitem(ORDER_ID, ISBN, BOOK_NUM) VALUES('"+orderid+"','"+book.getIsbn()+"','"+book.getBuynum()+"')";
_dbsm.setSqlStr(_sql);
_dbsm.executeUpdate();
_dbsm.close();
}
%>
<br><a class="title">谢谢您的购买！</a><br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -