<%dim dada,dadaurl,xiao1,xiao2,xiao3,xiao1url,xiao2url,xiao3url,tx1,tx1url,tx2,tx2url,tx3,tx3url set rs=server.CreateObject("adodb.recordset") rs.open "select * from shop_gg",conn,1,1 dada=trim(rs("458")) dadaurl=trim(rs("458url")) xiao1=trim(rs("2541")) xiao1url=trim(rs("2541url")) xiao2=trim(rs("2542")) xiao2url=trim(rs("2542url")) xiao3=trim(rs("2543")) xiao3url=trim(rs("2543url")) tx1=trim(rs("1441")) tx1url=trim(rs("1441url")) tx2=trim(rs("1442")) tx2url=trim(rs("1442url")) tx3=trim(rs("1443")) tx3url=trim(rs("1443url")) rs.close set rs=nothing %> <%dim gg1,gg2,gg3,gg4,gg1url,gg2url,gg3url,gg4url set rs=server.CreateObject("adodb.recordset") rs.open "select * from shop_gg",conn,1,1 gg1=trim(rs("1601")) gg1url=trim(rs("1601url")) gg2=trim(rs("1602")) gg2url=trim(rs("1602url")) gg3=trim(rs("1603")) gg3url=trim(rs("1603url")) gg4=trim(rs("1604")) gg4url=trim(rs("1604url")) rs.close set rs=nothing %>
 
 
商品专题
<%set rs=server.createobject("adodb.recordset") rs.open "select * from zhuanti order by newsid desc",conn,1,1 if rs.recordcount=0 then %>
暂无商品专题
<% else rs.PageSize =20 '每页记录条数 iCount=rs.RecordCount '记录总数 iPageSize=rs.PageSize maxpage=rs.PageCount page=request("page") if Not IsNumeric(page) or page="" then page=1 else page=cint(page) end if if page<1 then page=1 elseif page>maxpage then page=maxpage end if rs.AbsolutePage=Page if page=maxpage then x=iCount-(maxpage-1)*iPageSize else x=iPageSize end if %> <% For i=1 To x %> <% rs.movenext next %>
· > <%=replace(trim(rs("title")),"
","")%>
<%=year(rs("updatetime"))&"."&month(rs("updatetime"))&"."&day(rs("updatetime"))%>
<% call PageControl(iCount,maxpage,page,"border=0 align=center","

") end if rs.close set rs=nothing Sub PageControl(iCount,pagecount,page,table_style,font_style) '生成上一页下一页链接 Dim query, a, x, temp action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME") query = Split(Request.ServerVariables("QUERY_STRING"), "&") For Each x In query a = Split(x, "=") If StrComp(a(0), "page", vbTextCompare) <> 0 Then temp = temp & a(0) & "=" & a(1) & "&" End If Next Response.Write("" & vbCrLf ) Response.Write("" & vbCrLf ) Response.Write("" & vbCrLf ) Response.Write("" & vbCrLf ) Response.Write("
" & vbCrLf ) Response.Write(font_style & vbCrLf ) if page<=1 then Response.Write ("首页 " & vbCrLf) Response.Write ("上页 " & vbCrLf) else Response.Write("首页 " & vbCrLf) Response.Write("上页 " & vbCrLf) end if if page>=pagecount then Response.Write ("下页 " & vbCrLf) Response.Write ("尾页 " & vbCrLf) else Response.Write("下页 " & vbCrLf) Response.Write("尾页 " & vbCrLf) end if Response.Write(" 页次:" & page & "/" & pageCount & "页" & vbCrLf) Response.Write(" 共有" & iCount & "种商品" & vbCrLf) Response.Write(" 转到" & "" & "页" & vbCrLf & "") Response.Write("
" & vbCrLf ) End Sub %>