ASP產(chǎn)品展示界面網(wǎng)頁(yè)代碼

1、ASP網(wǎng)網(wǎng)頁(yè)設(shè)計(jì)計(jì)代碼之之產(chǎn)品展展示界面面TOC o 1-3 h z u HYPERLINK l _Toc303931485 1.創(chuàng)建建一個(gè)ppro11.assp PAGEREF _Toc303931485 h 1 HYPERLINK l _Toc303931486 2.創(chuàng)建建產(chǎn)品詳詳細(xì)展示示界面pprosshoww.assp PAGEREF _Toc303931486 h 4 HYPERLINK l _Toc303931487 3.創(chuàng)建建連接數(shù)數(shù)據(jù)庫(kù)的的文件cconnn.assp PAGEREF _Toc303931487 h 7 HYPERLINK l _Toc303931488 4.創(chuàng)建

2、建數(shù)據(jù)庫(kù)庫(kù)Datta.MMdb PAGEREF _Toc303931488 h 88親愛(ài)的讀讀友們，下面的的代碼是是我平常常工作時(shí)時(shí)會(huì)做到到的代碼碼，所謂謂好東西西大家一一起分享享，希望望你們看看了能夠夠順利的的做出來(lái)來(lái)哦最初初一定要要新建一一個(gè)文件件夾，無(wú)無(wú)論放在在哪里都都可以，路徑是是虛擬路路徑。但但是一定定要吧下下面幾個(gè)個(gè)創(chuàng)建的的文件放放在同一一個(gè)文件件夾里面面。1.創(chuàng)建建一個(gè)ppro11.assp添加以下下代碼，這里我我已經(jīng)簡(jiǎn)簡(jiǎn)化成最最簡(jiǎn)化了了。所以以基本不不用再繼繼續(xù)刪減減了。無(wú)標(biāo)題題文檔 % Biigcllasssnamme=RRequuestt(BBigcclasssnaame)

3、 Smmalllclaassnnamee=Reequeest(Smmalllclaassnnamee)seet rrs=sservver.creeateeobjjectt(aadoddb.rrecoordsset)iff Reequeest(Biigcllasssnamme)= thhenssql=seelecct ttop 7000 * frrom prooducct oordeer bby pprodductt_IDDeend ifiif RRequuestt(BBigcclasssnaame) andd reequeest(smmalllclaassaanmee)=tthennssql=

4、seelecct * frrom prooducct wwherre bbigcclasssnaame=&Biggclaassnnamee& orrderr byy prroduuct_ID endd iffiif RRequuestt(BBigcclasssnaame) andd reequeest(smmalllclaassnnamee) thhensqll=sseleect * ffromm prroduuct wheere biggclaassnnamee=&Biigcllasssnamme& aand Smaallcclasssnaame =&smmalllclaassnnamee&

