www.gusucode.com > 书生图片管理Asp源码程序 > code/good.asp
<!--#include file="articleconn.asp"--> <!--#include file="home1.asp"--> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title><%=rs("homes")%>==><%=rs("home")%></title> <meta name="GENERATOR" content="Microsoft FrontPage 3.0"> <script language="javascript"> function popwin2(id,path) { window.open("openarticle.asp?id="+id+"&ppath="+path,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); } </script> <%'<link rel="stylesheet" type="text/css" href="css/style">%> <link rel="stylesheet" type="text/css" href="css/style.css"> <script language="JavaScript"> <!-- function checkinput() { if (document.search.keyword.value=="") { alert("请输入想查询的内容!"); document.search.keyword.focus(); return false; } return true; } --> </script> </head> <% dim rs MaxPerPage=rs("duo") dim totalPut dim CurrentPage dim TotalPages dim i,j dim typename dim ty typeid=request("typeid") typename="书吧" if not isempty(request("page")) then currentPage=cint(request("page")) else currentPage=1 end if dim rstype dim typesql dim typeid,typename1 if not isEmpty(request("typeid")) then typeid=request("typeid") else typeid=0 end if set rstype=server.createobject("adodb.recordset") typesql="select * from type where typeid="&typeid&"" rstype.open typesql,conn,1,1 if not rstype.eof then typename1=rstype("type") else typename1="全部图片" end if rstype.close set rst=server.CreateObject("ADODB.RecordSet") %> <body marginwidth="0" leftmargin="0" bgcolor="#FFFFFF" > <div align="center"> <div align="center"> <center> <!--#include file="home.asp" --> </center> </div> <div align="center"> <center> <table border="0" width="760" cellspacing="0" cellpadding="0"> <tr> <td width="100%" > <p align="left"> <span style="font-size:12pt;"><a href=" <%=rs("url")%> " ><font face="楷体_GB2312, 隶书, 宋体" size="4" color="#009900"><%=rs("homes")%></font></a>>><a href=" <%=rs("urls")%> " ><font face="楷体_GB2312, 隶书, 宋体" size="4" color="#009900"><%=rs("home")%></font></a>>><font color="#FF0000"><%response.write ""&typename1&""%></font></span><br> </table> <table width="600" border="0" align="center"> <tr> <td colspan="2" valign="top"> <p></p> <% dim sql 'if request("hits")="1" then ' sql="select * from learning order by hits desc" 'else if typeid=0 then sql="select * from learning order by hits desc" else sql="select * from learning where typeid="&typeid&" order by hits desc" end if Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 if rs.eof and rs.bof then response.write "<p align='center'> 还 没 有 任 何 文 章</p>" else totalPut=rs.recordcount totalPut=rs.recordcount if currentpage<1 then currentpage=1 end if if (currentpage-1)*MaxPerPage>totalput then if (totalPut mod MaxPerPage)=0 then currentpage= totalPut \ MaxPerPage else currentpage= totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showpage totalput,MaxPerPage,"good.asp" showContent showpage1 totalput,MaxPerPage,"good.asp" else if (currentPage-1)*MaxPerPage<totalPut then rs.move (currentPage-1)*MaxPerPage dim bookmark bookmark=rs.bookmark showpage totalput,MaxPerPage,"good.asp" showContent showpage1 totalput,MaxPerPage,"good.asp" else currentPage=1 showpage totalput,MaxPerPage,"good.asp" showContent showpage1 totalput,MaxPerPage,"good.asp" end if end if rs.close end if set rs=nothing conn.close set conn=nothing sub showContent dim i i=0 %> <div align="center"> <center> <table width=550 border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF""> <tr class=f9 style="color:white"> <td colspan="3" align="center" bgcolor="#CCCCCC" background="IMAGES/mmto.gif"><font color="#000000"><b>缩 图 列 表</b></font></td> </tr> <%i=0 do while not rs.eof%> <tr> <td colspan="3" height="24" bgcolor="<%if (i mod 2)=0 then Response.write ""%>"> <table width="100%"> <tr> <td width="300"> <div align="center"><a href="javascript:popwin2(<%=rs("articleid")%>)"><% if not isnull(rs("images")) and rs("images")<> "" then response.write "<img src=" + rs("images") + " border=0 >" end if %></a></div> </td> <td width="40%" valign="bottom"> <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF" bgcolor="#FFFFCC"> <tr> <td>图片名称:<%=rs("title")%></td> </tr> <tr> <td>浏览次数:<%=rs("hits")%></td> </tr> <tr> <td>加入日期:<%=rs("dateandtime")%></td> </tr> <tr> <td><font face="Webdings" size="4" color="#FF0000">q</font> <a href="review.asp?ID=<%=rs("articleid")%>" target="_blank">图 片 点 评</a> <font color="#FF0000"><%=rs("reviewcount")%> 篇</font></td> </tr> </table> </td> </tr> </table> </td> </tr> <% i=i+1 if i>=MaxPerPage then exit do rs.movenext loop %> </table> <table width="550" border="0" cellspacing="0" cellpadding="0"> <tr> <td><img src="IMAGES/bian.gif" width="550" height="13"></td> </tr> </table> </center> </div> <% end sub function showpage(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if Response.Write "<table border=""0"" cellspacing=""1"" width=""100%"">" response.write "<tr><td width=""38%"">" Response.Write "共有图片:<font face=""arial"" color=""red"">"&totalnumber&"</font>幅 <font face=""arial"" color=""red"">"&CurrentPage&"/"&n&"</font>页</td>" response.write "<form action=""search.asp"" method=""post"" name=""search"" onsubmit=""return checkinput()"">" response.write "<td width=""26%""><div align=""center""> "'图片搜索: response.write "<input type=""text"" name=keyword size=14 maxlength=""30"" value=""关键字搜索"" onFocus=this.value='' style=""font-size:9pt;background-color:#F7F7F7;border-left: 1px solid rgb(192,192,192); border-right: 1px solid rgb(192,192,192); border-top: 1px solid rgb(192,192,192); border-bottom: 1px solid rgb(192,192,192)"">" Response.Write "<input type=""hidden"" name=""typeid"" value="&typeid&">" response.write " <input type=""Image"" src=""images/ssearch.gif"" tppabs="""" align=""absmiddle"" width=""20"" height=""20"" title=""查询"" id=Image1 name=Image1>" response.write "</td></form>" response.write "<td width=""36%""><div align=""right"">" if CurrentPage<2 then response.write "<font color='999966'>首页 上一页</font> " else response.write "<a href="&filename&"?typeid="&typeid&"&page=1&>首页</a> " response.write "<a href="&filename&"?typeid="&typeid&"&page="&CurrentPage-1&">上一页</a> " end if if n-currentpage<1 then response.write "<font color='999966'>下一页 尾页</font>" else response.write "<a href="&filename&"?typeid="&typeid&"&page="&(CurrentPage+1) response.write ">下一页</a> <a href="&filename&"?typeid="&typeid&"&page="&n&">尾页</a>" end if Response.Write "</div></td></tr></table>" 'response.write " 页次: " 'response.write " 共<b>"&totalnumber&"</b>幅图片 <b>"&maxperpage&"</b>幅图片/页 " 'response.write " 转到:<input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">" ' response.write "<input class=buttonface type='submit' value=' 确定 ' name='cndok'></span></p></form>" end function function showpage1(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n= totalnumber \ maxperpage else n= totalnumber \ maxperpage+1 end if Response.Write "<table border=""0"" cellspacing=""1"" width=""100%"">" response.write "<tr><td align=""left""><td width=""64%"">" gotopage response.write "<td width=""36%""><div align=""right"">" if CurrentPage<2 then response.write "<font color='999966'>首页 上一页</font> " else response.write "<a href="&filename&"?typeid="&typeid&"&page=1&>首页</a> " response.write "<a href="&filename&"?typeid="&typeid&"&page="&CurrentPage-1&">上一页</a> " end if if n-currentpage<1 then response.write "<font color='999966'>下一页 尾页</font>" else response.write "<a href="&filename&"?typeid="&typeid&"&page="&(CurrentPage+1) response.write ">下一页</a> <a href="&filename&"?typeid="&typeid&"&page="&n&">尾页</a>" end if Response.Write "</div></td></tr></table>" 'response.write " 页次: " 'response.write " 共<b>"&totalnumber&"</b>幅图片 <b>"&maxperpage&"</b>幅图片/页 " 'response.write " 转到:<input type='text' name='page' size=4 maxlength=10 class=smallInput value="¤tpage&">" ' response.write "<input class=buttonface type='submit' value=' 确定 ' name='cndok'></span></p></form>" end function sub gotopage%> <form action=<%response.write ""&filename&"?typeid="&typeid&""%> method="POST"> 转到 <input type="Text" name="page" value="1" size="4" maxlength="4" style="font-size:9pt;background-color:#f7f7f7;border-left: 1px solid rgb(192,192,192); border-right: 1px solid rgb(192,192,192); border-top: 1px solid rgb(192,192,192); border-bottom: 1px solid rgb(192,192,192)"> 页 <input type="Image" src="images/go.gif" tppabs="" width="20" height="20" align="absmiddle" title="执行"> </form> <% end sub %></td> </tr> <tr> <td colspan="2" valign="top"><%'if request("hits")<>"1" then Response.write "<div align=center><a href=""index.asp?typeid="&typeid&""">最新加入图片</a></div> " 'else 'end if %><br> <br> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr valign="top"> <td height="19"><iframe src="bar.asp" width="100%" height=35 marginwidth="0" marginheight="0" hspace="0" vspace="0" frameborder="0" scrolling="NO"></iframe> </td> </tr> </table> </td> </tr> </table> </center> </div> </div> <!--#include file="homes.asp" --> </body> </html>