📄 savesub.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Vector"%>
<%@ page import="com.buyList"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>生成订单</title>
</head>
<body>
<%
Date date=new Date();
String dat=date.toLocaleString();
//insert table-Bsub添加订单
bookList.SubInfoDB subinfoDB = new bookList.SubInfoDB();
bookList.SubInfo subinfo= new bookList.SubInfo
(
0,
request.getParameter ("subNo"),
request.getParameter ("username"),
request.getParameter ("rname"),
request.getParameter ("email"),
request.getParameter ("address"),
request.getParameter ("post"),
request.getParameter ("payment"),
request.getParameter ("carry"),
0,
dat,
request.getParameter ("demo")
);
int rowsAffected = subinfoDB.addSub(subinfo);
if (rowsAffected == 1)
{
//如果购物车为空，则删除订单
//添加图书详细订购单
Vector shop=(Vector)session.getAttribute("shop");
int number=0;
float price=0;
for(int i=0;i<shop.size();i++){
buyList mylist=(buyList)shop.elementAt(i);
String booktitle=mylist.bookTitle;
price=mylist.price;
number=mylist.number;
//insert table-bookList
bookList.BookListDB blistDB = new bookList.BookListDB();
bookList.BookList blist= new bookList.BookList(1,price,number,price*number,booktitle,request.getParameter ("subNo"));
blistDB.addBookList(blist);
}
out.println("<script language='javascript'>alert('订单生成');window.location.href='../index.jsp';</script>");
}
else
{
out.println("<script language='javascript'>alert('订单无效');history.back();</script>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -