⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 test_tj.jsp

📁 这个是我同学做的
💻 JSP
字号:
🔍 
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page  import="java.sql.ResultSet"%>
<html>
<head>
<%int ckr=0;
  int hight=0;
  int hight1=0;
  int hight2=0;
  int low=0;
  int rowcount=0;
  int zf=0;
  int i=0;
 int j=0,k=0,m=0,n=0,p=0;
 int fenshu=0;
  
 %>

<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>

<body topmargin="0" leftmargin="0">

<p>
<p align="center"><font class=test1>成绩统计管理</font></p>
<div align="center">
  <center>
  <table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
    <tr>
 <%request.setCharacterEncoding("GBK");
    response.setCharacterEncoding("GBK");
   int id1=Integer.parseInt(request.getParameter("qid"));
     DBConn db=new DBConn();
     String sql="select * from chengji where id1='"+id1+"'";
      ResultSet rs=db.Query(sql);
    while(rs.next()){
      i++;
      fenshu=rs.getInt("fenshu");
      zf=fenshu+zf;
    if(fenshu>90){
      j++;
      }
     else if(fenshu>80 && fenshu<=90){
      k++;
      }
   else if(fenshu>70 && fenshu<=79){
      m++;
      }
    else if(fenshu>60 && (fenshu<=70)){
      n++;
      }
   else{
      p++;
      }
      }%>
 <% String sql3="select * from chengji  where id1='"+id1+"' ";
      ResultSet rs2=db.Query(sql3);
       rs2.last();
      rowcount=rs2.getRow(); 
      
      %>
      
 <% String sql2="select * from chengji  where id1='"+id1+"'";
     ResultSet rs1=db.Query(sql2);
  while(rs1.next()){
      hight1=rs1.getInt("fenshu");
      if( rs1.next()){
       hight2=rs1.getInt("fenshu");
      
      }
      if(hight1>hight2){
      low=hight2;
      hight=hight1;
      }
      else{
        hight=hight2;
         low=hight1;
      }
      }
    
      %>
      
   <td align="center" colspan="9">
      <p align="center">第 <%=id1%> 期考试综合统计往期综合统计：
      </td>
    </tr>
    <%   
     String sql6="select * from chengji where id1='"+id1+"'";
     ResultSet rs6=db.Query(sql6);
     rs6.last();
     int rowcount6=rs6.getRow();
     if(rowcount6==0){ %>
   <td align="center" bgcolor="#009999"><font color="#000099">暂时没有人参加考试</font></td>
    
 <%}else{ %>
    <tr>
      <td align="center" bgcolor="#CBEFDC">参考人数</td>
      <td align="center" bgcolor="#CBEFDC">最高分</td>
      <td align="center" bgcolor="#CBEFDC">最低分</td>
      <td align="center" bgcolor="#CBEFDC">平均分</td>
      <td align="center" bgcolor="#CBEFDC">≥90</td>
      <td align="center" bgcolor="#CBEFDC">80—89</td>
      <td align="center" bgcolor="#CBEFDC">70—79</td>
      <td align="center" bgcolor="#CBEFDC" width="-5">60-69</td>
      <td align="center" bgcolor="#CBEFDC" width="-4">≤59</td>
    </tr>
    
    <tr>
      <td align="center"> <%=i%> 人</td>
      <td align="center"> <%=hight%></td>
      <td align="center">
           <%=low%> 分</td>
      <td align="center">
           <%=i>0?zf/i:0
           %> 分</td>
      <td align="center">
          <%=j%>人</td>
      <td align="center">
        <%=k%>人</td>
      <td align="center">
         <%=m%>人</td>
      <td align="center" width="-5">
          <%=n%> 人</td>
      <td align="center" width="-4">
          <%=p%> 人</td>
</tr>
<%}%>
 <tr>
 <td align="center" colspan="9">
<p align="center"><a>打印此页信息</a></p>
 </td>
</tr>
</table>
  </center>
</div>


</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -