stu_modicjed.asp

学校成绩查询系统是一个非常好的软件请大家试试

<!--#include file="Admin_IsLogin.asp" -->
<!--#include file="dataconn.asp"-->
<%
testname=request.querystring("testname")
nj=request.querystring("nj")
bj=request.querystring("bj")
stuid=request.form("stuid")
subjectstr=request.Form("subjectstr")
subjectstr=left(subjectstr,len(subjectstr)-1)
subjecta=split(subjectstr,",")
subjectnum=request.form("subjectnum")
fs=0
for i=0 to subjectnum-1
subject=request.form("subject"&i)
if IsNumeric(subject) then
fs=fs+subject
end if
sql="update studentpmb set "&subjecta(i)&"='"&subject&"' where id="&stuid&""
conn.execute(sql)
next
conn.execute("update studentpmb set zf="&fs&" where id="&stuid&"")
response.write "<script>alert('修改成功！');location.href=""stu_cjpmhz.asp?testname="&testname&"&nj="&nj&"&bj="&bj&""";</Script>"

%>