📄 addorder.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:useBean id="cart" class="cart.Cart" scope="session"/>
<html>
<link rel="stylesheet" type="text/css" href="style.css"/>
<body background="images/bg01.gif">
<center>
<%
String orderid="";
String logid="";
String logname="";
String bookid="";
String sum="";
String sql="";
ResultSet rs=null;
request.setCharacterEncoding("gb2312");
if(request.getParameter("sum")!=null)
sum=request.getParameter("sum");
logid=(String)session.getAttribute("id");
logname=(String)session.getAttribute("name");
orderid=logid;
if(logid.length()<8)
{
int num=8-logid.length();
for(int i=0;i<num;i++)
orderid="0"+orderid;
}
sql="select max(id) from orderinfo";
rs=conn.executeQuery(sql);
String mid="";
if(rs.next())
mid=rs.getString(1);
if(mid==null)
mid="0";
rs.close();
orderid="EBS"+orderid+mid;
String[] id = cart.getItems();
for (int i=0; i<id.length; i++)
bookid+=id[i]+",";
if(!bookid.equals(""))
{
sql="insert into orderinfo(orderid,userid,username,bookid,orderdate,orderstate) values('"+orderid+"',"+logid+",'"+logname+"','"+bookid+"',date(),'未交货')";
conn.executeUpdate(sql);
conn.close();
cart.clearAll();
%>
<table width="90%" cellpadding="3" cellspacing="0" border bordercolor="blue" bordercolorlight="#FFFFFF">
<tr>
<th align="center" background="images/bg04.gif" height="26">订单信息</th>
<tr>
<td><font size="2">您的订单号为<font color="red"><%=orderid%></font>，请保留此订单号，我们将以此作为付货的依据！</font></td>
<tr>
<td>本次购书总金额为<%=sum%>元，我们将会在三个工作日内送书上门，有任何问题请直接<a href="mailto:bookstore_admin@hotmail.com">联系我们！</a></td>
</table>
<%
}
else
out.println("<h3>对不起，请不要重复提交订单！</h3>");
%>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -