jsp_project_/store//store/WebRoot/OrderList

最新推荐文章于 2020-11-19 18:15:38 发布

goushaoping04

最新推荐文章于 2020-11-19 18:15:38 发布

阅读量563

点赞数

文章标签： jsp vector string file delete null

本文链接：https://blog.csdn.net/goushaoping04/article/details/1643544

版权

<%@ page language="java" import="java.util.*,conn.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>登陆</title>

    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">

a
{
font:Arial, Helvetica, sans-serif;
font-size:14px;
font-weight:bold;
color:#FF0000;
text-decoration:none
}
a:hover
{
font:Arial, Helvetica, sans-serif;
font-size:14px;
font-weight:bold;
color:#0000FF;
text-decoration:none
}
.STYLE1 {
font-family: "宋体";
font-size: 24px;
font-weight: bold;
}

</style>
</head>

<body onContextMenu="return false">
<table width="105%" height="130%" border="0" cellpadding="0" cellspacing="0" style="position:absolute; left:0; top:0" bgcolor="#ffffff">
<tr>
    <td height="112" colspan="2" align="left" valign="bottom"><img src="file:///D|/project_jsp/Work/Img/logo.jpg" width="180" height="103" /></td>
    <td width="67%" colspan="2" align="right"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="439" height="112">
        <param name="movie" value="file:///D|/project_jsp/Work/Img/webHeader.swf" />
        <param name="quality" value="high" />
        <embed src="file:///D|/project_jsp/Work/Img/webHeader.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="439" height="112"></embed>
    </object></td>
</tr>
<tr>
    <td height="13" colspan="4" bgcolor="#CC3300"> </td>
</tr>
<tr>
    <td height="100%" colspan="4" align="center" valign="top" >
    <%
       String totalAmount ="0";
      if(session.getAttribute("UserName")==null)
      {
        response.sendRedirect("ReLogin.jsp");
      }

      String id ="";
      if(request.getParameter("orderID")!=null)
      {
         id = (String) request.getParameter("orderID");
         session.setAttribute("orderID",id);
       }else
       {
          id = (String)session.getAttribute("orderID");
       }

    out.print("<table align='center' width='80%' border='0' cellpadding='0' cellspacing='0'>");
    String str= "";
    ConnectionDatabase con =new ConnectionDatabase();
    if(request.getParameter("PID")!=null)
    {
       con.updateBase("delete ordPID where PID='"+request.getParameter("PID").toString().trim()+"'");
    }

   if(!con.isNull("Select * from ordPID where OrderID='"+id+"'"))
   {
      con.updateBase("delete CustomerOrder where orderID='"+id+"'");
      response.sendRedirect("Order.jsp");
   }else
   {
    Vector vv = con.getQueryDate("select PID from ordPID where OrderID='"+id+"'");
    for(int i = 0; i < vv.size();i++)
    {
       if(i == 0)
       {
          str+="'"+((Vector)vv.get(i)).get(0).toString().trim()+"'";
       }else
       {
          str+=",'"+((Vector)vv.get(i)).get(0).toString().trim()+"'";
       }
    }
    if(str==null || str.trim().length()==0)
    {
        con.updateBase("delete CustomerOrder where OrderID='"+id+"'");
        response.sendRedirect("Order.jsp");
    }
    Vector content = con.getQueryDate("SELECT PID,PName,PKid,Ptype,Victalor,Price FROM production where PID in("+str+")");
       out.print("<tr>");
    out.print("<td width='10' height='28'><img src='file:///D|/project_jsp/Work/Img/left.gif' width='10' height='28' /></td>");

    out.print("<td bgcolor='#ddddcc'>编号");
    out.print("</td>");

    out.print("<td bgcolor='#ddddcc'>名称");
    out.print("</td>");

    out.print("<td bgcolor='#ddddcc'>类别");
    out.print("</td>");

    out.print("<td bgcolor='#ddddcc'>款号");
    out.print("</td>");

    out.print("<td bgcolor='#ddddcc'>厂家");
    out.print("</td>");

    out.print("<td bgcolor='#ddddcc'>金额");
    out.print("</td>");

    out.print("<td width='10' height='28'><img src='file:///D|/project_jsp/Work/Img/right.gif' width='10' height='28' /></td>");
    out.print("</tr>");

    int ii=0;
    String strc="";
    for(int i = 0; i < content.size();i++){
         if(ii == 0)
          {
             strc = "#FFFFCC";
             ii++;
          }else
          {
             strc = "#99FFFF";
             ii--;
          }
          out.print("<tr bgcolor='"+strc+"'>");
          out.print("<td width='10' height='30' bgcolor='#ddddcc'></td>");
          Vector v = (Vector)content.get(i);
          for(int j = 0;j < v.size();j++)
          {
                out.print("<td>"+v.get(j));
                out.print("</td>");
          }
          try{
             totalAmount = String.valueOf(Double.parseDouble(totalAmount.trim())+Double.parseDouble(v.get(5).toString().trim()));
          }catch(Exception ee)
          {
          }
           out.print("<td width='10' height='30' bgcolor='#ddddcc'></td>");
           out.print("</tr>");
      }

       out.print("<tr>");

       out.print("<td width='10' height='10'><img src='file:///D|/project_jsp/Work/Img/bleft.gif' width='10' height='10' /></td>");
       out.print("<td colspan='6' bgcolor='#ddddcc'></td>");
       out.print("<td width='10' height='10'><img src='file:///D|/project_jsp/Work/Img/bright.gif' width='10' height='10' /></td>");
       out.print("</tr>");
       out.print("</table>");
       out.print("<br>");
       out.print("<br><p class='STYLE1'>");
       out.print("共计金额:"+totalAmount+"元</p>");


        out.print("<br>");
          out.print("<a href='Order.jsp'>返回</a>");
          out.print("    ");
         }
    %>
    </td>
</tr>
<tr>
   <td height="13" colspan="4" bgcolor="#CC3300"> </td>
</tr>
<tr ></tr>
</table>
</body>
</html>

goushaoping04

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp_project_/store//store/WebRoot/OrderList

String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%> "> 登陆
复制链接

扫一扫