UC知道asp 插入数据库 多了一条空白记录
来源：百度知道 编辑：UC知道 时间：2024/05/11 21:22:33
<%
set conn=server.createobject("adodb.connection")conn.open "driver={microsoft access driver(*.mdb)};dbq="&server.mappath("tongxunlu.mdb")
name=request.form("name")
xb=request.form("xb")
nc=request.form("nc")
jx=request.form("jx")
lxfs=request.form("lxfs")
email=request.form("email")
gxqm=request.form("gxqm")
exec="insert into ziliao(name,xb,nc,jx,lxfs,email,gxqm)values('"+name+"','"+xb+"','"+nc+"','"+jx+"','"+lxfs+"','"+email+"','"+gxqm+"')"
conn.execute exec
conn.close
set conn=nothing
if request("submit")="提交" then
if request.form("name")=""or request.form("xb")=""or request.form("nc")=""or requ
set conn=server.createobject("adodb.connection")conn.open "driver={microsoft access driver(*.mdb)};dbq="&server.mappath("tongxunlu.mdb")
name=request.form("name")
xb=request.form("xb")
nc=request.form("nc")
jx=request.form("jx")
lxfs=request.form("lxfs")
email=request.form("email")
gxqm=request.form("gxqm")
exec="insert into ziliao(name,xb,nc,jx,lxfs,email,gxqm)values('"+name+"','"+xb+"','"+nc+"','"+jx+"','"+lxfs+"','"+email+"','"+gxqm+"')"
conn.execute exec
conn.close
set conn=nothing
if request("submit")="提交" then
if request.form("name")=""or request.form("xb")=""or request.form("nc")=""or requ
改成:
<%
if request("submit")="提交" then
if request.form("name")=""or request.form("xb")=""or request.form("nc")=""or request.form("jx")=""or request.form("lxfs")=""or request.form("email")=""or request.form("gxqm")="" then
response.Write"<script>alert('资料填写不完整，请重新输入!');history.back();</script>"
response.end
else
set conn=server.createobject("adodb.connection")conn.open "driver={microsoft access driver(*.mdb)};dbq="&server.mappath("tongxunlu.mdb")
name=request.form("name")
xb=request.form("xb")
nc=request.form("nc")
jx=request.form("jx")
lxfs=request.form("lxfs")
email=request.form("email")
gxqm=request.form("gxqm") <