updepartment.asp

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

<!--#include file="a25175_conn.asp"-->
<%
dim id,depart,showid
showid=trim(request("showid"))
depart=trim(request("depart"))
id=trim(request("id"))
if id="" then
response.write"<script>alert('不要错误操作！');location='adddepart.asp'</script>"	
else
 				strsql="select * from department where SHOWID="&showid
  	            set rs=db.execute(strsql)
   			 	if not rs.eof then
   			 	response.write"<script>alert('已经有此显示顺序的院系了，请更换显示顺序！');location='adddepart.asp'</script>"
   			 	response.End()
    			end if
				'不能更换相同的院系
strsql="update department set department='"&depart&"',showid="&showid&" where id="&id
db.execute(strsql)
response.write"<script>alert('修改成功！');location='adddepart.asp'</script>"	
end if
%>