www.gusucode.com > 水族产品用品经营类企业网站asp源代码程序 > sort1.asp
<!--#INCLUDE VIRTUAL="comm.asp"--> <% sort1=request.QueryString("sort1") if sort1="" then sort1=1 if mycheckchar(sort1,"0123456789")="#nosafe#" then response.Redirect("error.asp?p=sort1非纯数字") Set conn = Server.CreateObject("ADODB.Connection") conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/db/db.mdb") Set rs = Server.CreateObject("ADODB.Recordset") sql="select * from content where sort1=" & sort1 & " and sort_txt=false ORDER BY ID DESC" rs.open sql,conn,1,2 Set rs2 = Server.CreateObject("ADODB.Recordset") sql2="select * from content where sort1=" & sort1 & " and sort2=0 and sort_txt=true ORDER BY ID DESC" rs2.open sql2,conn,1,2 if not rs2.eof then myimage=rs2("image") mytitle=rs2("title") mytext=rs2("text") end if if rs.eof then response.Redirect("null.asp") page1=cint(request("page"))'要求显示的页数 if page1=0 then page1=1 rows=9 '每页显示记录数 allcount=rs.recordcount '记录总数 '变量page2为最后得到的页数 if allcount/rows=int(allcount/rows) then page2=allcount/rows else page2=int(allcount/rows)+1 end if '判断是否超出最大页数 if page1>page2 then page1=page2 '移动指针到指定位置 if not rs.eof then rs.move (page1-1)*rows %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link href="/css.css" rel="stylesheet" type="text/css"> <script language="JavaScript" type="text/JavaScript" src="comm.js"></script> <script language="JavaScript" type="text/JavaScript"> function dspl(sortid) { eval("tmp_dsp=sort"+sortid+".style.display"); if(tmp_dsp=="none"){ eval("sort"+sortid+".style.display=''"); eval("img"+sortid+".src='image/class2.gif'"); }else{ eval("sort"+sortid+".style.display='none'"); eval("img"+sortid+".src='image/class1.gif'"); } }</script> <title>三木佳水族用品有限公司</title> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table width="945" border="0" cellpadding="0" cellspacing="0"> <tr> <td rowspan="3" align="center" valign="top" class="ww8"><img src="image/logo.jpg" width="191" height="167"><table width="215" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="65" align="center" valign="bottom"><img src="image/index_06.gif" width="205" height="55"></td> </tr> <tr> <td align="center" background="image/bg3.jpg"> <table width="80%" height="8" border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> </tr> </table><script language="JavaScript" type="text/JavaScript" src="sort.js"></script> <script language="JavaScript" type="text/JavaScript">dspl(<%=rs("sort1") %>); </script></td> </tr> </table></td> <td width="730" align="center" valign="top" background="image/bg2.gif"><!--#INCLUDE VIRTUAL="top.asp"--> <img src="image/tb.gif" width="730" height="21"> <table width="680" height="173" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="260" rowspan="2"><img src="<%=myimage %>" width="240" height="180" border="0"></td> <td height="23" colspan="2" align="center" valign="middle" background="image/dx.gif" class="w8"><strong><%=mytitle %></strong></td> </tr> <tr> <td width="35" height="150"> </td> <td width="385" align="left" valign="middle" class="ww8"><%=mytext %></td> </tr> </table> <table width="80%" height="50" border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> </tr> </table> <table width="680" border="0" cellspacing="20" cellpadding="0"> <tr> <td><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="center"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="right"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> </tr> <tr> <td><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="center"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="right"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> </tr> <tr> <td><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="center"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> <td align="right"><% if not rs.eof then response.Write("<table width='180' border='0' cellspacing='1' cellpadding='0'><tr><td><a href='text.asp?id=" & rs("id") & "' target='_blank'><img src='" & rs("image") & "' width='180' height='135' border='0'></a></td></tr><tr><td height='20' align='center' bgcolor='dbdbdb' class='ww8'><a href='text.asp?id=" & rs("id") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>") rs.movenext end if %></td> </tr> </table> </td> </tr> <tr> <td align="center" valign="top" background="image/bg2.gif"> </td> </tr> <tr> <td height="21" align="center" valign="bottom" background="image/bg2.gif"><table width="680" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center"><input name="page1" type="hidden" id="page1" value="<%=page1 %>"> <input name="page2" type="hidden" id="page2" value="<%=page2 %>"> <a href="sort1.asp?page=1&sort1=<%=sort1 %>"><img src="/image/first.gif" width="7" height="6" border="0" align="middle"></a> <script language="JavaScript" type="text/JavaScript"> mypage1=page1.value; mypage2=page2.value; if(mypage1!=1){document.write("<a href='sort1.asp?page="+(mypage1-1)+"&sort1=<%=sort1 %>'><img src='/image/back.gif' width='6' height='6' border='0' align='middle'></a> ");} if(mypage2<11){ for(i=1;i<=mypage2;i++){ if(i==mypage1){ document.write("<span class='page_curpage'>"+i+"</span> "); }else{ document.write("<a href='sort1.asp?page="+i+"&sort1=<%=sort1 %>' class='page_num'>"+i+"</a> "); } } }else{ if(mypage1<6){ for(i=1;i<11;i++){ if(i==mypage1){ document.write("<span class='page_curpage'>"+i+"</span> "); }else{ document.write("<a href='sort1.asp?page="+i+"&sort1=<%=sort1 %>' class='page_num'>"+i+"</a> "); } } document.write("..."); } if(mypage1>mypage2-5){ document.write("..."); for(i=mypage2-9;i<=mypage2;i++){ if(i==mypage1){ document.write("<span class='page_curpage'>"+i+"</span> "); }else{ document.write("<a href='sort1.asp?page="+i+"&sort1=<%=sort1 %>' class='page_num'>"+i+"</a> "); } } } if(mypage1>=6 && mypage1<=mypage2-5){ document.write("..."); for(i=mypage1-4;i<=mypage1-1+6;i++){ if(i==mypage1){ document.write("<span class='page_curpage'>"+i+"</span> "); }else{ document.write("<a href='sort1.asp?page="+i+"&sort1=<%=sort1 %>' class='page_num'>"+i+"</a> "); } } document.write("..."); } } if(mypage1!=mypage2){document.write(" <a href='sort1.asp?page="+(mypage1-1+2)+"&sort1=<%=sort1 %>'><img src='/image/next.gif' width='6' height='6' border='0' align='middle'></a>");} </script> <a href="sort1.asp?page=<%=page2 %>&sort1=<%=sort1 %>"><img src="/image/last.gif" width="7" height="6" border="0" align="middle"></a></td> </tr> </table><img src="image/db.gif" width="730" height="21"></td> </tr> </table> <table width="80%" height="2" border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> </tr> </table> <!--#INCLUDE VIRTUAL="down.asp"--> </body> </html>