orderview.jsp

工程案例基于JAVE的WEB网上书店源代码示例。

      ////
      double price;                       //价格
      String bookName=new String();       //图书名
      String bookAuthor=new String();     //作者
      String publisher=new String();      //出版社
  
  
      try
      {
         ////查询用户信息
         sql="SELECT * FROM client WHERE logName='"+logName+"'";
         Connection con  = DriverManager.getConnection("jdbc:odbc:bookStore");
         Statement  stmt = con.createStatement();
         ResultSet  rs   = stmt.executeQuery(sql);
         
         while(rs.next())
         {
           grade=rs.getInt("grade");
           if(grade>=1 && grade<=2)
             rate=0.9;
           else if(grade>=3 && grade<=4)
             rate=0.8;
           else if(grade>=5 && grade<=6)
             rate=0.75;
         }    
         rs.close();

        if(pid.compareTo("-1")==0)                     //订单查询
        {
          shop=(Vector)session.getValue("shop");       //获得session中的shop信息
        }
        else                                           //向购物车中添加新书
        {
          shop=(Vector)session.getValue("shop");       //获得session中的shop信息

          sql="SELECT * FROM book WHERE bookID='";
          sql=sql+pid;
          sql=sql+"'";
  
//        byte[] tempBytes=pid.getBytes("ISO8859-1");
//        pid=new String(tempBytes);    
     
        ////获得新购图书信息
          rs   = stmt.executeQuery(sql);
          while(rs.next())
          {
            bookName=rs.getString("bookName");
            bookAuthor=rs.getString("bookAuthor");
            price=rs.getDouble("bookPrice");       
            publisher=rs.getString("publisher");
            buyList myList=new buyList();
            boolean flag=false;   //是否已经定购过该书
            myList.bookName=bookName;
            myList.bookID=pid;
            myList.bookNum=1;
            myList.bookPrice=price;
            myList.publisher=publisher;         
         
            if(shop!=null)
            {
              for(int i=0;i<shop.size();i++)
              {
                buyList tempList=(buyList)shop.elementAt(i);
                int index=shop.indexOf(tempList);
                if(tempList.bookID.equals(myList.bookID))
                {              
                  tempList.bookNum++;
                  shop.setElementAt(tempList,index);
                  flag=true;
                  break;
                }
              }
            }
            else
              shop=new Vector();
        
            if(!flag)
            {
              shop.addElement(myList);
            }
            session.setAttribute("shop",shop);
          }
          rs.close(); 
        }

        if(shop.size()==0)  //购物车为空
        {
%>
<p align=center><font size=5 color=red>您的购物车为空，请先购物!!!</font>
<%      }       
%>      
<%    }
     
      catch(Exception e)
      {
         out.println(e.toString());
      }
%>  
        


        
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
  <TBODY>
  <TR>
    <TD vAlign=top>
      　</TD>
    </TR></TBODY></TABLE>
<TABLE height=1 cellSpacing=0 cellPadding=0 width=769 align=center border=3 bordercolor="#FFFFFF">
  <TBODY>
  <TR>
    <TD height=1 width="373" align=left colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      
      用户名：<font color=red size=4>&nbsp;&nbsp;&nbsp;<%=logName%></font></TD>
    <TD height=1 width="343" colspan="3">级别：&nbsp;&nbsp;&nbsp;<%=grade%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      
      可享受折扣：&nbsp;&nbsp; <%=rate%></TD></TR>
  <TR>
    <TD height=1 width="716" colspan="5">您本次已定购图书：(若想删除图书，可以将数量置零后单击修改)
      <hr>
    </TD>
  </TR>
  <TR>
    <TD height=1 width="129" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">书名</TD>
    <TD height=1 width="258" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">出版社</TD>
    <TD height=1 width="129" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">原价</TD>
    <TD height=1 width="165" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">实际价格</TD>
    <TD height=1 width="84" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">所购册数</TD>
  </TR>
  <form name="form1" method="post" action="modify.jsp?type=<%=1%>">
<%  for(int i=0;i<shop.size();i++)
    {
        buyList myList=(buyList)shop.elementAt(i);
%>
  <TR>
    <TD height=1 width="129" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF"><%=myList.bookName%></TD>
    <TD height=1 width="258" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF"><%=myList.publisher%></TD>
    <TD height=1 width="129" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF">￥ <%=myList.bookPrice%></TD>
    <TD height=1 width="165" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF"><%=myList.bookPrice*rate%></TD>
    <TD height=1 width="84" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF"><input type=text name="num<%=i%>" size="9" value=<%=myList.bookNum%>></TD>
  </TR>
<%  }
%>  
  <TR>
    <TD height=1 width="383" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF" colspan="2">　
      <input type=submit name=Submit value=" 修改" onclick="checkform(this)"> </a>
    </TD>
    <TD height=1 width="376" align="center" bordercolor="#3333CC" bgcolor="#FFFFFF" colspan="3">　
      <a href="modify.jsp?type=<%=2%>"><font color=blue>清空购物车</font></a> | <a href="main.jsp"><font color=blue> 继续购物</font> </a>  | <a href="submitOrder.jsp" type=submit><font color=blue> 生成订单</font> </a>
    </TD>
  </TR>
  </TBODY></TABLE>
  
<SCRIPT language=JavaScript src="JSLib.js" type=text/javascript>  
//确保输入的数字有效
 function checkform(Frm)
 {
    alert("dfasdfasd");
    var flag=true;
    String err="输入错误!!!";
    byte[] tempBytes=err.getBytes("ISO8859-1");
    err=new String(tempBytes);
<%  for(int num=0;num<shop.size();num++)
    {
       out.print("if(!isInt(Frm.num"+num+".value))"+"\r\n");
       out.print("{"+"\r\n");
       out.print("alert("+"图书数目输入有误!!!)"+"\r\n");
       out.print("Frm.num"+num+".focus();"+"\r\n");
       out.print("flag=false;"+"\r\n");
       out.print("}"+"\r\n");
    }
%>
   return flag;  
 }
</SCRIPT>
<%
  }
%>  
  
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
  <TBODY>
  <TR>
    <TD>
      <TABLE cellSpacing=1 cellPadding=0 width="100%" align=center 
      bgColor=#89bec6 border=0>
        <TBODY>
        <TR bgColor=#aacfd5>
          <TD style="PADDING-LEFT: 10px">　</TD>
          <TD style="PADDING-LEFT: 10px">　</TD>
          <TD style="PADDING-LEFT: 10px">　</TD>
          <TD style="PADDING-LEFT: 10px">　</TD>
          <TD style="PADDING-LEFT: 26px">　</TD></TR>
        </TBODY></TABLE>
      <DIV align=center></DIV></TD></TR>
  <TR>
    <TD height=6></TD></TR>
  </TBODY></TABLE>
<HR align=center width=776 color=#339999 SIZE=1>

<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
  <TBODY>
  <TR>
    <TD align=middle>版权所有&nbsp;2003-2004&nbsp;&copy;&nbsp;All rights MagicTeam reseverd</TD></TR></TBODY></TABLE>      
<DIV align=center></DIV></BODY></HTML>