?? 0109.htm

?? JspServlet教程專欄對javaservlet講述的非常詳細
?? HTM
?? 第 1 頁 / 共 2 頁
字號:
12 下一頁
<html>

<head>
<title>新時代軟件教程:操作系統 主頁制作 服務器 設計軟件 網絡技術 編程語言 文字編輯</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋體}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1  {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
    <p align="center"><big><strong>用JSP和數據庫做的購物車的源程序</strong></big></p>

<div align="right">摘自《ChinaAsp》（文/asp2001）</div>

<p><span class=smallFont>
下面是我用JSP和數據庫做的購物車的源程序：<br>
<br>
注意：<br>
1、重新計費部分還沒有做好，大家自己動手吧！<br>
2、下一版本將用session做。<br>
<br>
//shop_cart.jsp<br>
<br>
&lt;%@ page contentType=&quot;text/html;charset=gb2312&quot;%&gt;<br>
&lt;%@ page session=&quot;true&quot; %&gt;<br>
&lt;%@ page language=&quot;java&quot; import=&quot;java.sql.*&quot; %&gt;<br>
&lt;jsp:useBean id=&quot;bka&quot; scope=&quot;page&quot; class=&quot;shop.bka&quot; /&gt;<br>
&lt;%<br>
<br>
String product_type;<br>
String action;<br>
int product_id;<br>
int curpage;<br>
<br>
//商品類型<br>
if (request.getParameter(&quot;product_type&quot;)==null){<br>
product_type=&quot;all&quot;;<br>
}else{<br>
product_type=request.getParameter(&quot;product_type&quot;);<br>
}<br>
<br>
//頁數和商品類型參數，可以在“繼續購物”時返回到上次購物的頁面<br>
if (request.getParameter(&quot;curpage&quot;)==null){<br>
curpage=1;<br>
}else{<br>
curpage=java.lang.Integer.parseInt(request.getParameter(&quot;curpage&quot;));<br>
}<br>
<br>
//動作<br>
if (request.getParameter(&quot;action&quot;)==null){<br>
action=&quot;view&quot;;<br>
}else{<br>
action=request.getParameter(&quot;action&quot;);<br>
}<br>
<br>
//商品編號<br>
if (request.getParameter(&quot;product_id&quot;)==null){<br>
product_id=0;<br>
}else{<br>
product_id=java.lang.Integer.parseInt(request.getParameter(&quot;product_id&quot;));<br>
}<br>
<br>
int bbb;<br>
bbb=1;<br>
<br>
Integer num = new Integer(bbb);<br>
<br>
//商店編號<br>
session.putValue(&quot;shop_id&quot;,num);<br>
//顧客username<br>
session.putValue(&quot;guest_name&quot;,&quot;asp2001&quot;);<br>
<br>
String guest_name=(String)session.getValue(&quot;guest_name&quot;);<br>
Integer shop_id=(Integer)session.getValue(&quot;shop_id&quot;);<br>
<br>
<br>
<br>
java.lang.String sql;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
java.sql.ResultSet rs;<br>
<br>
<br>
<br>
if (action.compareTo(&quot;add&quot;)==0) {<br>
<br>
sql=&quot;select cart_quantity from shop_cart where cart_shop_id=&quot; + shop_id + &quot; and cart_guest_id='&quot; + guest_name + &quot;' and cart_product_id=&quot; + product_id ;<br>
rs = bka.executeQuery(sql);<br>
if (rs.next()){<br>
int cart_quantity;<br>
cart_quantity=java.lang.Integer.parseInt(rs.getString(&quot;cart_quantity&quot;))+1;<br>
sql=&quot;update shop_cart set cart_quantity=&quot; + cart_quantity + &quot; where cart_shop_id=&quot; + shop_id + &quot; and cart_guest_id='&quot; + guest_name + &quot;' and cart_product_id=&quot; + product_id ;<br>
rs = bka.executeQuery(sql);}<br>
else<br>
{<br>
sql=&quot;insert into shop_cart (cart_shop_id,cart_guest_id,cart_product_id,cart_quantity) values ('&quot; + shop_id + &quot;','&quot; + guest_name + &quot;','&quot; + product_id + &quot;',1)&quot;;<br>
rs = bka.executeQuery(sql);<br>
}<br>
}<br>
<br>
if (action.compareTo(&quot;clear&quot;)==0) {<br>
sql=&quot;delete from shop_cart where cart_shop_id=&quot; + shop_id + &quot; and cart_guest_id='&quot; + guest_name + &quot;'&quot;;<br>
rs = bka.executeQuery(sql);<br>
}<br>
<br>
if (action.compareTo(&quot;delete&quot;)==0) { <br>
sql=&quot;delete from shop_cart where cart_shop_id=&quot; + shop_id + &quot; and cart_guest_id='&quot; + guest_name + &quot;' and cart_product_id=&quot; + product_id ;<br>
rs = bka.executeQuery(sql);<br>
}<br>
%&gt;<br>
&lt;div align=&quot;center&quot;&gt;&lt;center&gt;<br>
<br>
&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;610&quot; <br>
<br>
height=&quot;2&quot;&gt;<br>
&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&lt;td&gt;&lt;form method=&quot;POST&quot; <br>
<br>
action=&quot;shop_cart.jsp?action=update&amp;product_type=&lt;%=product_type%&gt;&amp;curp<br>
<br>
age=&lt;%=curpage%&gt;&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;610&quot; <br>
<br>
height=&quot;2&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;122&quot; height=&quot;7&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;table <br>
<br>
border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; bordercolorlight=&quot;#FFB468&quot; <br>
<br>
bordercolordark=&quot;#FFFFFF&quot; bgcolor=&quot;#FFB468&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;100%&quot;&gt;&lt;div <br>
<br>
align=&quot;center&quot;&gt;&lt;center&gt;&lt;p&gt;購物車&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/center&gt;&lt;/div&gt;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;122&quot; height=&quot;7&quot; style=&quot;border: medium&quot; <br>
<br>
align=&quot;center&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;table<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; <br>
<br>
bordercolorlight=&quot;#FFB468&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bordercolordark=&quot;#FFFFFF&quot; bgcolor=&quot;#FFB468&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;100%&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;p&gt;&lt;a <br>
<br>
href=&quot;shop_list.jsp?shop_id=&lt;%=shop_id%&gt;&amp;product_type=&lt;%=product_type%&gt;<br>
<br>
&amp;curpage=&lt;%=curpage%&gt;&quot;&gt;繼續購物&lt;/a&gt;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/center&gt;&lt;/div&gt;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;122&quot; height=&quot;7&quot; style=&quot;border: medium&quot; <br>
<br>
align=&quot;center&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;table<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; <br>
<br>
bordercolorlight=&quot;#FFB468&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bordercolordark=&quot;#FFFFFF&quot; bgcolor=&quot;#FFB468&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;100%&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;p&gt;&lt;a <br>
<br>
href=&quot;javascript: document.forms[0].submit()&quot;&gt;重新計費&lt;/a&gt;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/tr&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/table&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/center&gt;&lt;/div&gt;&lt;/td&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;td width=&quot;122&quot; height=&quot;7&quot; style=&quot;border: medium&quot; <br>
<br>
align=&quot;center&quot;&gt;&lt;div align=&quot;center&quot;&gt;&lt;center&gt;&lt;table<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; <br>
<br>
bordercolorlight=&quot;#FFB468&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bordercolordark=&quot;#FFFFFF&quot; bgcolor=&quot;#FFB468&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;tr&gt;<br>
12 下一頁
?? 文件大小 511 K
?? 上傳用戶 liuchuyuan
?? 所屬分類網絡
??? 相關標簽

#javaservlet #JspServlet #教程
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? 0109.htm

?? 快捷鍵說明
