asp读取access超简单 但我不会

[jmxb123]

access数据库中只有一个表aaa,表中有两个字段,name pass
通过IE提交name中的特定值http://ip/readpass?name=xiaohei 要求返回对应该的pass值

小弟从没接触过ASP 只能靠大家帮忙了

[hookee]

readpass.asp 假设db.mdb和 readpass.asp在同一目录下
<%
name = Request.QueryString("name")
name = Replace(name,"'","''")

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Server.MapPath("db.mdb")
Set conn = CreateObject("ADODB.Connection")
conn.Open sConn
Set rs = CreateObject("ADODB.RecordSet")
rs.CursorLocation = 3
sql = "SELECT pass FROM aaa WHERE [name]='" & name & "'"
rs.Open sql, conn, 1, 1
If Not(rs.BOF And rs.EOF) Then
Response.Write "password : " & rs(0)
Else
Response.Write "无记录"
End If
If rs.State<>0 Then rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

[9611122]

缺心眼

[kimipolo]

最好 if name<>"" then

打开数据库查询

end if
要不然直接访问 ，会出错

[jmxb123]

/readpass.asp?name= 会返回无记录的