jsp购物车

来源:互联网 发布:centos 编译php5.6 编辑:程序博客网 时间:2024/05/01 11:02

package buyList;

 

class buyList{

public String name;

public int id;

public String price;

public String user_name;

 

增加购物车:

add1.jsp

<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%@page import="buyList.buyList"%>
<%@page import="java.util.*"%>
<html>

  <body>
   <%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection

("jdbc:sqlserver://localhost:1433;DatabaseName=book","sa", "11011");
  Statement stmt=con.createStatement();
int id=Integer.parseInt(request.getParameter("id"));
String name="";
String price="";
String sql="SELECT name,price FROM book where id="+id;
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
name=rs.getString("name");
price=rs.getString("price");
}
buyList myList=new buyList();
myList.name=name;
myList.id=id;
myList.price=price;
myList.user_name="";
myList.book_number=1;
boolean listFlag=true;
//读取购物车的信息
Vector shop=(Vector)session.getValue("shop");
if(shop==null){
//如果原购物车为空,则新建购物车
shop=new Vector();
}
else{
for(int i=0;i<shop.size();i++){
buyList list=(buyList)shop.elementAt(i);
if(list.id==myList.id){
list.book_number++;
shop.setElementAt(list,i);
listFlag=false;
}
}
}
if(listFlag)
shop.addElement(myList);
session.putValue("shop",shop);
rs.close();
 %>

<div align="center"><b><font size="4" color="#ff0033">成功放入购物车</font></b><br>
<a href="javascript:window.close()">关闭窗口</a>|
<a href="list.jsp?id=<%=id %>" target="_blank">查看购物车</a>
 </div>
  </body>
</html>

 

查看购物车:

list.jsp

<%@page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<%@page import="buyList.buyList"%>
<%@page import="java.util.*"%>
<jsp:include page="header.jsp"/>

</SCRIPT>

<html>
  <head>
    <title>查看购物车</title>     
  </head>
  <body>
当前位置:<a href="index.jsp">首页</a>&gt;&gt;查看购物车
    <%    
    Vector shop=(Vector)session.getValue("shop");
     %>

<table width="590" border="0" align=center>
<tr>
<td width="45%">你的购书情况为:</td>
<td width=55%>
<div align=center>(如果想删除商品,请将数值置零后刷新)</div>
</td>
</tr>
</table><br>
<form name="form1" method="post" action="edit.jsp"><div align="center">
</div><table width=590 border=0 align=center>
<tr bgcolor=#ff5d26>
<td width=54>序号
</td>
<td width=168><div align=center>书名</div>
</td>
<td width=128><div align=center>单价</div>

</td>
<td width=172><div align=center>数量</div>
</td>
</tr>
<%
for(int i=0;i<shop.size();i++){
buyList myList=(buyList)shop.elementAt(i);
 %>
<tr bgcolor=#ffd6c8><td width=54>
<div align="center"><%=i+1%></div>
</td>
<td width="169">
<div align="center">
<a href="javascript:detail(<%=myList.id%>)"><%=myList.name%></a></div>
</td>
<td width=128>
<div align="center">&yen;<%=myList.price%></div>
</td>
<td width=172>
<div align="center">
<input type="text" name="num<%=i%>" id="test" size=7 value="<%=myList.book_number%>">
</div></td></tr>
<%
} //}
%>
</table>

<table width=590 align=center>
<tr>
<td width=150>&nbsp;</td>
<td width=86>
<input type="submit" name="Submit" value="刷新">
</td>
<td width=101>&nbsp;</td>
<td width=285><a href="clear.jsp">清空购物车</a>|
<a href="index.jsp">继续购书</a>|<a href="check.jsp">结账</a>
</td></tr></table></form>
<script language="javascript">
function detail(a){
window.open("book.jsp?id="+a,"MyWindow","toolbar=no",left=150,top=280
width=500,height=230,menubar=no,systemMenu=no");
}
</script>
<jsp:include page="cr.jsp"/>
</body></html>

 

清空购物车

clear.jsp

 

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="buyList.buyList"%>
<%
Vector newshop=new Vector();
session.putValue("shop",newshop);
 %>
<html>
  <body>
    <p align="center"><b><font color=%ff0000 size=5>你的购物车已经清空,现在页面跳转中....
<%response.setHeader("refresh","1;url=list.jsp"); %>
  </body>
</html>

修改购物车:

edit.jsp

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page import="buyList.buyList" %>
<html>
  <body>
    <%
    Vector shop=(Vector)session.getValue("shop");
    Vector newshop=new Vector();
    for(int i=0;i<shop.size();i++){
    buyList myList=(buyList)shop.elementAt(i);
    String getNum=request.getParameter("num"+i);
    int newNum=Integer.parseInt(getNum);
    myList.book_number=newNum;
    if(newNum!=0) newshop.addElement(myList);
    }
    session.putValue("shop",shop);
     %>
<script language="javascript">
self.location="list.jsp";
</script>
  </body>
</html>