我注册的时候也没用自动编号,也还是那个问题,我都有点迷茫了
<%
conn="provider=microsoft.jet.oledb.4.0;data source=C:\Inetpub\wwwroot\wangye\images\access\wangye.mdb;persist security info=false"
set strconn=Server.CreateObject("adodb.connection")
strconn.open conn
uid=request.Form("uid")
upwd=request.Form("upwd")
add=request.Form("add")
sex=request.Form("sex")
tel=request.Form("tel")
email=request.Form("email")
names=request.Form("name")
set urs=server.CreateObject("adodb.recordset")
urs.open"select * from userzl where uid='"&uid&"'",conn,1,3
if not urs.eof then
response.Write"<script language=javascript>alert('用户名已存在');history.go(-1);</script>"
else
urs.addnew
urs("uid")=uid
urs("upwd")=upwd
urs("email")=email
urs("sex")=sex
urs("name")=names
urs("add")=add
urs("tel")=tel
urs.update
urs.close
set urs=nothing
session("uid")=uid
session("upwd")=upwd
response.Write"<script language=javascript>alert('注册成功');window.location='../house/house.asp'</script>"
end if
%>