开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 百货/超市行业 > 查看源码
saveto.jsp
资源名称：JspShop网络购物系统.rar　[点击查看]
上传用户：helenhuo66
上传日期：2007-06-01
资源大小：865k
文件大小：8k
源码类别：

百货/超市行业

开发平台：

Java

saveto.jsp：源码内容
  1. <%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  4. <title>购物成功！</title>
  5. <link href=css.css rel=STYLESHEET type=text/css>
  6. <jsp:useBean id="mdb" class="ckstudio.db.faq" scope="page"/>
  7. <%!
  8. private String getStr(String str)
  9. {
  10.   try
  11. {
  12. String temp_p=str;
  13. byte[] temp_t=temp_p.getBytes("ISO8859-1");
  14. String temp=new String(temp_t);
  15. return temp;
  16. }
  17. catch(Exception e)
  18. {
  19. e.printStackTrace();
  20.  }
  21. return "null";
  22. }
  23. %>
  24. </head> 
  25. <body topmargin="0">
  26. <%
  27. if(session.getAttribute("user_name")==null){
  28. %>
  29. <br>1.你尚未登录!请登录后再订购本站商品!<br>2.第一次来本站，请先注册会员（免费）!<br><br>
  30. <%
  31. }else{
  32. String count="";
  33. String hw_id="";
  34. if(request.getParameter("action")=="buy"){
  36. if(request.getParameter("count")==""){
  37.     int intcount=1;
  38.     count=Integer.toString(intcount);
  39. }
  40. else
  41.     count=request.getParameter("count");
  43. if(request.getParameter("hw_id")=="")
  44. out.print("没有此货物!");
  45. else{
  46.     hw_id=request.getParameter("hw_id");
  49. String sql="select * from basket where hw_id='"+hw_id+"' and user_name='"+(String)session.getValue("user_name")+"' and basket_check=false";
  50. ResultSet rs;
  51. rs=mdb.executeQuery(sql);
  53. if(!rs.next()){
  55. String sql1="insert into basket(hw_id,user_name,basket_count,hw_name,hw_cash,user_type) values('"+hw_id+"','"+session.getValue("user_name")+"','"+count+"','"+request.getParameter("hw_name")+"','"+request.getParameter("hw_cash")+"','"+request.getParameter("user_type")+"') where hw_id='"+hw_id+"' and user_name='"+session.getValue("user_name")+"' and basket_check=false";
  56.     mdb.executeInsert(sql1);
  57. }
  58. else{
  59. //rs("basket_count")=int(rs("basket_count"))+int(count)
  60. rs.next();
  61. int basket_count=Integer.parseInt(rs.getString("basket_count"));
  62. basket_count=basket_count+Integer.parseInt(count);
  63. String basket_count2=Integer.toString(basket_count);
  64. String sql2="update basket set basket_count='"+basket_count+"'";
  65. mdb.executeUpdate(sql2);
  66. }
  67. }
  68. }
  69. %>
  70. <br>
  71. <tr> 
  72.     
  73.   <td valign="top"> 
  74.     <tr> 
  75.           
  76.   <td valign="top" height="120"> 
  77.     <table border="0" width="400" cellspacing="0" cellpadding="0" height="5" align="center">
  78.       <tr> 
  79.         <td width="380" height="18"> 
  80.           <div align="center">
  81.             <TABLE cellSpacing=0 cellPadding=0 width=416 
  82.                         align=center border=0>
  83.               <TBODY>
  84.                 <TR> 
  85.                   <TD align=middle bgcolor="#DBC2B0" height="18"><%
  86.         if(request.getParameter("sub_number")=="")
  87.         out.print("没有此订单信息");
  88.         else{
  89.         String sub_to=getStr(request.getParameter("sub_to"));
  90.         String sub_adds=getStr(request.getParameter("sub_adds"));
  91.         String sub_mail=getStr(request.getParameter("sub_mail"));
  92.         String sub_tel=getStr(request.getParameter("sub_tel"));
  93. String sub_post=getStr(request.getParameter("sub_post"));
  94.         String sub_number=getStr(request.getParameter("sub_number"));
  95. String qian=getStr(request.getParameter("qian"));
  96.         String other=getStr(request.getParameter("other"));
  98.         String sql="update sub set sub_to='"+sub_to+"',sub_tel='"+sub_tel+"',sub_post='"+sub_post+"',sub_mail='"+sub_mail+"',sub_adds='"+sub_adds+"',qian='"+qian+"',other='"+other+"' where sub_number='"+sub_number+"'";
  99.         mdb.executeUpdate(sql);
  100.         %><b>购物成功！ 您的订单号是：<%=sub_number%></b>
  101.                   </TD>
  102.                 </TR>
  103.               </TBODY>
  104.             </TABLE>
  105.           </div>
  106.         </td>
  107.       </tr>
  108.       <tr> 
  109.         <td width="100%"><table width="100%" height="34" border="0" cellpadding="0" cellspacing="0">
  110.               <td width="398" height="120" valign="bottom" bgcolor="#F5EFE7" ><br>
  111.                 　 请记牢本订单号，你可以使用本订单号对成交情况进行查询和投诉<br> <br>
  112.                 <div align="center">
  113.                   <center>
  114.                 <table width="80%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
  115.                   <tr> 
  116.                     <td width="26%" height="25"> 
  117.                       <div align="right">收货人 ：</div>
  118.                     </td>
  119.                     <td width="74%" height="25"> 
  120.                       <div align="center"><%=sub_to%> </div>
  121.                     </td>
  122.                   </tr>
  123.                   <tr> 
  124.                     <td width="26%" height="25"> 
  125.                       <div align="right">地址 ：</div>
  126.                     </td>
  127.                     <td width="74%" height="25"> 
  128.                       <div align="center"><%=sub_adds%> </div>
  129.                     </td>
  130.                   </tr>
  131.                   <tr> 
  132.                     <td width="26%" height="25"> 
  133.                       <div align="right">邮编：</div>
  134.                     </td>
  135.                     <td width="74%" height="25"> 
  136.                       <div align="center"><%=sub_post%> </div>
  137.                     </td>
  138.                   </tr>
  139.                   <tr> 
  140.                     <td width="26%" height="25"> 
  141.                       <div align="right">电话：</div>
  142.                     </td>
  143.                     <td width="74%" height="25"> 
  144.                       <div align="center"><%=sub_tel%> </div>
  145.                     </td>
  146.                   </tr>
  147.                   <tr> 
  148.                     <td width="26%" height="25"> 
  149.                       <div align="right">E-mail：</div>
  150.                     </td>
  151.                     <td width="74%" height="25"> 
  152.                       <div align="center"><%=sub_mail%> </div>
  153.                     </td>
  154.                   </tr>
  155.                   <tr> 
  156.                     <td width="26%" height="12"> 
  157.                       <div align="right">付款方式：</div>
  158.                     </td>
  159.                     <td width="74%" height="25"> 
  160.                       <div align="center"><%=qian%> </div>
  161.                     </td>
  162.                   </tr>
  163.                   <tr>
  164.                     <td width="26%" height="12">
  165.                       <div align="right">备注：</div>
  166.                     </td>
  167.                     <td width="74%" height="25"> 
  168.                       <div align="center"><%=other%></div>
  169.                     </td>
  170.                   </tr>
  171.                   <tr> 
  172.                     <td colspan="2" height="21"> 
  173.                       <table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
  174.                         <tr> 
  175.                           <td> 
  176.                             <p style="word-spacing: 2; line-height: 150%; margin-top: 4; margin-bottom: 6"> 
  177.                               <font color="#FF9900">&nbsp;&nbsp;1.谢谢您在本站购物，如果您选择送货上门服务，请您放心，我们的工作人员会很快将商品送到府上。<br>
  178.                               &nbsp;&nbsp;2.如果您选择银行转帐方式，请您尽快转帐，并在转帐成功后马上给我们打电话或来Email确认，最快只要1小时就给您发货！</font></td>
  179.                         </tr>
  180.                       </table>
  181.                     </td>
  182.                   </tr>
  183.                 </table>
  184.                   </center>
  185.               </div>
  186.                 <div align="center"><a href="javascript:history.go(-1)"><<返回修改收货人信息</a><br>
  187.                 </div>
  188.                 <table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
  189.                   <tr> 
  190.                     <td valign="middle"><div align="center"><img src="img/pics/seperator.gif" width="359" height="1"></div></td>
  191.                   </tr>
  192.                 </table></td>
  193.             </tr>
  194.           </table> </td>
  195.         <%}
  196. }
  197. mdb.Close();%>
  198.       </tr>
  199.       
  200.     </table>