UC知道asp与Access数据传递问题
来源：百度知道 编辑：UC知道 时间：2024/05/15 06:29:06
我做了个登陆的页面,login.asp
<form name="form1" method="post" action="check.asp">
<div align="center"> <span class="font"> 学号：</span>
<input type="text" name="name" class="text" size="20" onMouseOver="this.focus()">
<br>
<span class="font">密码：</span>
<input type="password" name="password" class="text" size="20" onMouseOver="this.focus()"><%if session("check")="wrong" then response.Write "<br><span class='font'><font color=red>验证错误!</font></span>" end if%>
</div>
check.asp代码
<%
dim name,password
name=request.form("name")
password=request.form("password")
dim exec,conn,rs
<form name="form1" method="post" action="check.asp">
<div align="center"> <span class="font"> 学号：</span>
<input type="text" name="name" class="text" size="20" onMouseOver="this.focus()">
<br>
<span class="font">密码：</span>
<input type="password" name="password" class="text" size="20" onMouseOver="this.focus()"><%if session("check")="wrong" then response.Write "<br><span class='font'><font color=red>验证错误!</font></span>" end if%>
</div>
check.asp代码
<%
dim name,password
name=request.form("name")
password=request.form("password")
dim exec,conn,rs
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("database/bmxt.mdb")
set rs=server.createobject("adodb.recordset")
exec="select Stu_xh,Stu_mima from Student where Stu_xh like '%"&name&"%' and Stu_mima like '%"&password&"%'"
rs.open exec,conn ,1,1
从你的这段代码来看，你没有写显示的代码，
还有如果你需要关闭rs的话，需要 set rs = nothing
如果你要取rs里面的值，那么，不要那么早关闭rs，等你使用结束了再关
是不是该用循环的啊?你的意思我还不太明白,说详细点,想怎么样