有关随机数、循环的问题,在线等待
fj47 2002-12-24 02:38:02 我想让系统随机生成帐号(7或8位),考虑到生成的帐号可能已经存在,所以需要到数据库中验证一下,如果已经存在,则重新生成一个,这要用到一个循环,请问要如何做呀?附上源代码
<!--#include file="conn.asp"-->
<%
netname =trim(request.form("netname"))
pwd =trim(request.form("pwd"))
email =trim(request.form("email"))
id_type =request.form("id_type")
cid =request.form("cid")
face =request.form("face")
'从这开始随机生成帐号
dim a
a=second(time)
a=cint(a)
if a mod 2 = 0 then
Randomize
userid =Int((9999999 - 1 + 1) * Rnd + 1)
else
Randomize
userid =Int((99999999 - 1 + 1) * Rnd + 1)
end if
'帐号生成完毕
if request.form("submit")<>"" then
dim rs,rc,sql
set rs=server.createobject("adodb.recordset")
sql="select * from user"
rs.open sql,conn,3,2
rs.addnew
Randomize
rs("userid") =userid
rs("netname") =netname
rs("pwd") =pwd
rs("email") =email
rs("id_type") =id_type
rs("cid") =cid
rs("face") =face
rs.update
rs.close
set rc=server.createobject("adodb.recordset")
sql="select u_id from user where netname='" & netname &"'"
rc.open sql,conn,1,1
session("u_id") =rc("u_id")
session("netname")=netname
rc.close
set conn=nothing
%>