5、ordder by prooducct_IID ddesccend ifrs.oopenn sqql,cconnn,1,1if rrs.eeof or rs.boff thhenrespponsse.wwritte 暫時(shí)沒(méi)沒(méi)有產(chǎn)品品記錄！end ifif rrequuestt(ppagee)= theenpagee=1elseepagee=ciint(reqquesst(pagge)end ifrs.ppageesizze=112rs.aabsooluttepaage=paggeurl=Prro1.aspp?BiigCllasssNamme=&BiigCllasssNamme&SmmalllC

6、laassNNamee=&SmaallCClasssNaame&ppagee=% &nnbspp;&nnbspp;&nnbspp;&nnbspp;&nnbspp; a hhreff=pprosshoww.assp?iid= ttargget=_bblannkimmg ssrc= widdth=1550 heiightt=1150 bbordder=0 / %if ii mood 44=0 theenrespponsse.wwritte( )end ifrs.mmoveenexxtif rrs.eeof theen eexitt foornextt% 1 theen% a hhreff=首頁(yè)頁(yè)&

7、nnbspp;&nnbspp;aa hrref=上一頁(yè)頁(yè)&nnbspp;&nnbspp; %iff paage a hhreff=下一一頁(yè)&nbssp;&nbssp;a hhreff=尾頁(yè)頁(yè) &nbssp;當(dāng)當(dāng)前第/頁(yè)頁(yè) %sub ShoowCllasssGuiide()ressponnse.wriite &nbssp;產(chǎn)產(chǎn)品&nbssp;&;>t;if BiggClaassNNamee= annd SSmalllCllasssNamme= tthennreespoonsee.wrritee &nbssp;所所有產(chǎn)品品elsseiff BiigCllasssNamme theenrresp

8、ponsse.wwritte &nbbsp; & BBigCClasssNaame & &nnbspp;&ggt;&;&nbbsp;iif SSmalllCllasssNamme theenressponnse.wriite & SSmalllCllasssNamme & eelseeressponnse.wriite 所有有小類(lèi)eend ifennd iifendd iffend subb%sub ShoowArrticcleTTotaal()dimm sqqlTootalldimm rssTottalsqllTottal=seelecct CCounnt(*) ffromm Prroduu

9、ct wheere Passsedd=Trrue if BiggClaassNNamee tthennsqqlTootall=sqqlTootall & aand BiggClaassNNamee= & BiggClaassNNamee & iff SmmalllClaassNNamee tthennssqlTTotaal=ssqlTTotaal & andd SmmalllClaassNNamee= & SmaallCClasssNaame & ennd iifelsseiff SppeciialNNamee tthennssqlTTotaal=ssqlTTotaal & andd Sppe

10、ciialNNamee= & SpeeciaalNaame & ennd iifendd iffSett rssTottal= Seerveer.CCreaateOObjeect(ADDODBB.Reecorrdseet)rsTTotaal.oopenn sqqlTootall,coonn,1,11if rsTTotaal.eeof andd rssTottal.boff thhentootallPutt=0reespoonsee.wrritee 共共有 00 個(gè)產(chǎn)產(chǎn)品elssetootallPutt=rssTottal(0)reespoonsee.Wrritee 共共有 & tottalPP

11、ut & 個(gè)產(chǎn)產(chǎn)品endd iffrsTTotaal.cclossesett rssTottal=notthinngend subb %2.創(chuàng)建建產(chǎn)品詳詳細(xì)展示示界面pprosshoww.assp在prooshoow.aasp界界面添加加如下代代碼產(chǎn)品詳詳細(xì)信息息%ShowwSmaallCClasssTyype=ShoowSmmalllClaassTTypee_Arrticcledim idid=ttrimm(reequeest(idd)if iid= tthennressponnse.Reddireect(Prroduuct.aspp)end ifsql=seelecct * frrom P

12、rooducct wwherre iid= & id & Set rs= Seerveer.CCreaateOObjeect(ADDODBB.Reecorrdseet)rs.oopenn sqql,cconnn,1,3if rrs.bbof andd rss.eoof tthennressponnse.wriiteallertt(找找不到此此產(chǎn)品！); reespoonsee.wrriteejaavasscriipt:hisstorry.ggo(-1)elseers(Hiits)=rrs(Hitts)+1rs.upddateeif rs(hiits)=HittsOffHott thhenrss

13、(HHot)=TTrueerss.uppdatteendd iffBiggClaassNNamee=rss(BBigCClasssNaame)SmaallCClasssNaame=rs(SmmalllClaassNNamee)% %respponsse.wwritte &nbbsp; & rrs(BiggClaassNNamee) & &nnbspp;&ggt;&;&nbbsp;if rrs(SmaallCClasssNaame) & tthennressponnse.wriite & rrs(SmaallCClasssNaame) & &nbbsp;>t;&ggt;&nbssp;end ifrespponsse.wwritte rrs(Tittle)% immg ssrc= altt=11 borrderr=00 點(diǎn)點(diǎn)擊次數(shù)數(shù)：&nnbspp; 發(fā)發(fā)布時(shí)間間：&nbbsp;【打印印】&nbssp;【返回回】 3.創(chuàng)建建連接數(shù)數(shù)據(jù)庫(kù)的的文件cconnn.asspConnn.assp文件件的代碼碼如下4.創(chuàng)建建數(shù)據(jù)庫(kù)庫(kù)Datta.Mdb創(chuàng)建好