admin_saveup.asp

一套简单的教师办公系统,ASP+ACCESS开发

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="tcconn.asp" -->
<%
if request.Cookies("flag")<>"loginok" then
response.write "<script language=JavaScript>{window.alert('网络超时或你还未登录，请重新登陆!');window.location.href='index.htm';}</script>"
response.end
end if
tc_name=trim(request("txt_name"))
if tc_name="" then
response.Write "<script language=javascript>{window.alert('教师姓名不能为空!');window.history.go(-1);}</script>"
response.End()
end if
set tcrs=conn.execute("select tc_name from tcinfor where tc_name='"&tc_name&"'")
if tcrs.recordcount>0 then
set tcrs=nothing
response.Write "<script language=JavaScript>{window.alert('同一记录不能重复添加!');window.location.href='admin_writeto.asp';}</script>"
response.End()
end if
set tcrs=nothing
tc_sex=request("txt_sex")
tc_birt=request("txt_birt")
tc_indate=request("txt_indate")
tc_code=request("txt_code")
tc_address=request("txt_address")
tc_zhy=request("txt_zhy")
tc_dw=request("txt_dw")
tc_xl_bydate1=request("txt_xl_bydate1")
tc_xl_bydate2=request("txt_xl_bydate2")
tc_xl_bydate3=request("txt_xl_bydate3")
tc_xl_byschool1=request("txt_xl_byschool1")
tc_xl_byschool2=request("txt_xl_byschool2")
tc_xl_byschool3=request("txt_xl_byschool3")
tc_xl_zhy1=request("txt_xl_zhy1")
tc_xl_zhy2=request("txt_xl_zhy2")
tc_xl_zhy3=request("txt_xl_zhy3")
tc_work_jx=request("txt_work_jx")
tc_work_ky=request("txt_work_ky")
tc_work_xsh=request("txt_work_xsh")
tc_shh_xsh_zhw1=request("txt_shh_xsh_zhw1")
tc_shh_xsh_zhw2=request("txt_shh_xsh_zhw2")
tc_shh_xsh_zhw3=request("txt_shh_xsh_zhw3")
tc_shh_xsh_date1=request("txt_shh_xsh_date1")
tc_shh_xsh_date2=request("txt_shh_xsh_date2")
tc_shh_xsh_date3=request("txt_shh_xsh_date3")
tc_shh_xsh_name1=request("txt_shh_xsh_name1")
tc_shh_xsh_name2=request("txt_shh_xsh_name2")
tc_shh_xsh_name3=request("txt_shh_xsh_name3")
tc_shh_shh_zhw1=request("txt_shh_shh_zhw1")
tc_shh_shh_zhw2=request("txt_shh_shh_zhw2")
tc_shh_shh_zhw3=request("txt_shh_shh_zhw3")
tc_shh_shh_date1=request("txt_shh_shh_date1")
tc_shh_shh_date2=request("txt_shh_shh_date2")
tc_shh_shh_date3=request("txt_shh_shh_date3")
tc_shh_shh_name1=request("txt_shh_shh_name1")
tc_shh_shh_name2=request("txt_shh_shh_name2")
tc_shh_shh_name3=request("txt_shh_shh_name3")
tc_bzh=request("txt_bzh")
sqltxt="insert into tcinfor(tc_name,tc_sex,tc_birt,tc_indate,tc_code,tc_address,tc_zhy,tc_dw,tc_xl_bydate1,tc_xl_bydate2,tc_xl_bydate3,tc_xl_byschool1,tc_xl_byschool2,tc_xl_byschool3,tc_xl_zhy1,tc_xl_zhy2,tc_xl_zhy3,tc_work_jx,tc_work_ky,tc_work_xsh,tc_shh_xsh_zhw1,tc_shh_xsh_zhw2,tc_shh_xsh_zhw3,tc_shh_xsh_date1,tc_shh_xsh_date2,tc_shh_xsh_date3,tc_shh_xsh_name1,tc_shh_xsh_name2,tc_shh_xsh_name3,tc_shh_shh_zhw1,tc_shh_shh_zhw2,tc_shh_shh_zhw3,tc_shh_shh_date1,tc_shh_shh_date2,tc_shh_shh_date3,tc_shh_shh_name1,tc_shh_shh_name2,tc_shh_shh_name3,tc_bzh)"&_
"values('"&tc_name&"','"&tc_sex&"','"&tc_birt&"','"&tc_indate&"','"&tc_code&"','"&tc_address&"','"&tc_zhy&"','"&tc_dw&"','"&tc_xl_bydate1&"','"&tc_xl_bydate2&"','"&tc_xl_bydate3&"','"&tc_xl_byschool1&"','"&tc_xl_byschool2&"','"&tc_xl_byschool3&"','"&tc_xl_zhy1&"','"&tc_xl_zhy2&"','"&tc_xl_zhy3&"','"&tc_work_jx&"','"&tc_work_ky&"','"&tc_work_xsh&"','"&tc_shh_xsh_zhw1&"','"&tc_shh_xsh_zhw2&"','"&tc_shh_xsh_zhw3&"','"&tc_shh_xsh_date1&"','"&tc_shh_xsh_date2&"','"&tc_shh_xsh_date3&"','"&tc_shh_xsh_name1&"','"&tc_shh_xsh_name2&"','"&tc_shh_xsh_name3&"','"&tc_shh_shh_zhw1&"','"&tc_shh_shh_zhw2&"','"&tc_shh_shh_zhw3&"','"&tc_shh_shh_date1&"','"&tc_shh_shh_date2&"','"&tc_shh_shh_date3&"','"&tc_shh_shh_name1&"','"&tc_shh_shh_name2&"','"&tc_shh_shh_name3&"','"&tc_bzh&"')"
conn.execute(sqltxt)
response.Write "<script language=javascript>{window.alert('记录添加成功!');window.location.href='admin_writeto.asp';}</script>"
response.End()
%>