getresult.asp

在线考试系统

<!--#include file="conn.asp"-->
<!--#include file="Checkuser.asp"-->


<%

dim yijiao
yijiao=session("yijiao")
if yijiao=10 then
response.write "您是否按了浏览器上的后退按钮，你已经交过了试卷，请不要再按了。"
else

subjectname=session("selectsubjectname")
studentname=session("studentname")
singlenumber=session("singlenumber")
singleper=session("singleper")


multinumber=session("multinumber")
multiper=session("multiper")
endtime=now()
dq=session("dq")
score=0

if session("singlenumber")=0 then
selectstr1="    "
else
selectstr1=request.form("hidQuestID1")
End if
if session("multinumber")=0 then
selectstr2= "   "
else
selectstr2=request.form("hidQuestID2")
End if
'#############################
 


len1=len(selectstr1)
len2=len(selectstr2)
str1=left(selectstr1,len1-1)
str2=left(selectstr2,len2-1)

dim id1,id2
id1=split(str1,",")
id2=split(str2,",")

if singlenumber>0 then
for i=1 to singlenumber
 result=request.form("no"&id1(i-1))
 if  not isempty(result) then
      sql="select * from question where id="& clng(id1(i-1))
      set rs=server.createobject("adodb.recordset")
      rs.open sql,conn,3,2     
        if result=rs("answer") then
          score=score+cint(singleper)
        end if
        rs.close
        set rs=nothing 
  else
  end if
next
end if



if multinumber > 0 then        
for i=1 to multinumber
 result=request.form("no"&id2(i-1))
  if  not isempty(result) then
      sql="select * from question where id="& clng(id2(i-1))
      set rs=server.createobject("adodb.recordset")
      rs.open sql,conn,3,2     
        if result=rs("answer") then
          score=score+cint(multiper)
        end if   
        rs.close
        set rs=nothing 
  else
  end if
next 
end if

set rs=server.createobject("adodb.recordset")
sql="select Avg(score) as avgscore  from score where  name<>'' and subjectname='"&session("selectsubjectname")&"' "
rs.open sql,conn,3,2
session("avgscore")=rs("avgscore")



sql="select * from score where studentname='"&session("studentname")&"' and subjectname='"&session("selectsubjectname")&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs("endtime")=endtime
rs("score")=score
rs("name")=session("name")
rs("avgscore")=session("avgscore")
rs("dq")=dq
rs("dqq")=session("dqq")
rs.update
rs.close
set rs=nothing
call endConnection()
total=singlenumber*singleper+multinumber*multiper
session("score")=score
session("total")=total
session("yijiao")=1
response.redirect "result.asp"
'response.write("<center>"&studentname&"你好！你的考试成绩为："&score&"分，总分为"&total&"分</center><br>")
end if
%>