用asp读取SQL数据库实现用户登陆与注册代码

注册

<!-- #include file="conn.asp" -->

<%

username=request.Form("name")

pass=request.Form("pass")

if username="" or pass="" or pass1="" then

response.Redirect "zhuce.asp"

else

if pass <>pass1 then

response.redirect"zhuce.asp"

else

set rs=server.createobject("adodb.recordset")

sql="select * from admin "

rs.open sql,conn,3,3

rs.addnew

rs("name")=username

rs("pass")=pass

rs.update

end if

end if

%>

等入

<!--#include file="conn.asp" -->

<%

if request.QueryString("action")="login" then

if cstr(Session("GetCode"))<>cstr(Request.Form("VerifyCode")) then

Response.Write("<script>alert(""您输入的确认码和系统产生的不一致，请重新输入。返回后请刷新登录页面后重新输入正确的信息。"")location.href=""Login.asp""</script>")

Response.End

end if

if request.form("name")="" then

Response.Write("<script language=""JavaScript"">alert(""用户名不能为空！"")history.go(-1)</script>")

response.End()

end if

if request.form("pass")="" then

Response.Write("<script language=""JavaScript"">alert(""请输入正确的密码！"")history.go(-1)</script>")

response.End()

end if

set rs=server.createobject("adodb.recordset")

rs.open "select * from admin where name='" &request.Form("name") &"' AND pass='" &md5(Request.Form("pass")) &"'",conn,3,3

if not rs.eof then

if request.Form("name")=rs("name") and md5(Request.Form("pass"))=rs("pass") then

Response.Write("<a href='list.asp?key="&rs("name")&"'>点击返回首页</a>")

else

Session("GetCode")=""

rs.close:set rs=nothing

Response.Write("<script language=""JavaScript"">alert(""用户不存在！"")history.go(-1)</script>")

response.end

end if

else

Session("GetCode")=""

rs.close:set rs=nothing

Response.Write("<script language=""JavaScript"">alert(""请输入正确的密码！"")history.go(-1)</script>")

response.End()

end if

end if

%>

不会的，一般不会同时运行太多账号，数据库可支撑力是很大的，不用担心这个问题，要批量注册所需要用的代码如下：

# -*- coding:utf-8 -*-

import random,urllib,urllib2

import re,time

x=input("请输入需要注册的数量:")

# x=raw_input() #转换成字符串的

def h(i,y):

   user=str(random.randrange(10000000,99999999))

QQ=str(random.randrange(10001,999999999999))

  pwd=str(random.randrange(100000,99999999))

  url="http://www.qb5.com/register.php?do=submit"

  data={"username":user,

  "password":pwd,

  "repassword":pwd,

  "email":QQ+"@qq.com",

  "qq":QQ,

  "sex":"0",

  "action":"newuser",

  "submit":""}

  data=urllib.urlencode(data)

  req=urllib2.Request(url,data=data)

  print data

  # html=urllib2.urlopen(req).read()

  # print(html)

  html=urllib2.urlopen(req).read().decode('gbk')

  # print(type(html))

  reg=u'您已成功注册成为本站用户'

  reg=re.compile(reg)

  r=re.findall(reg,html)

  if r!=[]:

      print("注册成功，账号为%s，密码为%s，目前注册到第%s,还剩%s个"%(user,pwd,i+1,y-i-1))

      f=open("c:\user.txt","a")

      f.write("%s----%s----%s@qq.com----%s\n" %(user,pwd,QQ,QQ))

      # f.write("qq----123456")

      f.close()

for i in range(x):

  h(i,x)

  # 延时

  time.sleep(2)

---