ASP作业

<%
set cn=server.createobject("ADODB.connection")
cn.open "driver={sql server};Server=(local);UID=sa;PWD=0328;Database=renbotao"
%>

TOP:
<%
set rs=cn.execute("select * from book_score")
%>

<% while not rs.eof %>

<% for i=0 to rs.Fields.count-1 %>
  
   <% next %>

<% rs.movenext  
   wend
cn.close
set cn=nothing   %>

<%=rs(i).value %>
  

RETURN:
<%
response.expires=0
rkeyword=request.form("keyword")
rproject=request.form("project")
if rproject="书名" then
set rs=cn.execute("select * from book where title like '%"& request("keyword") &"%'")
elseif rproject="作者" then
set rs=cn.execute("select * from book where author like '%"& request("keyword") &"%'")
elseif rproject="内容" Then
set rs=cn.execute("select * from book where content like '%"& request("keyword") &"%'")
end If
%>

  
    





<% while not rs.eof %>

<% for i=0 to rs.Fields.count-1 %>
  
   <% next %>

<% rs.movenext  
   wend
cn.close
set cn=nothing   %>

编号	书名	作者	内容	评价
<%=rs(i).value %>