editt1.asp

一个人事管理系统

<!--#include file="data1.asp"-->
<%
dim sql
dim rs
id=request.form("id")
name=request.form("xming")
sql="update 情况 set 姓名='"&name&"',性别='"&request.form("sex")&"',生日='"&request.form("birth")&"',面貌='"&request.form("mm")&"',学校='"&request.form("xx")&"',毕业='"&request.form("by")&"',专业='"&request.form("zy")&"',学位='"&request.form("xw")&"',时间='"&request.form("time0")&"',科目='"&request.form("sub1")&"',职称='"&request.form("zc")&"',职务='"&request.form("zw")&"',隶属='"&request.form("ls")&"',奖惩='"&request.form("jc")&"',培训='"&request.form("px")&"',登记='"&request.form("time2")&"'  where id ="&id&""
SET RS=CONN.EXECUTE(SQL)
%>
<script language="javaScript">
alert ("<%=name%>\n\n修改成功！")
	location.href ="techer.asp"
</script>