📄 manage.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.bwm.db.Condb"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Vector"%>
<%@ page import="com.bwm.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();
Condb con=new Condb();
String subid=request.getParameter("subid");
String username=request.getParameter("username");
String name=request.getParameter("name");
String email=request.getParameter("email");
String address=request.getParameter("address");
String post=request.getParameter("post");
String pay=request.getParameter("pay");
String teleph=request.getParameter("teleph");
String carry=request.getParameter("carry");
String demo=request.getParameter("demo");
String sql="insert into tb_Sub(Sub,Username,Rname,Spdate,Email,Address,Post,Payment,Photo,Carry,Spif,Other) values('"+subid+"','"+username+"','"+name+"','"+dat+"','"+email+"','"+address+"','"+post+"','"+pay+"','"+teleph+"','"+carry+"','"+0+"','"+demo+"')";
int temp=con.executeUpdate(sql);
Vector shop=(Vector)session.getAttribute("shop");
int number=0;
int price=0;
int num=0;
for(int i=0;i<shop.size();i++){
buyList mylist=(buyList)shop.elementAt(i);
String warename=mylist.warename;
price=mylist.price;
number=mylist.number;
String str="insert into tb_Shop(Subid,Warename,Price,Wsum,Wcount)values('"+subid+"','"+warename+"','"+price+"','"+number+"','"+number*price+"')";
int te=con.executeUpdate(str);
}
if(temp>0){
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 + -