upteacher.asp

学生管理功能: 1.添加单个成绩 2.批量添加成绩 3.通过搜索并修改与删除

<!--#include file="a25175_conn.asp"-->
<%
	
	depart=trim(request.Form("depart"))	
	TEACHER=trim(request.Form("TEACHER"))
	showID=trim(request.Form("ShowID"))
	ID=trim(request.Form("ID"))
	TEACHERNUMBER=trim(request.Form("TEACHERNUMBER"))
	TEL=trim(request.Form("TEL"))
	IP=REQUEST.ServerVariables("REMOTE_ADDR")
	strsql="select * from department where department='"&depart&"'"
  	set rs=db.execute(strsql)
	departID=rs("id")
strsql="update TEACHER set depart='"&depart&"',showid="&showid&",TEACHERNAME='"&TEACHER&"',DEPARTID="&DEPARTID&",NUM='"&TEACHERNUMBER&"',TEL='"&TEL&"' where id="&id

db.execute(strsql)
response.write"<script>alert('修改教师成功！');location='addteacher.asp'</script>"	

%>