Question

解释下这段代码

<% sql="select top 4 * from news where classid=1 order by news_pubdatetime desc,news_id desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof
%>
给解释下这段代码的意思

Answer 1

<% sql="select top 4 * from news where classid=1 order by news_pubdatetime desc,news_id desc"
制定SQL查询语句
set rs=server.CreateObject("adodb.recordset")
声明连接方式
rs.open sql,conn,1,1
打开连接 执行sql语句
do while not rs.eof 判断查询记录是否为空
%>

Answer 2

循环读出你要的数据

Answer 3

'定义查询语句,查找CLASSID=1的新闻并按发布时间取最新的4条
sql="select top 4 * from news where classid=1 order by news_pubdatetime desc,news_id desc"
'定义Recordset变量
set rs=server.CreateObject("adodb.recordset")
'执行数据库查询
rs.open sql,conn,1,1
'用循环列出查到的数据
do while not rs.eof