΢ͻӦ
WEIXINGJI YU YINGYONG
2000Vol.19No.5P.31-32




ASPSessionϹϵͳеӦ
ֺ
ժ ҪASPǽ˵Ķ̬ҳƼSessionASP̼ռ൱صķͨϹϵͳһ棬Session Ӧá
ؼʣASP Session ҳ
1 Ϲϵͳ
ϹǵInternetӦʮŵĻ⡣һϹϵͳĻܰ
1ҳṩѡĹ࣬ûԼȤĹҳ
2ҳṩѡĸƷơۡ顢쳧ҡڵȣûѡС빺ťС鿴˻Ʒ๺ҳӡ
3鿴ҳгûѡƷܸѡĳƷȡѡеĳƷ
4빺򡣰ûѡƷ¼SessionС
5˻Ʒݡ
ASPActive Server PagesSessionĳһҳĹͬ󣬿¼ûڲͬҳѡƷ빺򡢹ҳ鿴ҳSessionһܺõӦá
2 Sessionڹҳ͹еӦ
ҳݱݱ񣬽ϸѡʽչʾݿڸƷΪֻгƷšơۡ顣С빺ť´˰ťʱִָз빺򡣷빺ڱҳѡƷȷ1ProductsУʹ
ProductsSplit Request ProductID壩壬壩
ʽSplitܰѡеƷŷַָ顣SplitProductsͳΪѡƷŵ1顣磺
Products01002壬Products11004壬Products21008
ȻԱ׷ӵһַܹProductListУ´룺

ProductListSessionProductList壩 仹ԭSession 
䣨ProductList壩
For I0 To UboundProducts
If LenProductList  0 Then
ProductList   ProductID   
ElseIf InStrProductListProductID 0 Then
ProductListProductList  壬  ProductID   
End If
Next
SessionProductList壩ProductList 佫׷ӺõPro
ductList洢SessionProductList壩

ַܹProductListŵûڸҳѡƷţ磺
ProductList2001䣬2006䣬1002䣬1004䣬1008
3 Sessionڲ鿴ҳеӦ
鿴ҳƵҪгûѡƷܸѡĳƷȡѡеĳƷͳƽΪгûѡƷ룺
1Ѵ洢SessionProductList壩ݻԭʹ
ProductListSessionProductList壩
2Ӷ󣬴ݿ⣬趨SQLʹExecuteִзݿĲ´룺

DbPathSERVERMapPathShopBagmdb壩
Set connServerCreateObjectADODBConnection壩 
connopen driverMicrosoft Access Driver mdb
dbq  DbPath
sqlSelectFrom Products Products
 ShopBagmdbݿ1ݱ
sqlsql  Where ProductID In   ProductList 
 壩
sqlsql  Order By ProductID
Set rs  connExecutesql

ڵconnExecute1Recordsetrs rsеݼ¼ǱѡеƷļ¼
3ݱչʾrsݼ¼ͷʽΪ
TR BGCOLOR00FFFF
TDȡTDTDƷţTDTDƷƣTDTDۣTDTDTDTDܼۣTDTDƷ飼TDTR
´гrsбѡеƷļ¼

While Not rsEOF
QuatityCIntRequestQߡ  rsProductID壩 
If Quatity  0 Then
QuatityCInt SessionrsProductID壩 
If Quatity  0 Then Quatity1
End If
SessionrsProductID壩Quatity
SumSumCDblrsPrice壩 Quatity

TR
TD AlignCenter
Input TypeCheckBox NameProductID Value
壼rsProductID壩 Checked
TD
TDrsProductID壩TD
TDrsProductName壩TD
TD AlignRightrsPrice壩TD
TDInput TypeText Name壼Qߡ  rsPro
ductID壩 ValueQuatity Size3TD
TD AlignRightCDblrsPrice壩QuatityTD
TDA HREFrsLink壩rsDescription壩 
ATD
TR

rsMoveNext
Wend

HTML벿ΪñгrsбѡƷļ¼ΪܸĳƷıʽû룬ϴı
TDInput TypeText Name壼Qߡ  rsProductID壩 ValueQuatity Size3TD
SessionrsProductID壩¼ĳƷϴASP򲿷֣
 
While Not rsEOF
QuatityCIntRequestQߡ  rsProductID壩 
If Quatity  0 Then
QuatityCIntSessionrsProductID壩 
If Quatity  0 Then Quatity1
End If
SessionrsProductID壩Quatity
rsMoveNext
Wend

SessionrsProductID壩Quatity ǽûȷ¼SessionrsProductID壩С
Ϊ˸ϸ˽ݣĲο1̡
ֺݹ㶫ʡҵѧУģ510520
ο
1٣Active Server Pages  Webݿ⣮ ʵ磬1999
2ڣϣƷ̬ҳ廪ѧ磬1999
3ֽأASPʵ񾭵䣮й磬1999
ոڣ20000210
