一个密码找回功能显示为空白页面
这是一个通过验证用户的工资单号和出生日期来让用户找回自己以前存储在数据库中密码的功能代码.当getpassword页面提交后,显示为isuser.asp的空白页面,估计可能是显示密码的页面错了(password.asp),但不知怎么修改,请各位高手帮忙看看,谢谢了!!!getpassword.asp代码:<body>
<div align="center" class="style1">
<p> </p>
<p> </p>
<p align="center" class="style7">请输入注册时的出生日期和工资单号: </p>
<p> </p>
<form name="isuser" id="isuser" method="post" action="isuser.asp" onSubmit="return checkData()">
<table width="618" border="1" div align="center">
</table>
<div align="center">
<table width="537" border="1">
<tr>
<td width="135" height="77"><div align="center">出生日期:</div></td>
<td width="386"><div align="center">
<input name="Byear" id="Byear" size="8" height="18">
年
<select name="Bmonth">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<select name="Bday">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
日</div></td>
</tr>
<tr>
<td height="114"><div align="center">工资单号: </div></td>
<td><div align="center">
<input name="txt_Tijiandanhao" type="text" id="txt_Tijiandanhao">
</div></td>
</tr>
<tr>
<td height="88"><div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td> </td>
</tr>
</table>
</div>
<div align="center"></div>
</form>
</body>
</html>
isuser.asp代码:
<!--#include file="conn.asp"-->
<%
dim userbirth,tijiandanhao
userbirth=request.form("Byear")&"-"&request.form("Bmonth")&"-"&request.form("Bday")
tijiandanhao=request.form("txt_Tijiandanhao")
%>
<%
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from admininfo where userBirth ='"& userbirth &"' and Tijiandanhao='"& tijiandanhao &"'"
rs.open sqlstr,conn,1,1
If not rs.eof then
response.redirect("password.asp")
else
response.redirect ("wrong.asp")
end if
rs.Close
set rs = nothing
conn.close'
set conn = nothing
%>
</body>
</html>
password.asp代码:
<%
dim userbirth,tijiandanhao, pass, UserPass
tijiandanhao=request.form("txt_Tijiandanhao")
userbirth=request.form("Byear")&"-"&request.form("Bmonth")&"-"&request.form("Bday")
%>
<%
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from admininfo where userBirth ='"& userbirth &"' and Tijiandanhao='"& tijiandanhao &"'"
rs.open sqlstr,conn,1,1
If not rs.eof then
pass=rs("UserPass")
rs.update
response.write"您的原始密码为: pass"
end if
rs.Close
set rs = nothing
conn.close
set conn = nothing
%>
