现在好好的,我觉得颜色表格都不好,我想调一下,结果总是乱码。这个是别人做的,可能有很多不对的地方帮忙清除一些垃圾,不胜感激!
<%@ LANGUAGE="VBSCRIPT" %>
<%
bm=request("class")
CurrPage=request("CurrPage")
DbPath = SERVER.MapPath("bookshop.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sql = "Select * From book Where childclass='"& bm &"' order by bookbm"
'rs.open sql,conn,1,1
rs.open sql,conn,adOpenkeyset,adlockoptimistic,adcmdtext
if rs.RecordCount<=0 then
   response.write "Êý¾Ý¿âûÓзûºÏÌõ¼þµÄÊý¾Ý"
   response.end
else    
   i=0
   rs.PageSize=15
end if   
PageCount=clng(rs.PageCount)
if CurrPage>PageCount then
   CurrPage=PageCount
end if
if CurrPage<=0 or CurrPage="" then
      CurrPage=1
end if
BookNum=rs.RecordCount      
rs.absolutePage = CurrPage
%>
²úÆ·Áбí