www.gusucode.com > 水族产品用品经营类企业网站asp源代码程序 > sort.asp
<!--#INCLUDE VIRTUAL="comm.asp"-->
<%
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 sort2=0 and sort_txt=true ORDER BY ID DESC"
rs.open sql,conn,1,2
if rs.eof then response.Redirect("null.asp")
page1=cint(request("page"))'要求显示的页数
if page1=0 then page1=1
rows=15 '每页显示记录数
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></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">
</td>
</tr>
<tr>
<td align="center" valign="middle" background="image/bg2.gif"><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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' 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='sort1.asp?sort1=" & rs("sort1") & "' target='_blank'>" & rs("title") & "</a></td></tr></table>")
rs.movenext
end if
%></td>
</tr>
</table></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" class="ww8"><input name="page1" type="hidden" id="page1" value="<%=page1 %>">
<input name="page2" type="hidden" id="page2" value="<%=page2 %>">
<a href="sort.asp?page=1"><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='sort.asp?page="+(mypage1-1)+"'><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='sort.asp?page="+i+"' 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='sort.asp?page="+i+"' 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='sort.asp?page="+i+"' 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='sort.asp?page="+i+"' class='page_num'>"+i+"</a> ");
}
}
document.write("...");
}
}
if(mypage1!=mypage2){document.write(" <a href='sort.asp?page="+(mypage1-1+2)+"'><img src='/image/next.gif' width='6' height='6' border='0' align='middle'></a>");}
</script>
<a href="sort.asp?page=<%=page2 %>"><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>