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]