📄 daily.asp

📁 个人网站系统毕业论文大家可以借鉴下
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="page.asp"-->
<!--#include file="ubbcode.asp"-->
<!--#include file="function.asp"-->
<SCRIPT language=JavaScript>
<!--
function wi(url) { //v2.0
  window.open(url,"news","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=no,width=470,height=450,left=20,top=15");
}
//-->
</SCRIPT>
<body oncontextmenu="return false" onselectstart="return false"  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<% set rs=server.CreateObject("adodb.recordset")
  sql="select * from dy_daily order by dy_id desc"
  rs.open sql,conn,1,1
  if rs.eof and rs.bof then%>
  <table width="633" height="67" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr bgcolor="#FFFFFF"> 
    <td  align="center">当前没有日记！！<%if session("oursky")="oursky" then %><a href="write_daily.asp">写日记</a><%end if%></td>
  </tr></table>
  <%else
  page=request.querystring("page")   
 rs.PageSize = 6 
 if Not IsEmpty(page) then  
    if Not IsNumeric(page) then  
       page=1
    else
    Page = cint(page)  
    end if   
    if Page > rs.PageCount then  
        rs.AbsolutePage = rs.PageCount     
    elseif Page <= 0 then  
        rs.AbsolutePage = 1  
    else
        rs.AbsolutePage = Page  
    end if
else
rs.AbsolutePage=1
end if
Page = rs.AbsolutePage%>
<table width="633" height="80" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr bgcolor="#FFFFFF"> 
    <td height="21" colspan="5">总共<%=rs.recordcount%>篇日记 
      <%if session("oursky")="oursky" then%> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="write_daily.asp">&nbsp;写日记</a> 
      <%end if%> </td>
  </tr><%For i = 1 to rs.PageSize  
   if rs.eof then
   Exit For 
   end if %>
  <tr bgcolor="#FFFFFF">
    <td height="56" colspan="5" align="center" valign="top"> 
      <table width="98%" height="21" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="116" align="center"><font color="#009900">日期</font>：<%=rs("dy_time")%></td>
          <td width="148" align="center"><font color="#009900">天气：</font><img src="<%=rs("dy_tq")%>"></td>
          <td width="195" align="center"><font color="#009900">浏览次数：</font><%=rs("dy_hit")%></td>
          <td width="172" rowspan="2" align="center"><font color="#009933">第<font color="#FF3333"><%=rs("dy_id")%></font> 篇日记</font></td>
        </tr>
        <tr> 
          <td colspan="3" background="img/dot.gif"><a href="javascript:wi('showdaily.asp?id=<%=rs("dy_id")%>')"><%=ubb(th(rs("dy_content")))%>......</a> <%if session("oursky")="oursky" then%>
            <a href="daily_edi.asp?id=<%=rs("dy_id")%>">修改</a>&nbsp;&nbsp; 
            <script language="JavaScript">
<!--
function suredo(src,q)
    {
      var ret;
      ret = confirm(q);
      if(ret!=false)window.location=src;
    }
//-->
</script> <a href='javascript:suredo("daily_del.asp?id=<%=rs("dy_id")%>","确定删除?")'>删除</a> 
            <%end if%></td>
        </tr>
      </table>
	  <hr color="#CCCCCC" width="500" align="left">
    </td>
  </tr>
  
  <%rs.movenext
   next%>
</table>
<table width="633" height="27" border="0" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <td align="center" bgcolor="#FFFFFF">
	<%call pagination(rs.pagecount,rs.pagesize,page,rs.recordcount)
	 rs.close
  set rs=nothing
  conn.close
  set conn=nothing
  end if %></td>
  </tr>
</table>
</body>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -