ASP高手请进,判断POST获取值与数据库中某值相等

2025-05-13 14:01:18
推荐回答(2个)
回答(1):



<%
xm=request("xm")
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from pub where xm='"&xm&"'"
rs.Open sql,conn,1,1
if rs.EOF and rs.BOF then
response.write ("暂时没有数据")
else
Do Until rs.EOF
response.write("
姓名:"& rs("xm"))
response.write("
分数:"& rs("fsf"))
rs.MoveNext
Loop
end if
rs.close
Set rs = Nothing
conn.close
set conn=nothing
%>

回答(2):

Select * from pub where xm='"&request("xm&")"'

直接在查询语句的条件裏写进去就行了,有就读出来没有当然就是没有罗