userimok.asp

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

<!--#include file="a25175_conn.asp"-->
<%
UserID=request("UserID")
password=trim(request.Form("password"))
depart=trim(request.Form("addone_id"))
class1=trim(request.Form("addtwo_id"))
typed=trim(request.Form("typed"))
departok=request.Form("departok")

'------------------------------------------
if depart<>"请选择教师院系" then
strsql="select * from department where id="&depart
set rs=db.execute(strsql)
depart=rs("department")
end if
if class1<>"—学院督导—" and class1<>"—学院领导—" then
strsql="select * from class where id="&class1
set rs=db.execute(strsql)
class1=rs("classname")
end if

'---------------------------------------
'------------------------------------------------------------
strsql="Update UserInfo set password='"&password&"',typed="&typed&" where username='"&userID&"'"
if departok=1 then
strsql="Update UserInfo set password='"&password&"',typed="&typed&",depart='"&depart&"',class1='"&class1&"' where username='"&userID&"'"
end if
db.execute(strsql)
response.write"<script>alert('修改成功\n刷新网页查看')</script>"
response.write"<script>window.close()</script>"

%>