order_deal.jsp

采用TOMCAT+SQL编程

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@ page import="java.util.Vector"%>
<%@ page import="beans.bookelement"%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<%String flag="true";
  int temp=0;
  int orderID=0;
  String username=(String)session.getAttribute("Username");
  String carry=chstr.chStr(request.getParameter("carry"));
  String pay=chstr.chStr(request.getParameter("pay"));
  String sql="insert into orderdata(username,carry,pay)values('"+username+"','"+carry+"','"+pay+"')";
  temp=conndb.executeUpdate_id(sql);
  if(temp==0){flag="false";}
  else{orderID=temp;
       Vector cart=(Vector)session.getAttribute("cart");
      
       int number=0;
       
       for(int i=0;i<cart.size();i++)
          {bookelement mybookelement=(bookelement)cart.elementAt(i);
           String bookid=mybookelement.bookid;
           number=mybookelement.number;
           String sqll="insert into order_detail(orderID,bookid,number)values("+orderID+",'"+bookid+"',"+number+")";
           temp=conndb.executeUpdate(sqll);
           if(temp==0){flag="false";}
          }}
if(flag.equals("false")){%>
<table width="100%">
<tr bgcolor="E0E0E0" valign="top"> 
  <td bgcolor="E0E0E0" align="center"><font size="2"><%out.println("定单提交失败");%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="top"> 
  <td bgcolor="E0E0E0"><div align="center">
        <input name="submit" type="button" value="确定" onClick="history.back(1);">
  </div></td>
</tr>
</table>    
<%}else{session.removeAttribute("cart");%>
<table width="100%">
<tr bgcolor="E0E0E0" valign="top"> 
  <td bgcolor="E0E0E0" align="center"><font size="2"><%out.println("定单提交成功，请记住定单号：");%><%=orderID%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="top"> 
  <td bgcolor="E0E0E0"><div align="center">
        <input name="submit" type="button" value="确定" onClick="window.location.href='../book/index.jsp';">
  </div></td>
</tr>
</table>
<%}conndb.close();%>