📄 manage.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Vector"%>
<%@ page import="cart.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();
String subid = request.getParameter("subid");
String username = request.getParameter("username");
String rname = request.getParameter("rname");
String userid = request.getParameter("userid");
String totalprice = request.getParameter("totalprice");
String demo = request.getParameter("demo");
String address = request.getParameter("address");
String post = request.getParameter("post");
String pay = request.getParameter("pay");
String sendway = request.getParameter("sendway");
String stime = request.getParameter("stime");
String tel = request.getParameter("teleph");
String sql = "insert into userorderlist(OrderlistNo,UserName,RealName,UserID,SubmitTime,TotalPrice,IsPayoff,IsSendout,Allinfo,UserAddress,Tel,Post,OrderlistState,Way,SendWay) values('"
+ subid
+ "','"
+ username
+ "','"
+ rname
+ "','"
+ userid
+ "','"
+ stime
+ "','"
+ totalprice
+ "', '否' , '否' ,'"
+ demo
+ "','"
+ address + "','" + tel + "','" + post + "', '未处理','" + pay + "','" + sendway + "')";
int temp = databean.executeUpdate(sql);
Vector shop = (Vector) session.getAttribute("shop");
int number = 0;
double price = 0;
int num = 0;
if (totalprice == null || totalprice.equals("")) {
out
.println("<script language='javascript'>alert('金额有误，订单无效');window.location.href='index_order.jsp';</script>");
} else {
for (int i = 0; i < shop.size(); i++) {
buyList mylist = (buyList) shop.elementAt(i);
String bookno = mylist.bookno;
String bookname = mylist.bookname;
price = mylist.price;
number = mylist.number;
String str = "insert into orderlist(OrderlistNo,BookName,BookNo,Number,Price)values('"
+ subid
+ "','"
+ bookname
+ "','"
+ bookno
+ "','"
+ number + "','" + number * price + "')";
int te = databean.executeUpdate(str);
if (temp > 0) {
out
.println("<script language='javascript'>alert('订单生成');window.location.href='../logindindex.jsp';</script>");
} else {
out
.println("<script language='javascript'>alert('订单无效');history.back();</script>");
}
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -