热点排行

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

类别：.NET开发 点击：0 评论：0 推荐：

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

下面是本页面的全部代码

 

<!--#include file="../conn.asp"-->
<!--#include file="function.asp"-->
<!--#include file="checksession.asp"-->
<%
papername=requeststr("papername")'这个是我自己写的函数,相当于request.from()
address=requeststr("class")
%>
<html xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<title><%=papername&address&"试卷分析报告"%></title>
<script language="JavaScript">
self.moveTo(10,0)
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<LINK href="../css/body.css" rel=stylesheet type=text/css>
<STYLE>
 v\:* { BEHAVIOR: url(#default#VML) }
</STYLE>
<script>
function drawLines()
{
 var count=0;//画横坐标
 for(var i=0;i<=60;i++){
    var px=200+73*i;
    var newLine = document.createElement("<v:line from='"+px+" 200' to='"+px+" 3200' style='position:absolute;z-index:7'></v:line>");
    group1.insertBefore(newLine);
    if(count%5!=0){
     var newStroke = document.createElement("<v:stroke dashstyle='dot' color='black'/>");
     newLine.insertBefore(newStroke);
 }
 else
 {
     var newStroke = document.createElement("<v:stroke color='#babbae'>");
     newLine.insertBefore(newStroke);
 }
 count++;
 }
 count=0; //画纵坐标
 for(var i=0;i<=50;i++){
    var py=3200-50*i;
    var newLine = document.createElement("<v:line from='200 "+py+"' to='4650 "+py+"' style='position:absolute;z-index:7'></v:line>");
    group1.insertBefore(newLine);
 if(count%5!=0){
     var newStroke = document.createElement("<v:stroke dashstyle='dot' color='black'/>");
     newLine.insertBefore(newStroke);
 }
 else
 {
     var newStroke = document.createElement("<v:stroke color='#babbae' />");
     newLine.insertBefore(newStroke); 
 } 
 count++;
 }
for (var j=1;j<=10;j++)
{
    var h=200+j*430;
    var newLine = document.createElement("<v:line from='"+h+" 2450' to='"+h+" 2700' style='position:absolute;z-index:7'></v:line>");
    group2.insertBefore(newLine);

}
for (var k=1;k<=10;k++)
{
    var h=2650-k*200;
    var newLine = document.createElement("<v:line from='200 "+h+"' to='250 "+h+"' style='position:absolute;z-index:7'></v:line>");
    group2.insertBefore(newLine);

}
}
function drawBar(v,t)
{
if(v==0)
v=1
  var h1=v*50-50;
  var px1=2500-v*50;
  var py1=260+t*440;
  var 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>")   
  group2.insertBefore(newShape);
}
</script>
<style>
@media print {
    .ipt {display:none}
</style>
</head>

<body topmargin="0"  onload="drawLines()">
<div align="center" class="ipt">

            <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2">
  <tr>
    <th scope="col"><input name="保存报告" type="button" value="保存报告" onClick="if(!document.execCommand('SaveAs',0,1)) return false;"></th>
    <th scope="col"><input name="打印报告" type="button" value="打印报告" onClick="window.print()"></th>
    <th scope="col"><input name="关闭窗口" type="button" value="关闭窗口" onClick="window.self.close()"></th>

  </tr>
</table>
</div>
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" style="border-collapse: collapse">
  <tr>
    <td><table width="100%" border="0">
        <tr>
          <td></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td height="128"  axis="8"><div align="center">
        <p style="line-height: 250%"><font size="5"><b><%=papername%><br>试卷分析报告</b></font></p>
      </div><div align="left" style="width: 609; height: 132">
            <p style="line-height: 250%"><font size="3">班级：<%=address%></font>
              <%
 set rs=conn.execute("select * from analysislist where address='"&address&"' and papername='"&papername&"'")
%></p>
                <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#111111" id="AutoNumber1" style="border-collapse: collapse">
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">最高分：<%=rs("maxfen")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">最低分：<%=rs("minfen")%></font></td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">全&nbsp; 距：<%=rs("quanju")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">平均分：<%=rs("avgfen")%></font></td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">系统平均难度：<%=rs("difficulty")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">试卷平均难度系数：0<%=rs("nandu")%></font></td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">80-100分：<%=rs("duan1")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">60-79分：<%=rs("duan2")%></font></td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">0-59分：<%=rs("duan3")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%">　</td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">及格：<%=rs("duan1")+rs("duan2")%></font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">不及格：<%=rs("duan3")%></font></td>
          </tr>
          <tr>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">及格率：<%=rs("jigelv")%>%</font></td>
            <td width="50%" height="22">
            <p style="line-height: 200%"><font size="3">不及格率：<%=100-rs("jigelv")%>%</font></td>
          </tr>
        </table>
      <p><br>
              <font size="3">试卷难度系数曲线图：</font></p>
            <p>
              <%
  '描点数据读取
  set xzt=conn.execute("select nandu from analysis where q_type='选择题' and papername='"&papername&"' and address='"&address&"' order by questionid")
  set tkt=conn.execute("select nandu from analysis where q_type='填空题' and papername='"&papername&"'  and address='"&address&"' order by questionid")
  set pdt=conn.execute("select nandu from analysis where q_type='判断题' and papername='"&papername&"' and address='"&address&"'  order by questionid")
  set wdt=conn.execute("select nandu from analysis where q_type='问答题' and papername='"&papername&"' and address='"&address&"'  order by questionid")
  dim i,piont,t(61)
for x=1 to 60
t(x)=200+x*73
'response.Write (t(x)&"<br>")
next
  do while not xzt.eof
   i=i+1
   point=point&t(i)&","&(3200-xzt("nandu")*50*50)&" "
   xzt.movenext
  loop
  do while not tkt.eof
   i=i+1
   point=point&t(i)&","&(3200-tkt("nandu")*50*50)&" "
   tkt.movenext
  loop
  do while not pdt.eof
   i=i+1
   point=point&t(i)&","&(3200-pdt("nandu")*50*50)&" "
   pdt.movenext
  loop
  do while not wdt.eof
   i=i+1
   point=point&t(i)&","&(3200-wdt("nandu")*50*50)&" "
   wdt.movenext
  loop
  %>
            </p>
            <p>
   
<v:group ID="group1" style="WIDTH:500pt;HEIGHT:320pt;" coordsize="5000,3600">
  <v:line from="200,100" to="200,3200" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt">
  <v:stroke StartArrow="classic"/>
  </v:line>
  <v:line from="200,3200" to="4800,3200" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt">
  <v:stroke EndArrow="classic"/>
  </v:line>
  <v:rect style="WIDTH:4900px;HEIGHT:3400px" coordsize="21600,21600" fillcolor="white" strokecolor="black">
  <v:shadow on="t" type="single" color="silver" offset="4pt,3pt"></v:shadow>
  </v:rect>
  <v:polyLine id="poly1" style="POSITION:absolute;z-index:9" filled=f strokecolor=red strokeweight=1.5pt points="<%=point%>"/>
  <P id="p1" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:375px;HEIGHT:5.6pt;TEXT-ALIGN:center">0</P>
  <P id="p2" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:345px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.1</P>
  <P id="p3" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:315px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.2</P>
  <P id="p4" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:285px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.3</P>
  <P id="p5" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:255px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.4</P>
  <P id="p6" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:225px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.5</P>
  <P id="p7" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:195px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.6</P>
  <P id="p8" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:165px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.7</P>
  <P id="p9" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:135px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.8</P>
  <P id="p10" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:105px;HEIGHT:5.6pt;TEXT-ALIGN:center">0.9</P>
  <P id="p11" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:75px;HEIGHT:5.6pt;TEXT-ALIGN:center">1.0</P>
  <P id="p12" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:30px;HEIGHT:5.6pt;TEXT-ALIGN:center">难度</P>

  <P class="Chart" style="LEFT:70px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T6</P>
  <P class="Chart" style="LEFT:120px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T11</P>
  <P class="Chart" style="LEFT:170px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T16</P>
  <P class="Chart" style="LEFT:220px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T21</P>
  <P class="Chart" style="LEFT:270px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T26</P>
  <P class="Chart" style="LEFT:320px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T31</P>
  <P class="Chart" style="LEFT:365px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T36</P>
  <P class="Chart" style="LEFT:415px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T41</P>
  <P class="Chart" style="LEFT:460px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T46</P>
  <P class="Chart" style="LEFT:505px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T51</P>
  <P class="Chart" style="LEFT:555px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">T56</P>
  <P class="Chart" style="LEFT:600px;POSITION:absolute;TOP:380px;HEIGHT:5.6pt;TEXT-ALIGN:center">题号</P>
</v:group>
   </p>
       <font size="3">学生考试成绩发分布直方图：</font> <p>
    
<v:group id="group2" o:spid="_x0000_s1025" style='width:525pt;height:375pt'
 coordsize="4900,3500">
  <v:line from="200,100" to="200,2700" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt">
  <v:stroke StartArrow="classic"/>
  </v:line>
  <v:line from="200,2450" to="4500,2450" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt"></v:line>
   <v:line from="200,2575" to="4500,2575" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt"></v:line>

  <v:line from="200,2700" to="4500,2700" style="Z-INDEX:8;POSITION:absolute" strokeweight="1pt"></v:line>
  
 <v:rect id="_x0000_s1026" style='position:absolute;width:4600;height:2900'>
  <v:shadow on="t" color="silver" offset="4pt,3pt"/>
 </v:rect>
       <P id="p1" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:345px;HEIGHT:5.6pt;TEXT-ALIGN:center">0</P>
<P id="p2" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:316px;HEIGHT:5.6pt;TEXT-ALIGN:center">5</P>
<P id="p3" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:287px;HEIGHT:5.6pt;TEXT-ALIGN:center">10</P>
<P id="p4" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:258px;HEIGHT:5.6pt;TEXT-ALIGN:center">15</P>
<P id="p5" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:230px;HEIGHT:5.6pt;TEXT-ALIGN:center">20</P>
<P id="p6" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:201px;HEIGHT:5.6pt;TEXT-ALIGN:center">25</P>
<P id="p7" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:172px;HEIGHT:5.6pt;TEXT-ALIGN:center">30</P>
<P id="p8" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:143px;HEIGHT:5.6pt;TEXT-ALIGN:center">35</P>
<P id="p9" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:114px;HEIGHT:5.6pt;TEXT-ALIGN:center">40</P>
<P id="p10" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:85px;HEIGHT:5.6pt;TEXT-ALIGN:center">45</P>
<P id="p11" class="Chart" style="LEFT:5px;WIDTH:11.9pt;POSITION:absolute;TOP:56px;HEIGHT:5.6pt;TEXT-ALIGN:center">人数</P>

<P class="Chart" style="LEFT:55px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">--</P>
<P class="Chart" style="LEFT:110px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center"><20</P>
<P class="Chart" style="LEFT:170px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">20-29</P>
<P class="Chart" style="LEFT:230px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">30-39</P>
<P class="Chart" style="LEFT:290px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">40-49</P>
<P class="Chart" style="LEFT:350px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">50-59</P>
<P class="Chart" style="LEFT:410px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">60-69</P>
<P class="Chart" style="LEFT:470px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">70-79</P>
<P class="Chart" style="LEFT:530px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">80-89</P>
<P class="Chart" style="LEFT:590px;POSITION:absolute;TOP:355px;HEIGHT:5.6pt;TEXT-ALIGN:center">90-100</P>
<%
conn.execute("exec checkachievement '"&papername&"','"&address&"'")
set duan=conn.execute("select * from tempduanvalue")
%>
<script language="javascript">
drawBar(<%=duan("duan1")%>,1)
drawBar(<%=duan("duan2")%>,2)
drawBar(<%=duan("duan3")%>,3)
drawBar(<%=duan("duan4")%>,4)
drawBar(<%=duan("duan5")%>,5)
drawBar(<%=duan("duan6")%>,6)
drawBar(<%=duan("duan7")%>,7)
drawBar(<%=duan("duan8")%>,8)
drawBar(<%=duan("duan9")%>,9)
</script>
<P class="Chart" style="LEFT:55px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center">人数</P>
<P class="Chart" style="LEFT:110px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan1")%></P>
<P class="Chart" style="LEFT:170px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan2")%></P>
<P class="Chart" style="LEFT:230px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan3")%></P>
<P class="Chart" style="LEFT:290px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan4")%></P>
<P class="Chart" style="LEFT:350px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan5")%></P>
<P class="Chart" style="LEFT:410px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan6")%></P>
<P class="Chart" style="LEFT:470px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan7")%></P>
<P class="Chart" style="LEFT:530px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan8")%></P>
<P class="Chart" style="LEFT:590px;POSITION:absolute;TOP:372px;HEIGHT:5.6pt;TEXT-ALIGN:center"><%=duan("duan9")%></P>


