📄 examscoreexport.jsp

📁 培训考试系统代码
💻 JSP
字号:
<%--
/**
 * Copyright  1988-2004, Huawei Tech. Co., Ltd.
 * filename: ExamScoreExport.jsp
 * description: 导出成绩数据到Excel中
 * date: 2004-06-22
 * @author 黄育源
 * @version 3.0
 *
 * History:         // 历史修改记录
 * <author>  <time>   <version >   <desc>
 */
--%>

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="com.huawei.icd30.common.db.*" %>

<%
//response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition","attachment;filename=score.xls");

Object sessionRs         =  session.getAttribute("SCORE-QUERY-RESULTSET");
SysResultSet turnOrderRs =  sessionRs == null ?null:(SysResultSet)sessionRs;
String[] isPass ={"不通过","通过"};
%>

<%@ include file="/agt/public/jsp/Order.jsp"   %>

<html>   
  
<table width="539" border="1" cellpadding="3" cellspacing="1" class="table-cs1">  
    <tr class="td-cs2">    
        <td width="25%" height="25" align="center" nowrap class="td-cs1">考试名称</td>                         
        <td width="15%" height="25" align="center"  nowrap class="td-cs1">考生工号</td>
        <td width="25%" height="25" align="center" nowrap class="td-cs1">考生姓名</td>
        <td width="40%" height="25" align="center" nowrap class="td-cs1">所在地市</td>                        
        <td width="15%" height="25" align="center"  nowrap class="td-cs1">考试时间</td>
        <td width="15%" height="25" align="center"  nowrap class="td-cs1">成绩</td>
        <td width="15%" height="25" align="center"  nowrap class="td-cs1">是否通过</td>           
    </tr>

<%
int rsCount = turnOrderRs.getMetaData().getRecordCount();
if( turnOrderRs != null && rsCount != 0 )
{
    //此处是用来显示结果
    //for(int i=(pageNum-1)*pageRecoder; turnOrderRs.setRecord(i)&&(i<pageNum*pageRecoder); i++)
    for(int i = 0; turnOrderRs.setRecord(i)&&(i < rsCount); i++)
    {
%>
        <tr class="td-cs2">   
            <td height="25" style="word-break:break-all"><%=turnOrderRs.getString(1) %></td>            
            <td height="25" align="center"><%=turnOrderRs.getString(4) %></td>
            <td height="25" align="center"><%=turnOrderRs.getString(8) %></td>
            <td height="25" align="center"><%=turnOrderRs.getString(9) %></td>    
            <td height="25"><%=turnOrderRs.getString(2) %></td>
            <td height="25" align="center"><%=turnOrderRs.getString(3) %></td>
        <%
        if(turnOrderRs.getInt(5)==0)
        {
        %>
            <td height="25" align="center" ><font color="red"><%=isPass[turnOrderRs.getInt(5)] %></font></td>
        <%
        }
        else
        { 
        %>
            <td height="25" align="center" ><%=isPass[turnOrderRs.getInt(5)] %></td>  
        <%
        }
        %> 
        </tr>
    <%
    }
}
%>   
</table>
   
</html>
⌨️ 快捷键说明

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