admin_editok.asp

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

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="tcconn.asp" -->
<%
if request.Cookies("flag")<>"loginok" and request.Cookies("flag")<>"teacher"  then
response.write "<script language=JavaScript>{window.alert('网络超时或你还未登录，请重新登陆!');window.location.href='index.htm';}</script>"
response.end
end if
tc_id=request("id")
if tc_id="" then
response.write "来源未知或数据丢失!"
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
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="update tcinfor set tc_name='"&tc_name&"',tc_sex='"&tc_sex&"',tc_birt='"&tc_birt&"',tc_indate='"&tc_indate&"',tc_code='"&tc_code&"',tc_address='"&tc_address&"',tc_zhy='"&tc_zhy&"',tc_dw='"&tc_dw&"',tc_xl_bydate1='"&tc_xl_bydate1&"',tc_xl_bydate2='"&tc_xl_bydate2&"',tc_xl_bydate3='"&tc_xl_bydate3&"',tc_xl_byschool1='"&tc_xl_byschool1&"',tc_xl_byschool2='"&tc_xl_byschool2&"',tc_xl_byschool3='"&tc_xl_byschool3&"',tc_xl_zhy1='"&tc_xl_zhy1&"',tc_xl_zhy2='"&tc_xl_zhy2&"',tc_xl_zhy3='"&tc_xl_zhy3&"',tc_work_jx='"&tc_work_jx&"',tc_work_ky='"&tc_work_ky&"',tc_work_xsh='"&tc_work_xsh&"',tc_shh_xsh_zhw1='"&tc_shh_xsh_zhw1&"',tc_shh_xsh_zhw2='"&tc_shh_xsh_zhw2&"',"&_
"tc_shh_xsh_zhw3='"&tc_shh_xsh_zhw3&"',tc_shh_xsh_date1='"&tc_shh_xsh_date1&"',tc_shh_xsh_date2='"&tc_shh_xsh_date2&"',tc_shh_xsh_date3='"&tc_shh_xsh_date3&"',tc_shh_xsh_name1='"&tc_shh_xsh_name1&"',tc_shh_xsh_name2='"&tc_shh_xsh_name2&"',tc_shh_xsh_name3='"&tc_shh_xsh_name3&"',tc_shh_shh_zhw1='"&tc_shh_shh_zhw1&"',tc_shh_shh_zhw2='"&tc_shh_shh_zhw2&"',tc_shh_shh_zhw3='"&tc_shh_shh_zhw3&"',tc_shh_shh_date1='"&tc_shh_shh_date1&"',tc_shh_shh_date2='"&tc_shh_shh_date2&"',tc_shh_shh_date3='"&tc_shh_shh_date3&"',tc_shh_shh_name1='"&tc_shh_shh_name1&"',tc_shh_shh_name2='"&tc_shh_shh_name2&"',tc_shh_shh_name3='"&tc_shh_shh_name3&"',tc_bzh='"&tc_bzh&"' where tc_id="&tc_id&""
conn.execute(sqltxt)
if request.Cookies("flag")="teacher" then
response.Write "<script language=javascript>{window.alert('记录修改成功!');window.self.close();}</script>"
response.End()
end if
response.Write "<script language=javascript>{window.alert('记录修改成功!');window.location.href='admin_search.asp';}</script>"
response.End()
%>