網上書店在線系統設計畢業論文-資料下載頁

　　

【正文】 om book where bookname like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiageamp。 and anclassid=amp。anclassid,conn,1,1case 2 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookauthor like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiageamp。 and anclassid=amp。anclassid,conn,1,1case 3 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookpublisher like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiageamp。 and anclassid=amp。anclassid,conn,1,1case 4 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,isbn,bookdate from book where isbn=39。amp。searchkeyamp。39。 and huiyuanjiaamp。jiageamp。 and anclassid=amp。anclassid,conn,1,1end selectelse3839。分類為空。select case actioncase 1 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookname like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiage,conn,1,1case 2 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookauthor like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiage,conn,1,1case 3 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookpublisher like 39。%amp。searchkeyamp。%39。 and huiyuanjiaamp。jiage,conn,1,1case 4 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,isbn,bookdate from book where isbn=39。amp。searchkeyamp。39。 and huiyuanjiaamp。jiage,conn,1,1end selectend ifend if if 0 then39 數據庫中無數據end if if And then p align=39。center39。 沒有查詢到您需要的圖書！/p else totalPut= if currentpage1 then currentpage=1 end if if (currentpage1)*MaxPerPagetotalput then if (totalPut mod MaxPerPage)=0 then currentpage= totalPut \ MaxPerPage else currentpage= totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showContent showpage totalput,MaxPerPage, else if (currentPage1)*MaxPerPagetotalPut then (currentPage1)*MaxPerPage dim bookmark bookmark=40 showContent showpage totalput,MaxPerPage, else currentPage=1 showContent showpage totalput,MaxPerPage, end if end if end if sub showContent dim i i=0%table width=776 border=0 align=center cellpadding=2 cellspacing=1 bgcolor=A4C3E6 tr td bgcolor=5F95D3div align=centerfont color=FFFFFF圖書名稱/font/div/td td bgcolor=5F95D3div align=centerfont color=FFFFFF作 者/font/div/td td bgcolor=5F95D3div align=centerfont color=FFFFFF出版社/font/div/td td bgcolor=5F95D3div align=centerfont color=FFFFFF出版日期/font/div/td td bgcolor=5F95D3div align=centerfont 41color=FFFFFF市場價/font/div div align=center/div/td td bgcolor=5F95D3div align=centerfont color=FFFFFF會員價/font/div/td td bgcolor=5F95D3div align=centerfont color=FFFFFF/font/div/td /tr %do while not % tr %Dim num1 39。判斷數字奇偶num1 = Num1+1If num1 Mod 2 = 0 Then% td bgcolor=FFFFFF style=paddingleft:6px% a href=?id=amp。trim(rs(bookid))amp。 target=_blankamp。trim(rs(bookname))amp。/a%/td td bgcolor=FFFFFFdiv align=center%=trim(rs(bookauthor))%/div/td td bgcolor=FFFFFFdiv align=center%=trim(rs(bookpublisher))%/div/td td bgcolor=FFFFFFdiv align=center%=trim(rs(bookdate))%/div/td td bgcolor=FFFFFFdiv align=center%=formatnumber(rs(shichangjia),2)amp。元%/div div align=center/div/td td bgcolor=FFFFFFdiv align=center%=font color=FF6600amp。formatnumber(rs(huiyuanjia),2)amp。元/font%/div/td td bgcolor=FFFFFFdiv align=center 42 % a href= onClick=javascript:(39。?id=amp。rs(bookid)amp。39。,39。39。,39。width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes39。)。return false。img src=images/ width=60 height=18 border=0/a% /div/td %else% td bgcolor=F7FBFF style=paddingleft:6px% a href=?id=amp。trim(rs(bookid))amp。 target=_blankamp。trim(rs(bookname))amp。/a%/td td bgcolor=F7FBFFdiv align=center%=trim(rs(bookauthor))%/div/td td bgcolor=F7FBFFdiv align=center%=trim(rs(bookpublisher))%/div/td td bgcolor=F7FBFFdiv align=center%=trim(rs(bookdate))%/div/td td bgcolor=F7FBFFdiv align=center%=formatnumber(rs(shichangjia),2)amp。元%/div/td td bgcolor=F7FBFFdiv align=center%=font color=FF6600amp。formatnumber(rs(dazhe)*100,2)amp。%/font%/div/td td bgcolor=F7FBFFdiv align=center%=font color=FF6600amp。formatnumber(rs(huiyuanjia),2)amp。元/font%/div/td td bgcolor=F7FBFFdiv align=center % a href= onClick=javascript:(39。?id=amp。rs(bookid)amp。39。,39。39。,39。width=632,height=388,toolbar=no, status=no, menubar=no, 43resizable=yes, scrollbars=yes39。)。return false。img src=images/ width=60 height=18 border=0/a% /div/td %end if% /tr %i=i+1if i=MaxPerPage then Exit Do loop set rs=nothing%/table% End Sub Function showpage(totalnumber,maxperpage,filename) Dim n If totalnumber Mod maxperpage=0 Then n= totalnumber \ maxperpage Elsen= totalnumber \ maxperpage+1 End If form method=Post action=amp。filenameamp。?searchkey=amp。searchkeyamp。amp。action=amp。actionamp。amp。anclassid=amp。anclassidamp。amp。jiage=amp。jiageamp。 p align=39。center39。 class=39。contents39。 If CurrentPage2 Then 44 font class=39。contents39。首頁 上一頁/font Else a href=amp。filenameamp。?page=1amp。searchkey=amp。searchkeyamp。amp。action=amp。actionamp。amp。anclassid=amp。ancla