</v:group><p></p>
 <font size="3"> 各题目详细信息: <br>
 </font>
            <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="94%" id="AutoNumber2">
              <tr>
                <td width="10%"><div align="center">题号</div></td>
                <td width="12%"><div align="center">题型</div></td>
                <td width="10%"><div align="center">分值</div></td>
                <td width="10%"><div align="center">最高分</div></td>
                <td width="12%"><div align="center">最低分</div></td>
                <td width="11%"><div align="center">平均分</div></td>
                <td width="12%"><div align="center">标准差</div></td>
                <td width="12%"><div align="center">难度</div></td>
                <td width="11%"><div align="center">系统难度</div></td>
              </tr>
     <%
     i=1
     set rsinfo=conn.execute("select * from analysis where papername='"&papername&"'  and q_type='选择题' and address='"&address&"' order by questionid")
     do while not rsinfo.eof
     %>
              <tr>
                <td width="10%"><div align="center"><%=i%></div></td>
                <td width="12%"><div align="center">选择题</div></td>
                <td width="10%"><div align="center">2</div></td>
                <td width="10%"><div align="center"><%=rsinfo("maxfen")%></div></td>
                <td width="12%"><div align="center"><%=rsinfo("minfen")%></div></td>
                <td width="11%"><div align="center"><%=rsinfo("avgfen")%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("tmstdev")<1 and rsinfo("tmstdev")>0 then response.Write("0"&left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("nandu")<1 and rsinfo("nandu")>0 then response.Write("0"&rsinfo("nandu")) else response.Write(rsinfo("nandu")) %></div></td>
                <td width="11%"><div align="center">
                  <%=(rsinfo("difficulty")) %>
                </div></td>
              </tr>
     <%
     i=i+1
     rsinfo.movenext
     loop
     set rsinfo=nothing
     %>
       <%
     set rsinfo=conn.execute("select * from analysis where papername='"&papername&"' and address='"&address&"' and q_type='填空题' order by questionid")
     do while not rsinfo.eof
     %>
              <tr>
                <td width="10%"><div align="center"><%=i%></div></td>
                <td width="12%"><div align="center">填空题</div></td>
                <td width="10%"><div align="center">2</div></td>
                <td width="10%"><div align="center"><%=rsinfo("maxfen")%></div></td>
                <td width="12%"><div align="center"><%=rsinfo("minfen")%></div></td>
                <td width="11%"><div align="center"><%=rsinfo("avgfen")%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("tmstdev")<1 and rsinfo("tmstdev")>0 then response.Write("0"&left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("nandu")<1 and rsinfo("nandu")>0 then response.Write("0"&rsinfo("nandu")) else response.Write(rsinfo("nandu")) %></div></td>
                <td width="11%"><div align="center"><%=(rsinfo("difficulty")) %></div></td>
              </tr>
     <%
     i=i+1
     rsinfo.movenext
     loop
     set rsinfo=nothing
     %>
       <%
     set rsinfo=conn.execute("select * from analysis where papername='"&papername&"' and address='"&address&"' and q_type='判断题' order by questionid")
     do while not rsinfo.eof
     %>
              <tr>
                <td width="10%"><div align="center"><%=i%></div></td>
                <td width="12%"><div align="center">判断题</div></td>
                <td width="10%"><div align="center">1</div></td>
                <td width="10%"><div align="center"><%=rsinfo("maxfen")%></div></td>
                <td width="12%"><div align="center"><%=rsinfo("minfen")%></div></td>
                <td width="11%"><div align="center"><%=rsinfo("avgfen")%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("tmstdev")<1 and rsinfo("tmstdev")>0 then response.Write("0"&left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("nandu")<1 and rsinfo("nandu")>0 then response.Write("0"&rsinfo("nandu")) else response.Write(rsinfo("nandu")) %></div></td>
                <td width="11%"><div align="center"><%=(rsinfo("difficulty")) %></div></td>
              </tr>
     <%
     i=i+1
     rsinfo.movenext
     loop
     set rsinfo=nothing
     %>
       <%
     set rsinfo=conn.execute("select * from analysis where papername='"&papername&"' and address='"&address&"' and q_type='问答题' order by questionid")
     do while not rsinfo.eof
     %>
              <tr>
                <td width="10%"><div align="center"><%=i%></div></td>
                <td width="12%"><div align="center">问答题</div></td>
                <td width="10%"><div align="center">10</div></td>
                <td width="10%"><div align="center"><%=rsinfo("maxfen")%></div></td>
                <td width="12%"><div align="center"><%=rsinfo("minfen")%></div></td>
                <td width="11%"><div align="center"><%=rsinfo("avgfen")%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("tmstdev")<1 and rsinfo("tmstdev")>0 then response.Write("0"&left(rsinfo("tmstdev"),3)) else response.Write(left(rsinfo("tmstdev"),4))%></div></td>
                <td width="12%"><div align="center"><%if rsinfo("nandu")<1 and rsinfo("nandu")>0 then response.Write("0"&rsinfo("nandu")) else response.Write(rsinfo("nandu")) %></div></td>
                <td width="11%"><div align="center"><%=(rsinfo("difficulty")) %></div></td>
              </tr>
     <%
     i=i+1
     rsinfo.movenext
     loop
     set rsinfo=nothing
     %>
            </table>
            <p>&nbsp;</p>
      </div></td>
  </tr>
</table>

  </center><br>
</div>
</body>
</html>

本文地址：http://com.8s8s.com/it/it44585.htm

Copyright © 2004-2013 信息技术中文网 All rights reserved 版权所有

Powered by 信息技术中文网 Ver2.0