forget.asp
' 申请.
html>
head>
title>闪亮日子之用户密码核实/title>
/head>
div align="center">center>
table border="0" cellspacing="0" width="600" height="158" >
tr>
td height="67">p align="center">闪亮日子br>
用户密码核实/td>
/tr>
tr>
td height="63">p align="center">font color="#0000FF">请正确填写您的邮件地址,我们会在核实后,尽快将密码寄给您!/font>/p>
form method="POST" action="sendit.asp">
div align="center">center>p>您的邮件地址: input type="text" name="email"
size="20" style="font-size: 12pt"> input type="submit" value="确定"
style="font-size: 12pt"> /p>
/center>/div>
/form>
/td>
/tr>
/table>
/center>/div>
/body>/html>
sendit.asp
' 确认.
%@ LANGUAGE="VBscript" %>
% Option Explicit %>
%
Dim DATA_PATH, objDC, objRS, email, user, pass, sendmail
DATA_PATH=Server.Mappath("users.mdb")
' 打开数据库.
Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
objDC.Open "DBQ=" DATA_PATH ";Driver={Microsoft Access Driver (*.mdb)}; DriverId=25;MaxBufferSize=8192;Threads=20;", "admin", "password"
Set objRS = Server.CreateObject("ADODB.Recordset")
email=request.form("email")
objRS.Open "select * from USERS WHERE email = '" email "'", objDC, 0, 1
' 校验用户的信箱是否存在.
%>
html>
head>
title>山水盈盈之邮件地址错误提示/title>
/head>
body>
%
if objrs.EOF then
%>
b>font color="red">
/font>/b>div align="center">center>
table border="0" cellspacing="0" width="600" height="100" >
tr>
td height="64">p align="center">山水盈盈br>
邮件地址错误提示/font>/td>
/tr>
tr>
td height="37">b>font color="red">p align="center">对不起,该用户邮件信箱:%=email%>不存在!
/font>/b>/td>
/tr>
/table>
/center>/div>
/body>/html>
/font>/B>
% Else %>
%
email = request.form("email")
' 从数据库中选取与递交的信箱对应的帐号,密码.
user = objrs.Fields("username")
pass = objrs.Fields("password")
Set sendmail = Server.CreateObject("CDONTS.NewMail")
sendmail.From = webmaster@intels.net
' 网管信箱.
sendmail.To = email
sendmail.Subject = "您的登录信息,请保存好!"
' 邮件主题.
sendmail.body = "您在山水盈盈的登录资料是:" vbCrlf vbCrlf _
"Username=" user vbCrlf _
"Password=" pass vbCrlf
' 邮件内容.
sendmail.Importance = 2
sendmail.Send
%>
您的资料已发送到%=email%>,请收好,欢迎再次光临!br>
%
objDC.Close
Set objRS = Nothing
Set objDC = Nothing
Set sendmail = Nothing
%>
%end if%>
[1]
