【正文】 tr/tabletable width=776 border=0 align=center cellpadding=1 cellspacing=1trtd bgcolor=DEE7F7 style=paddingleft:6px%if searchkey= then 請您輸入查詢關(guān)鍵字 else 您查詢的關(guān)健字是：font color=redamp。searchkeyamp。/fontend if%/td/tr/table%39。開始分頁Const MaxPerPage=22dim totalPutdim CurrentPage dim TotalPages dim jdim sqlif Not isempty(request(page)) then currentPage=Cint(request(page))elsecurrentPage=1end ifset rs=()if jiage= then 39。普通查詢select case action case 1 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdatefrom book where bookname like 39。%amp。searchkeyamp。%39。 ,conn,1,1case 2 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookauthor like 39。%amp。searchkeyamp。%39。 ,conn,1,1case 3 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from book where bookpublisher like 39。%amp。searchkeyamp。%39。 ,conn,1,1case 4 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,isbn,book date from book where isbn=39。amp。searchkeyamp。39。 ,conn,1,1end select else39。高級查詢if anclassid0 then 39。判斷查詢分類,分類不為空。select case action case 1 select bookid,bookname,bookauthor,bookpublisher,shichangjia,huiyuanjia,dazhe,bookdate from 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,bookdatefrom 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,book date from book where isbn=39。amp。searchkeyamp。39。 and huiyuanjiaamp。jiageamp。 and anclassid=amp。anclassid,conn,1,1end select else39。分類為空。select case action case 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,book date from book where isbn=39。amp。searchkeyamp。39。 and huiyuanjiaamp。jiage,conn,1,1end selectend ifend ifif 0 then 數(shù)據(jù)庫中無數(shù)據(jù)end ifif And then p align=39。center39。 沒有查詢到您需要的圖書！/pelsetotalPut=if currentpage1 then currentpage=1end ifif (currentpage1)*MaxPerPagetotalput then if (totalPut mod MaxPerPage)=0 thencurrentpage= totalPut \ MaxPerPage elsecurrentpage= totalPut \ MaxPerPage + 1end if end ifif currentPage=1 then showContentshowpage totalput,MaxPerPage,elseif (currentPage1)*MaxPerPagetotalPut then (currentPage1)*MaxPerPagedim bookmark bookmark= showContentshowpage totalput,MaxPerPage,elsecurrentPage=1showContentshowpage totalput,MaxPerPage,end if end ifend ifsub showContent dim ii=0%table width=776 border=0 align=center cellpadding=2 cellspacing=1bgcolor=A4C3E6trtd bgcolor=5F95D3div align=centerfont color=FFFFFF圖書名稱/font/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF 作 者/font/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF 出版社 /font/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF出版日期/font/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF 市場價 /font/divdiv align=center/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF 會員價 /font/div/tdtd bgcolor=5F95D3div align=centerfont color=FFFFFF/font/div/td/tr%do while not %tr%Dim num1 39。判斷數(shù)字奇偶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%/tdtd bgcolor=FFFFFFdiv align=center%=trim(rs(bookauthor))%/div/tdtd bgcolor=FFFFFFdiv align=center%=trim(rs(bookpublisher))%/div/tdtd bgcolor=FFFFFFdiv align=center%=trim(rs(bookdate))%/div/tdtd bgcolor=FFFFFFdiv align=center%=formatnumber(rs(shichangjia),2)amp。元%/divdiv align=center/div/tdtd bgcolor=FFFFFF