高校问答优博娱乐场官网:ASP编程问题
来源：百度文库 编辑：高校问答 时间：2024/04/28 07:22:27
谁帮忙解释下代码
set rs=server.createobject("adodb.recordset")
sql="update news set hits=hits+1 where newsid=" & cstr(request("newsid"))conn.execute sql
if session("purview")="" then
rs.open "select * from news where newsid=" & cstr(request("newsid")) & " and audit=1",conn,1,1else
rs.open "select * from news where newsid=" & cstr(request("newsid")),conn,1,1end ifif err.number <> 0 thenresponse.write "数据库出错"else if rs.bof and rs.eof then
rs.close
response.write "该新闻不存在或未经过审核"
set rs=server.createobject("adodb.recordset")
sql="update news set hits=hits+1 where newsid=" & cstr(request("newsid"))conn.execute sql
if session("purview")="" then
rs.open "select * from news where newsid=" & cstr(request("newsid")) & " and audit=1",conn,1,1else
rs.open "select * from news where newsid=" & cstr(request("newsid")),conn,1,1end ifif err.number <> 0 thenresponse.write "数据库出错"else if rs.bof and rs.eof then
rs.close
response.write "该新闻不存在或未经过审核"
set rs=server.createobject("adodb.recordset") //设置数据集
sql="update news set hits=hits+1 where newsid=" & cstr(request("newsid"))//书写sql命令，当newsid=request("newsid")时候更新new表设置hits加1
conn.execute sql //执行sql命令
if session("purview")="" then //如果session("purview")为空那么
rs.open "select * from news where newsid=" & cstr(request("newsid")) & " and audit=1",conn,1,1//选出新闻
else //否则
rs.open "select * from news where newsid=" & cstr(request("newsid")),conn,1,1//选出新闻
end if
if err.number <> 0 then//如果出现错误
response.write "数据库出错"//现实错误
else //否则
if rs.bof and rs.eof then //如果数据库为空
rs.close //关闭数据集
response.write "该新闻不存在或未经过审核"//现实信息