用JSP和数据库实现购物车的源程序

1、用jsp和数据库实现购物车的源程序作者：未知文章来源：www访问次数：次加入时间：2005-01-19用jsp和数据库实现购物车的源程序/shop_cart.jsp<% page contenttype=ntext/h匸ml;charset=gb2312h%><% page session=,truen %><% page language=f, java11 import = n java. sql. * n %><jsp:usebean id=nbka,f scope=npagen class=hshop.bka11 /><%strin

2、g product_type;string action;int product_id;int curpage;/商品类型if (request.getparameter (,tproduct_typen) =null) product_t ype= n al1n;elseproduct_type=request getparair.eter (nproduct_typef,);/页数和商品类型参数，可以在“继续购物”时返回到上次购物的页面if (request.getparameter (ncurpagef,) =null) curpage=l;elsecurpage=java.lang.i

3、nteger.parseint(request.getparameter(ncurpagen);/动作if (request.getparameter (naction,') =null) action=,lview,1;elseact ion=request. getparameter (f, act ion11);/商品编号if (request.getparameter(”product_id")=null) product_id=0;elseproduct_id=java lang.integer.parseint(request.getparameter(,prod

4、uct_id,1);int bbb;bbb=l;integer num = new integer(bbb);/商店编号session .putvalue (11 shop_idn, num);/顾客 usernamesession.putvalue(nguest_namen,nasp2001n);string guest_name= (string) session. getvalue (nguest_namen );integer shop_id=(integer)sessiongetvalue(nshop_idn);javalang.string sql;javasqlresultset

5、 rs;if (pareto(naddn)=0)sql= uselect cart_quantity from shop_cart where cart_shop_id=11+ shop_id + n and cart_guest_id=n + guest_name + n andcart_product_id=n+ product_id ;rs = bka.executequery(sql);if (rsnext ()int cart_quantity;cart_quantity=java.lang.integer.parseint(rs.getstring(ncart_quantityn)

6、 )+1;sql=nupdate shop_cart set cart_quantity=f, + cart_quantity + n where cart_shop_id=n + shop_id + n and cart_guest_id=n +guest_name + n and cart_product_id=f, + product_id ;rs = bka.executequery(sql);elsesql=ninsert into shop_cart (cart_shop_id, cart_guest_id, cart_product_id, cart_quantity) valu

7、es(n + shop_id + n z 11 + guest_name + ,t, h + product_id + n, 1) 11;rs = bka.executequery(sql);if (action. compareto (nclear11) =0)sql=ndelete from shop_cart where cart_shop_id=n + shop_id + n and cart_guest_id=n + guest_name + 11 n; rs = bka.executequery(sql);if (actioncompareto(ndeleten)=0)sql=nd

8、elete from shop_cart where cart_shop_id=n + shop_id + n and cart_guest_id=n + guest_name + 11 and cart_product_id=n +product_id ;rs = bka.executequery(sql);%><div align=ncentern><center><table border=non cellpadding=no11 cellspacing=n0n width=,610n height = n2n><tr>dxform

9、method=,lpost,t action=nshop_cart jsp?action=update&product_type=<$=product_type$>&curpage=<%=curpage%>n><table border=non cellpadding=no11 cellspacing=n0n width=,610n height = n2n><tr><td width=n122n height = n7nxdiv align=ncentern><center><table bo

10、rder=nln cellpadding=n2n cellspacing=n0n width=,100%n bordercolorlight = n#ffb4 68”bordercolordark=n#ffffff“ bgcolor=n#ffb468”><tr><td width=n 100%nxdivalign=ncenter f,><center><p>!i®</td></tr></table></center></div></td><td widt

11、h=,f122n height = n7,t style=f,border: medium11align=11 center11 xdiv align=hcentern><center><tableborder=,f 1n cellpadding=f,2,t cellspacing=,toh width=n100%,tbordercolorlight=n#ffb468nbordercolordark=n#ffffffn bgcolor=n#ffb468n><tr><td width=n 100%nxdiv align=ncenter,fxcent

12、er><p><ah re f = n s hop_li st.jsp?shop_id=<%=shop_id%>&product_type=<%=product_type%>& curpage=<%=curpage%>n>!%</a></td></tr></table></center></div></td><td width=n122n height = f,7n style=tfborder: medium”align=1

13、1 center11 xdiv align=hcentern><center><tableborder=n 111 cellpadding=f,2n cellspacing=non width=n100%nbordercolorlight=n#ffb468nbordercolordark=n#ffffffn bgcolor=n#ffb468”><tr><td width=n 100%nxdiv align=ncenter,fxcenter><p><ahref=,f javascript: document forms 0

14、. submit () 重新计费</曰></td></tr></table></center></div></td><td width=n122n height = f,7n style=tfborder: medium”align=11 centerf,xdiv align=,centeru><center><tableborder=n 111 cellpadding=f,2n cellspacing=n0n width=n100%nbordercolorlight = ,f #

15、ffb4 68”bordercolordark=n#ffffffn bgcolor=n#ffb468”><tr><td width=,f 100%mxdiv align= ncentern><center><p><a href=nshop_cart.jsp?action=clear&product_type=<%=product_type$>&curpage=c%=curpage%>”>清空购物车</ax/td></tr></table></center

16、></div></td><td width=,f122n height = n7,t style=f,border: medium11 align=,centern><div align=,centern><center><table border=n 111 cellpadding=f,2n cellspacing=n0n width=n100%n bordercolorlight =n#ffb468nbordercolordark=n#ffffffn bgcolor=n#ffb468n><tr><

17、;td width=n 100%nxdiv align=ncenter ,fxcenter><p><a href=nshop_order. aspn>确认购买</a></td></tr></table></center></div></td></tr><tr align=ncentern><td width=n61011 height = n 1n colspan=n5nxdiv align=hcenterfl><center><

18、;table border=n 1n cellpadding=,t211 cellspacing=h0n width=,100%nbgcolor=n#fdfee2n bordercolorlight = n#ffb4 68n bordercolordark=n#ffffffn height = n40n><tr>width=,f20%nheight = n8,t<tdwidth=n10%nheight" 8”<tdwidth=n10%nheight" 8”width=,f10%nheight = n8,t<tdwidth=n14%nhei

19、ght" 8”<tdwidth=n12%nheight" 8”width=,f17%nheight = n8,t<tdwidth=n17%nheight" 8”</tr><%align=flleft h> 商品名称 </td> align=nleft 市场价</td> align=nleft n> 优惠价 </td> align=flleft ”> 数量</td> align=nleft n>/jni+</td> align=nleft n> 定

20、金比例 </td> align=nleftn> 定金小计 </td> align=nleft n>|ffll|</td>sql = nselect shop_product product_id, shop_duct_name, shop_duct_price, shop_product. product_discount, shop_cart. cart_quant ity, shop_duct_first from shop_cart,shop_product where sh

21、op_cartcart_shop_id= n+ shop_id + n and shop_cart. cart_guest_id=if + guest_name + n and shop_cart. cart_product_id=shop_product. product_idn;rs = bka.executequery(sql);int total;int total_first;total=0;total_first=0;string product_name;int product_price;int product_discount;int product_first;int ca

22、rt_quantity;if (rsnext ()while (rs.next ()product_id=java lang.integer.parseint(rs.getstring(1); product_name=rs.getstring(2);product_price=javalanginteger.parselnt(rs getstring(3); product_discount=java.lang.integer.parselnt(rs.getstring(4); cart_quantity=java.lang.integer.parselnt(rs.getstring(5);

23、 product_first = javalanginteger.parselnt(rs getstring(6);%><tr><td width=n10%nheight=n1nalign=nleft nx%=product_name%></td><td width=n10%nheight=n1nalign=nleft nx%=product_price%></td>width=n10%nheight = f,l,talign=flleft n><%=product_discount %></td>

24、<td width=n10%nheight=nln product_id <%=cart_quant ity%>nx/td> <td width=n14%n height=nlnname=n<%= nt11 +align=nleftnxinput type=ntextf,%>n size=h3n value=halign=f,left n><%=product_discount *cart_quantity%x/td><td width=n12%nheight = ,f 1n align=nleft11 ><%=pr

25、oduct_first + n%n%>width=n17%n</td><td width=n17%nheight = n 1,t align=nleft nx%=product_f irst*product_discount*cart_quantity/100.0%></td> height = n 1,fxdiv align= ncenter11 xcenter><p><a href=nshop_cart.jsp?action=delete&product_id=<$=product_id%>”> d

26、elete</a></td></tr><%total=total+product_discount*cart_quantity;total_first=total_first+product_discount*cart_quantity*product_first/100;%><tr align=mcentern> width=n72%n colspan=n6n<p>i+</td><td width=n36%n colspan=n2n<%=total%x/td></tr>heigh

27、t=,t 16nxdivheight = n 16nxdivalign=hrightn>align=mleftn><tr align=mcentern> width=n72%n colspan=n6n<p>定金总计</td><td width=n36%n colspan=n2nheight=,t 16nxdivheight = n 16nxdivalign=hrightn>align=m left nx%=total_f irst%></td></tr><tr align=mcentern>

28、width=n72%n colspan=n6n<td width=n36%n colspan=n2n <%=total-total_f irst%x/td> </tr></table></center></div>height=,t 16nxdiv height = n 16nxdivalign=h right nxp></td> align=mleftn><%else%><p ajligwcent购物车为空！ </p><%>数据库操作部分程序用到两个表：1 sh

29、op_cart 表cart_id int购物车编号自动编号 cart_shop_id nvarchar 商店编号 cart_product_id nvarchar 商品编号 cart_quantity int 商品数量 临时存放购物车数据2 shop_product 表 product_id int商品编号自动编号 shop_id nvarchar 商店编号 product_name nvarchar 商品名称 product_bb nvarchar 商品介绍 product_price int 市场价 product_discount int 优恵价 product_img img 图片 product_status nvarchar 状态 product_first int 定金比例product_type nvanchar 商品类型 存放商品资料 使用bka. java制成的javabean : bka .class可以提供对数据库的操作。另外，需在控制面板的系统dsn中注册bka . dsn，从而可使jsp通过jdbc-odbc来调用sql数据库。在页面中调用javabean *基本上可采用以下方式：<% page language=f, java11 i