用VML技术实现统计图形的绘制(考试系统中的试卷分析模块)

这个地方我们用VML来显示试卷的难度系数的波动曲线图

下面是本页面的全部代码


1   
2papername=requeststr("papername")'这个是我自己写的函数,相当于request.from()   
3address=requeststr("class")   
  1<html xmlns:v="urn:schemas-microsoft-com:vml">
  2<head>
  3<title>```
  4=papername&amp;amp;address&amp;amp;"试卷分析报告"
  5```</title>
  6<script language="JavaScript">   
  7self.moveTo(10,0)   
  8</script>
  9<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
 10<link href="../css/body.css" rel="stylesheet" type="text/css"/>
 11<style>   
 12v\:* { BEHAVIOR: url(#default#VML) }   
 13</style>
 14<script>   
 15function drawLines()   
 16{   
 17var count=0;//画横坐标   
 18for(var i=0;i<=60;i++){   
 19var px=200+73*i;   
 20var newLine = document.createElement("<v:line from='"+px+" 200' to='"+px+" 3200' style='position:absolute;z-index:7'></v:line>");   
 21group1.insertBefore(newLine);   
 22if(count%5!=0){   
 23var newStroke = document.createElement("<v:stroke dashstyle='dot' color='black'/>");   
 24newLine.insertBefore(newStroke);   
 25}   
 26else   
 27{   
 28var newStroke = document.createElement("<v:stroke color='#babbae'>");   
 29newLine.insertBefore(newStroke);   
 30}   
 31count++;   
 32}   
 33count=0; //画纵坐标   
 34for(var i=0;i<=50;i++){   
 35var py=3200-50*i;   
 36var newLine = document.createElement("<v:line from='200 "+py+"' to='4650 "+py+"' style='position:absolute;z-index:7'></v:line>");   
 37group1.insertBefore(newLine);   
 38if(count%5!=0){   
 39var newStroke = document.createElement("<v:stroke dashstyle='dot' color='black'/>");   
 40newLine.insertBefore(newStroke);   
 41}   
 42else   
 43{   
 44var newStroke = document.createElement("<v:stroke color='#babbae' />");   
 45newLine.insertBefore(newStroke);   
 46}   
 47count++;   
 48}   
 49for (var j=1;j<=10;j++)   
 50{   
 51var h=200+j*430;   
 52var newLine = document.createElement("<v:line from='"+h+" 2450' to='"+h+" 2700' style='position:absolute;z-index:7'></v:line>");   
 53group2.insertBefore(newLine); 
 54
 55}   
 56for (var k=1;k<=10;k++)   
 57{   
 58var h=2650-k*200;   
 59var newLine = document.createElement("<v:line from='200 "+h+"' to='250 "+h+"' style='position:absolute;z-index:7'></v:line>");   
 60group2.insertBefore(newLine); 
 61
 62}   
 63}   
 64function drawBar(v,t)   
 65{   
 66if(v==0)   
 67v=1   
 68var h1=v*50-50;   
 69var px1=2500-v*50;   
 70var py1=260+t*440;   
 71var newShape= document.createElement("<v:rect style='position:absolute;left:"+py1+";top:"+px1+";WIDTH:190px;HEIGHT:"+h1+"px;z-index:9' coordsize='21600,21600' fillcolor='blue'></v:rect>")   
 72group2.insertBefore(newShape);   
 73}   
 74</script>
 75<style>   
 76@media print {   
 77.ipt {display:none}   
 78</style>
 79</head>
 80<body onload="drawLines()" topmargin="0">
 81<div align="center" class="ipt">
 82<table border="1" bordercolor="#111111" cellpadding="0" cellspacing="0" id="AutoNumber2" style="border-collapse: collapse" width="100%">
 83<tr>
 84<th scope="col"><input name="保存报告" onclick="if(!document.execCommand('SaveAs',0,1)) return false;" type="button" value="保存报告"/></th>
 85<th scope="col"><input name="打印报告" onclick="window.print()" type="button" value="打印报告"/></th>
 86<th scope="col"><input name="关闭窗口" onclick="window.self.close()" type="button" value="关闭窗口"/></th>
 87</tr>
 88</table>
 89</div>
 90<table align="center" border="0" bordercolor="#111111" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="780">
 91<tr>
 92<td><table border="0" width="100%">
 93<tr>
 94<td></td>
 95</tr>
 96</table></td>
 97</tr>
 98<tr>
 99<td axis="8" height="128"><div align="center">
100<p style="line-height: 250%"><font size="5"><b>```
101=papername
102```<br/>试卷分析报告</b></font></p>
103</div><div align="left" style="width: 609; height: 132">
104<p style="line-height: 250%"><font size="3">班级:```
105=address
106```</font>   

set rs=conn.execute("select * from analysislist where address='"&amp;address&amp;"' and papername='"&amp;papername&amp;"'")

 1<table align="center" border="0" bordercolor="#111111" cellpadding="0" cellspacing="0" id="AutoNumber1" style="border-collapse: collapse" width="100%">
 2<tr>
 3<td height="22" width="50%">
 4<p style="line-height: 200%"><font size="3">最高分:```
 5=rs("maxfen")
 6```</font></p></td>
 7<td height="22" width="50%">
 8<p style="line-height: 200%"><font size="3">最低分:```
 9=rs("minfen")
10```</font></p></td>
11</tr>
12<tr>
13<td height="22" width="50%">
14<p style="line-height: 200%"><font size="3">全  距:```
15=rs("quanju")
16```</font></p></td>
17<td height="22" width="50%">
18<p style="line-height: 200%"><font size="3">平均分:```
19=rs("avgfen")
20```</font></p></td>
21</tr>
22<tr>
23<td height="22" width="50%">
24<p style="line-height: 200%"><font size="3">系统平均难度:```
25=rs("difficulty")
26```</font></p></td>
27<td height="22" width="50%">
28<p style="line-height: 200%"><font size="3">试卷平均难度系数:0```
29=rs("nandu")
30```</font></p></td>
31</tr>
32<tr>
33<td height="22" width="50%">
34<p style="line-height: 200%"><font size="3">80-100分:```
35=rs("duan1")
36```</font></p></td>
37<td height="22" width="50%">
38<p style="line-height: 200%"><font size="3">60-79分:```
39=rs("duan2")
40```</font></p></td>
41</tr>
42<tr>
43<td height="22" width="50%">
44<p style="line-height: 200%"><font size="3">0-59分:```
45=rs("duan3")
46```</font></p></td>
47<td height="22" width="50%">
48<p style="line-height: 200%"> </p></td>
49</tr>
50<tr>
51<td height="22" width="50%">
52<p style="line-height: 200%"><font size="3">及格:```
53=rs("duan1")+rs("duan2")
54```</font></p></td>
55<td height="22" width="50%">
56<p style="line-height: 200%"><font size="3">不及格:```
57=rs("duan3")
58```</font></p></td>
59</tr>
60<tr>
61<td height="22" width="50%">
62<p style="line-height: 200%"><font size="3">及格率:```
63=rs("jigelv")
64```%</font></p></td>
65<td height="22" width="50%">
66<p style="line-height: 200%"><font size="3">不及格率:```
67=100-rs("jigelv")
68```%</font></p></td>
69</tr>
70</table>
71<p><br/>
72<font size="3">试卷难度系数曲线图:</font></p>
73<p>   

'描点数据读取
set xzt=conn.execute("select nandu from analysis where q_type='选择题' and papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' order by questionid")
set tkt=conn.execute("select nandu from analysis where q_type='填空题' and papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' order by questionid")
set pdt=conn.execute("select nandu from analysis where q_type='判断题' and papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' order by questionid")
set wdt=conn.execute("select nandu from analysis where q_type='问答题' and papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' order by questionid")
dim i,piont,t(61)
for x=1 to 60
t(x)=200+x*73
'response.Write (t(x)&amp;"<br/>")
next
do while not xzt.eof
i=i+1
point=point&amp;t(i)&amp;","&amp;(3200-xzt("nandu")5050)&amp;" "
xzt.movenext
loop
do while not tkt.eof
i=i+1
point=point&amp;t(i)&amp;","&amp;(3200-tkt("nandu")5050)&amp;" "
tkt.movenext
loop
do while not pdt.eof
i=i+1
point=point&amp;t(i)&amp;","&amp;(3200-pdt("nandu")5050)&amp;" "
pdt.movenext
loop
do while not wdt.eof
i=i+1
point=point&amp;t(i)&amp;","&amp;(3200-wdt("nandu")5050)&amp;" "
wdt.movenext
loop

 1</p>
 2<p>
 3<v:group coordsize="5000,3600" id="group1" style="WIDTH:500pt;HEIGHT:320pt;">
 4<v:line from="200,100" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="200,3200">
 5<v:stroke startarrow="classic"></v:stroke>
 6</v:line>
 7<v:line from="200,3200" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="4800,3200">
 8<v:stroke endarrow="classic"></v:stroke>
 9</v:line>
10<v:rect coordsize="21600,21600" fillcolor="white" strokecolor="black" style="WIDTH:4900px;HEIGHT:3400px">
11<v:shadow color="silver" offset="4pt,3pt" on="t" type="single"></v:shadow>
12</v:rect>
13<v:polyline filled="f" id="poly1" points="```
14=point
15```" strokecolor="red" strokeweight="1.5pt" style="POSITION:absolute;z-index:9"></v:polyline>
16<p class="Chart" id="p1" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:375px;HEIGHT:5.6pt;TEXT-ALIGN:center">0</p>
17<p class="Chart" id="p2" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:345px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.1</p>
18<p class="Chart" id="p3" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:315px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.2</p>
19<p class="Chart" id="p4" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:285px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.3</p>
20<p class="Chart" id="p5" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:255px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.4</p>
21<p class="Chart" id="p6" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:225px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.5</p>
22<p class="Chart" id="p7" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:195px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.6</p>
23<p class="Chart" id="p8" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:165px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.7</p>
24<p class="Chart" id="p9" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:135px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.8</p>
25<p class="Chart" id="p10" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:105px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.9</p>
26<p class="Chart" id="p11" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:75px;HEIGHT:5.6pt;TEXT-ALIGN:center">1.0</p>
27<p class="Chart" id="p12" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:30px;HEIGHT:5.6pt;TEXT-ALIGN:center">难度</p>
28<p class="Chart" style="LEFT:70px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T6</p>
29<p class="Chart" style="LEFT:120px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T11</p>
30<p class="Chart" style="LEFT:170px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T16</p>
31<p class="Chart" style="LEFT:220px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T21</p>
32<p class="Chart" style="LEFT:270px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T26</p>
33<p class="Chart" style="LEFT:320px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T31</p>
34<p class="Chart" style="LEFT:365px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T36</p>
35<p class="Chart" style="LEFT:415px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T41</p>
36<p class="Chart" style="LEFT:460px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T46</p>
37<p class="Chart" style="LEFT:505px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T51</p>
38<p class="Chart" style="LEFT:555px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T56</p>
39<p class="Chart" style="LEFT:600px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">题号</p>
40</v:group>
41</p>
42<font size="3">学生考试成绩发分布直方图:</font> <p>
43<v:group coordsize="4900,3500" id="group2" o:spid="_x0000_s1025" style="width:525pt;height:375pt">
44<v:line from="200,100" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="200,2700">
45<v:stroke startarrow="classic"></v:stroke>
46</v:line>
47<v:line from="200,2450" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="4500,2450"></v:line>
48<v:line from="200,2575" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="4500,2575"></v:line>
49<v:line from="200,2700" strokeweight="1pt" style="Z-INDEX:8;POSITION:absolute" to="4500,2700"></v:line>
50<v:rect id="_x0000_s1026" style="position:absolute;width:4600;height:2900">
51<v:shadow color="silver" offset="4pt,3pt" on="t"></v:shadow>
52</v:rect>
53<p class="Chart" id="p1" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:345px;HEIGHT:5.6pt;TEXT-ALIGN:center">0</p>
54<p class="Chart" id="p2" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:316px;HEIGHT:5.6pt;TEXT-ALIGN:center">5</p>
55<p class="Chart" id="p3" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:287px;HEIGHT:5.6pt;TEXT-ALIGN:center">10</p>
56<p class="Chart" id="p4" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:258px;HEIGHT:5.6pt;TEXT-ALIGN:center">15</p>
57<p class="Chart" id="p5" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:230px;HEIGHT:5.6pt;TEXT-ALIGN:center">20</p>
58<p class="Chart" id="p6" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:201px;HEIGHT:5.6pt;TEXT-ALIGN:center">25</p>
59<p class="Chart" id="p7" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:172px;HEIGHT:5.6pt;TEXT-ALIGN:center">30</p>
60<p class="Chart" id="p8" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:143px;HEIGHT:5.6pt;TEXT-ALIGN:center">35</p>
61<p class="Chart" id="p9" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:114px;HEIGHT:5.6pt;TEXT-ALIGN:center">40</p>
62<p class="Chart" id="p10" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:85px;HEIGHT:5.6pt;TEXT-ALIGN:center">45</p>
63<p class="Chart" id="p11" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:56px;HEIGHT:5.6pt;TEXT-ALIGN:center">人数</p>
64<p class="Chart" style="LEFT:55px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">\--</p>
65<p class="Chart" style="LEFT:110px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">&lt;20</p>
66<p class="Chart" style="LEFT:170px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">20-29</p>
67<p class="Chart" style="LEFT:230px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">30-39</p>
68<p class="Chart" style="LEFT:290px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">40-49</p>
69<p class="Chart" style="LEFT:350px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">50-59</p>
70<p class="Chart" style="LEFT:410px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">60-69</p>
71<p class="Chart" style="LEFT:470px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">70-79</p>
72<p class="Chart" style="LEFT:530px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">80-89</p>
73<p class="Chart" style="LEFT:590px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">90-100</p>   

conn.execute("exec checkachievement '"&amp;papername&amp;"','"&amp;address&amp;"'")
set duan=conn.execute("select * from tempduanvalue")

 1<script language="javascript">   
 2drawBar(```
 3=duan("duan1")
 4```,1)   
 5drawBar(```
 6=duan("duan2")
 7```,2)   
 8drawBar(```
 9=duan("duan3")
10```,3)   
11drawBar(```
12=duan("duan4")
13```,4)   
14drawBar(```
15=duan("duan5")
16```,5)   
17drawBar(```
18=duan("duan6")
19```,6)   
20drawBar(```
21=duan("duan7")
22```,7)   
23drawBar(```
24=duan("duan8")
25```,8)   
26drawBar(```
27=duan("duan9")
28```,9)   
29</script>
30<p class="Chart" style="LEFT:55px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">人数</p>
31<p class="Chart" style="LEFT:110px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
32=duan("duan1")
33```</p>
34<p class="Chart" style="LEFT:170px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
35=duan("duan2")
36```</p>
37<p class="Chart" style="LEFT:230px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
38=duan("duan3")
39```</p>
40<p class="Chart" style="LEFT:290px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
41=duan("duan4")
42```</p>
43<p class="Chart" style="LEFT:350px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
44=duan("duan5")
45```</p>
46<p class="Chart" style="LEFT:410px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
47=duan("duan6")
48```</p>
49<p class="Chart" style="LEFT:470px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
50=duan("duan7")
51```</p>
52<p class="Chart" style="LEFT:530px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
53=duan("duan8")
54```</p>
55<p class="Chart" style="LEFT:590px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">```
56=duan("duan9")
57```</p>
58</v:group><p></p>
59<font size="3"> 各题目详细信息: <br/>
60</font>
61<table border="1" bordercolor="#111111" cellpadding="0" cellspacing="0" id="AutoNumber2" style="border-collapse: collapse" width="94%">
62<tr>
63<td width="10%"><div align="center">题号</div></td>
64<td width="12%"><div align="center">题型</div></td>
65<td width="10%"><div align="center">分值</div></td>
66<td width="10%"><div align="center">最高分</div></td>
67<td width="12%"><div align="center">最低分</div></td>
68<td width="11%"><div align="center">平均分</div></td>
69<td width="12%"><div align="center">标准差</div></td>
70<td width="12%"><div align="center">难度</div></td>
71<td width="11%"><div align="center">系统难度</div></td>
72</tr>   

i=1
set rsinfo=conn.execute("select * from analysis where papername='"&amp;papername&amp;"' and q_type='选择题' and address='"&amp;address&amp;"' order by questionid")
do while not rsinfo.eof

 1<tr>
 2<td width="10%"><div align="center">```
 3=i
 4```</div></td>
 5<td width="12%"><div align="center">选择题</div></td>
 6<td width="10%"><div align="center">2</div></td>
 7<td width="10%"><div align="center">```
 8=rsinfo("maxfen")
 9```</div></td>
10<td width="12%"><div align="center">```
11=rsinfo("minfen")
12```</div></td>
13<td width="11%"><div align="center">```
14=rsinfo("avgfen")
15```</div></td>
16<td width="12%"><div align="center">```
17if rsinfo("tmstdev")&amp;lt;1 and rsinfo("tmstdev")&amp;gt;0 then response.Write("0"&amp;amp;left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))
18```</div></td>
19<td width="12%"><div align="center">```
20if rsinfo("nandu")&amp;lt;1 and rsinfo("nandu")&amp;gt;0 then response.Write("0"&amp;amp;rsinfo("nandu")) else response.Write(rsinfo("nandu")) 
21```</div></td>
22<td width="11%"><div align="center">   

=(rsinfo("difficulty"))

1</div></td>
2</tr>   

i=i+1
rsinfo.movenext
loop
set rsinfo=nothing

set rsinfo=conn.execute("select * from analysis where papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' and q_type='填空题' order by questionid")
do while not rsinfo.eof

 1<tr>
 2<td width="10%"><div align="center">```
 3=i
 4```</div></td>
 5<td width="12%"><div align="center">填空题</div></td>
 6<td width="10%"><div align="center">2</div></td>
 7<td width="10%"><div align="center">```
 8=rsinfo("maxfen")
 9```</div></td>
10<td width="12%"><div align="center">```
11=rsinfo("minfen")
12```</div></td>
13<td width="11%"><div align="center">```
14=rsinfo("avgfen")
15```</div></td>
16<td width="12%"><div align="center">```
17if rsinfo("tmstdev")&amp;lt;1 and rsinfo("tmstdev")&amp;gt;0 then response.Write("0"&amp;amp;left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))
18```</div></td>
19<td width="12%"><div align="center">```
20if rsinfo("nandu")&amp;lt;1 and rsinfo("nandu")&amp;gt;0 then response.Write("0"&amp;amp;rsinfo("nandu")) else response.Write(rsinfo("nandu")) 
21```</div></td>
22<td width="11%"><div align="center">```
23=(rsinfo("difficulty")) 
24```</div></td>
25</tr>   

i=i+1
rsinfo.movenext
loop
set rsinfo=nothing

set rsinfo=conn.execute("select * from analysis where papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' and q_type='判断题' order by questionid")
do while not rsinfo.eof

 1<tr>
 2<td width="10%"><div align="center">```
 3=i
 4```</div></td>
 5<td width="12%"><div align="center">判断题</div></td>
 6<td width="10%"><div align="center">1</div></td>
 7<td width="10%"><div align="center">```
 8=rsinfo("maxfen")
 9```</div></td>
10<td width="12%"><div align="center">```
11=rsinfo("minfen")
12```</div></td>
13<td width="11%"><div align="center">```
14=rsinfo("avgfen")
15```</div></td>
16<td width="12%"><div align="center">```
17if rsinfo("tmstdev")&amp;lt;1 and rsinfo("tmstdev")&amp;gt;0 then response.Write("0"&amp;amp;left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))
18```</div></td>
19<td width="12%"><div align="center">```
20if rsinfo("nandu")&amp;lt;1 and rsinfo("nandu")&amp;gt;0 then response.Write("0"&amp;amp;rsinfo("nandu")) else response.Write(rsinfo("nandu")) 
21```</div></td>
22<td width="11%"><div align="center">```
23=(rsinfo("difficulty")) 
24```</div></td>
25</tr>   

i=i+1
rsinfo.movenext
loop
set rsinfo=nothing

set rsinfo=conn.execute("select * from analysis where papername='"&amp;papername&amp;"' and address='"&amp;address&amp;"' and q_type='问答题' order by questionid")
do while not rsinfo.eof

 1<tr>
 2<td width="10%"><div align="center">```
 3=i
 4```</div></td>
 5<td width="12%"><div align="center">问答题</div></td>
 6<td width="10%"><div align="center">10</div></td>
 7<td width="10%"><div align="center">```
 8=rsinfo("maxfen")
 9```</div></td>
10<td width="12%"><div align="center">```
11=rsinfo("minfen")
12```</div></td>
13<td width="11%"><div align="center">```
14=rsinfo("avgfen")
15```</div></td>
16<td width="12%"><div align="center">```
17if rsinfo("tmstdev")&amp;lt;1 and rsinfo("tmstdev")&amp;gt;0 then response.Write("0"&amp;amp;left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))
18```</div></td>
19<td width="12%"><div align="center">```
20if rsinfo("nandu")&amp;lt;1 and rsinfo("nandu")&amp;gt;0 then response.Write("0"&amp;amp;rsinfo("nandu")) else response.Write(rsinfo("nandu")) 
21```</div></td>
22<td width="11%"><div align="center">```
23=(rsinfo("difficulty")) 
24```</div></td>
25</tr>   

i=i+1
rsinfo.movenext
loop
set rsinfo=nothing

1</table>
2<p> </p>
3</p></div></td>
4</tr>
5</table>
6<br/>
7
8</body>
9</html>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus