【问题2】 程序serach.asp的功能是根据类别、品牌、型号,按照用户输入的关键字进行查询,请为其(4)~(7)处选择合适的答案。 search.asp <HTML> <BODY> . . (数据库连接代码) . <% Dim sql, kind, keyword kind=request ("kind") keyword=request ( "keyword" )sql = "SELECT * FROM 商品明细where" & kind &" (4) ’%"&keyword&"%’" set rs=server. (5) ("adodb.recordset") (6) .open sql,conn, 3,2%> <TABLE BORDER=" 1"> . . (输出表头) . <% Do While Not rs.EOF Response.Write "<TR><TD>" & rs("类别") & "</TD>" Response.Write "<TD>" & rs("品牌") & "</TD>" Response.Write "<TD>" & rs("型号") & "</TD>" Response.Write "<TD>" & rs("价格") & "</TD></tr>" rs. (7) loop rs .Close set rs = Nothing . . . %> </TABLE> </BODY> </HTML> (4)~(7) 备选答案: A. =B. like C. movenext D. getrecordset E. rsF. sql G. top H. createobject