checkout.jsp

来自「jsp学习的好资料」· JSP 代码 · 共 55 行

JSP
55 行
字号 
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@ include file="incoming/header.jsp"%> 
<%
	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>
<%@ include file="incoming/footer.jsp"%>  
</body>
</html>

checkout.jsp - 源码说明

本页面展示了「jsp学习的好资料」中的 checkout.jsp 源码文件，采用 JSP 编程语言编写，共 55 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与jsp相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?