如何将产生的密码记录并发送给用户并通过点击链接激活？

<%@language="vbscript" %>
<%
set mail= server.createobject("cdonts.newmail")
mail.subject="恭喜,您在随风起舞注册成功,感谢您的参与!"
mail.to = mailid mail.from ="[e-mail]"
mail.body= "这是随风起舞寄给您的初始密码" & vbcrlf
&href='mailto:mailid="[e-mail]'>mailid="[e-mail]"
address="address"

set conn = server.createobject("adodb.connection")
conn.open "dsn","uid","pwd"
set rec= conn.execute("select count(*) from membertable")
id = cint(rec.fields(0))+1
r=rnd *50
response.write r & "<br>"
for i = 0 to 20
    if cint(r)>0 and cint(r)<26 then str=str +chr(97 + cint(r))
    r=rnd *100
next

response.write str
pwd=left(str,2)
pwd=pwd & id
pwd=pwd & right(str,2)
pwd=pwd & second(time)

%>
<br>
<%
set mail= server.createobject("cdonts.newmail")
mail.subject="千花飞舞向您问候!"
mail.to = mailid
mail.from ="[e-mail]"
mail.body= "这是随风起舞寄给您的初始密码" & vbcrlf & "您可以随时修改它" & vbcrlf &
pwd & vbcrlf & "再次感谢光临随风起舞!"
mail.send
%>

 

[1]