admin_add.asp

十分好的音乐网站源码 十分好的音乐网站源码十分好的音乐网站源码十分好的音乐网站源码十分好的音乐网站源码

<%response.buffer=true%>
<!--#include file=conn/adodb.asp -->
<%
on error resume next
dim xxlx,fylx,qy,wz,jzmc,xxdz,fylb,fwmj,zlc,szc,fwfx,qt,jg,dw,fjf,fkfs,sfdk,cq,s,t,w,ty,ccs,ck,yt,fbsj,lxr,lxdh,bz

xxlx=trim(request.form("xxlx"))
fylx=trim(request.form("fylx"))
qy=trim(request.form("qy"))
wz=trim(request.form("wz"))
jzmc=trim(request.form("jzmc"))
xxdz=trim(request.form("xxdz"))
fylb=trim(request.form("fylb"))
fwmj=trim(request.form("fwmj"))
zlc=trim(request.form("zlc"))
szc=trim(request.form("szc"))
fwfx=trim(request.form("fwfx"))
qt=trim(request.form("qt"))
jg=trim(request.form("jg"))
dw=trim(request.form("dw"))
fjf=trim(request.form("fjf"))
fkfs=trim(request.form("fkfs"))
sfdk=trim(request.form("sfdk"))
cq=trim(request.form("cq"))
s=trim(request.form("s"))
t=trim(request.form("t"))
w=trim(request.form("w"))
ty=trim(request.form("ty"))
ccs=trim(request.form("ccs"))
ck=trim(request.form("ck"))
yt=trim(request.form("yt"))
lxr=trim(request.form("lxr"))
fbsj=now()
lxdh=trim(request.form("lxdh"))
bz=trim(request.form("bz"))
y=year(date)
mn=month(date)
d=day(date)
h=hour(time)
mu=minute(time)
ss=second(time)
fybm=y&mn&d&h&mu&ss
dim strsql,sql

db.begingtrans


sql="insert into tjfy(fybm,fylx,xxlx,qy,wz,jzmc,xxdz,fylb,fwmj,zlc,szc,fwfx,qt,jg,dw,fjf,fkfs,sfdk,cq,s,t,w,ty,ccs,ck,yt,fbsj,lxr,lxdh,bz) values('" & fybm & "','" & fylx & "','" & xxlx & "','" & qy & "','" & wz & "','" & jzmc & "','" & xxdz & "','" & fylb & "','" & fwmj & "','" & zlc & "','" & szc & "','" & fwfx & "','" & qt & "','" & jg & "','" & dw & "','" & fjf & "','" & fkfs & "','" & sfdk & "','" & cq & "','" & s & "','" & t & "','" & w & "','" & ty & "','" & ccs & "','" & ck & "','" & yt & "','" & fbsj & "','" & lxr & "','" & lxdh & "','" & bz & "')"
db.execute(sql)
if db.errors.count=0 then
db.committrans
response.write "<script>alert('操作成功！');window.location.href='admin_fbxx.asp';</script>"
response.write "<script>window.location.reload()</script>"
else
db.rollbacktrans
response.write"<SCRIPT language=JavaScript>alert('你输入的数据类型不正确！');"
response.write"this.location.href='admin_fbxx.asp';</SCRIPT>" 
end if
%>