📄 dx.asp

📁 小灵通短信网站源程序

💻 ASP

字号:

<% Response.Buffer=True %>
<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<% set rs=server.createobject("adodb.recordset")
sql="select * from articles"
rs.open sql,conn,1,1
r1=rs.recordcount
rs.close                                                                    
set rs=nothing
set rs=server.createobject("adodb.recordset")
sql="select * from articles"           
rs.open sql,conn,1,1 
%>
<html>
<head>
<title> </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="Style.css" type="text/css">
</head>
<body bgcolor="#99ccff" text="#000000" topMargin=0 rightMargin=0 leftMargin=0>
<% set rs=server.createobject("adodb.recordset")
     sql="select * from articles order by articleid desc" 
     rs.open sql,conn,1,1 %>
<br>
<table border=0 cellpadding=0 cellspacing=2 width=100%>
  <tr bgcolor="#FFF9F0"> 
    <td align=center width="100%" bgcolor="#8dceee"><a href="salon.asp?classid=6" target="_parent">短句中心</a></td>
  </tr>
  <% do while not rs.eof %>
  <tr bgcolor="#FEF0D1"> 
    <td width="100%" bgcolor="#99ccff"><a href="send.asp?id=<%=rs("articleid")%>" target="_blank"> 
      <% if len(rs("title"))>18 then%>
      <%=left(rs("title"),18)%>... 
      <% else%>
      <%=rs("title")%> 
      <%end if%>
      </a></td>
  </tr>
  <tr bgcolor="#FFF9F0"> 
    <td align=center width="100%"></td>
  </tr>
  <% n=n+1                                                                     
               rs.movenext                                                                     
               if n>=10 then exit do                                                                     
               loop                                                                    
               rs.close                                                                    
               set rs=nothing %>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -