📄 add_st_ok.asp
字号:
<!--#include file="zxdkconn.asp"-->
<%
if session("user")="" then
response.write "管理员页面，您无权访问"
response.end
end if
%>
<%
dim name,shenfen,sex,idnumber,time,city,homephone,zhanghao,jia,jiuye,tel,info,banji,one0,one1,one2,one3,one4,two0,two1,two2,two3,two4,fir0,fir1,fir2,fir3,fir4,a0,a1,a2,a3,a4,b0,b1,b2,b3,b4,c0,c1,c2,c3,c4,date1,date2,date3,aa1,aa2,aa3,aa4,bb1,bb2,bb3,bb4,cc1,cc2,cc3,cc4
name=trim(request("name"))
shenfen=trim(request("shenfen"))
sex=trim(request("sex"))
idnumber=trim(request("idnumber"))
time=trim(request("time"))
city=trim(request("city"))
homephone=trim(request("homephone"))
zhanghao=trim(request("zhanghao"))
jia=trim(request("jia"))
jiuye=trim(request("jiuye"))
tel=trim(request("tel"))
info=trim(request("info"))
banji=trim(request("banji"))
one0=trim(request("one0"))
one1=trim(request("one1"))
one2=trim(request("one2"))
one3=trim(request("one3"))
one4=trim(request("one4"))
two0=trim(request("two0"))
two1=trim(request("two1"))
two2=trim(request("two2"))
two3=trim(request("two3"))
two4=trim(request("two4"))
fir0=trim(request("fir0"))
fir1=trim(request("fir1"))
fir2=trim(request("fir2"))
fir3=trim(request("fir3"))
fir4=trim(request("fir4"))
a0=trim(request("a0"))
a1=trim(request("a1"))
a2=trim(request("a2"))
a3=trim(request("a3"))
a4=trim(request("a4"))
b0=trim(request("b0"))
b1=trim(request("b1"))
b2=trim(request("b2"))
b3=trim(request("b3"))
b4=trim(request("b4"))
c0=trim(request("c0"))
c1=trim(request("c1"))
c2=trim(request("c2"))
c3=trim(request("c3"))
c4=trim(request("c4"))
date1=trim(request("date1"))
aa1=trim(request("aa1"))
aa2=trim(request("aa2"))
aa3=trim(request("aa3"))
aa4=trim(request("aa4"))
date2=trim(request("date2"))
bb1=trim(request("bb1"))
bb2=trim(request("bb2"))
bb3=trim(request("bb3"))
bb4=trim(request("bb4"))
date3=trim(request("date3"))
cc1=trim(request("cc1"))
cc2=trim(request("cc2"))
cc3=trim(request("cc3"))
cc4=trim(request("cc4"))
%>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from st_info"
rs.open sql,conn,1,3
%>
<%
rs.addnew
rs("number")=now()
rs("name")=name
rs("shenfen")=shenfen
rs("sex")=sex
rs("idnumber")=idnumber
rs("time")=time
rs("city")=city
rs("homephone")=homephone
rs("zhanghao")=zhanghao
rs("jia")=jia
rs("jiuye")=jiuye
rs("tel")=tel
rs("info")=info
rs("banji")=banji
rs("one0")=one0
rs("one1")=one1
rs("one2")=one2
rs("one3")=one3
rs("one4")=one4
rs("two0")=two0
rs("two1")=two1
rs("two2")=two2
rs("two3")=two3
rs("two4")=two4
rs("fir0")=fir0
rs("fir1")=fir1
rs("fir2")=fir2
rs("fir3")=fir3
rs("fir4")=fir4
rs("a0")=a0
rs("a1")=a1
rs("a2")=a2
rs("a3")=a3
rs("a4")=a4
rs("b0")=b0
rs("b1")=b1
rs("b2")=b2
rs("b3")=b3
rs("b4")=b4
rs("c0")=c0
rs("c1")=c1
rs("c2")=c2
rs("c3")=c3
rs("c4")=c4
rs("date1")=date1
rs("aa1")=aa1
rs("aa2")=aa2
rs("aa3")=aa3
rs("aa4")=aa4
rs("date2")=date2
rs("bb1")=bb1
rs("bb2")=bb2
rs("bb3")=bb3
rs("bb4")=bb4
rs("date3")=date3
rs("cc1")=cc1
rs("cc2")=cc2
rs("cc3")=cc3
rs("cc4")=cc4
set rst=server.createobject("adodb.recordset")
sql="select * from st_info where shenfen='"&shenfen&"' "
rst.open sql,conn,1,3
if Not(rst.bof and rst.eof) then
rst.delete
end if
rst.close
set rst=nothing
rs.update
rs.close
set rs=nothing
%>
<%
response.write "<script language='javascript'>window.confirm('增加成功，单击确定关闭本窗口')</script>"
%>
<body onload=javascript:window.close()></body> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -