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

📄 studentscore_2.jsp

📁 jsp在线考试系统
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%@ include file="/public/checkvalidadmin.jsp"%>

<%!
ResultSet rs = null;
ResultSet rsTmp = null;
String sql = "";
String classid    = "";
String examtime   = "";
int mianshi_flag  = 0;

String	tmp_studentid;
String	tmp_name;
String	tmp_school;
String	tmp_degree;
String	tmp_score;
int	tmp_mianshij;
String	tmp_testid;
%>

<%
classid  = request.getParameter("classid");
examtime = request.getParameter("examtime"); 
if(classid==null || examtime==null) {
    out.println("无法得到班级信息及考试日期信息！");
	return;
}
sql = "select * from test_result_info where classid=" + classid;
sql+= " and convert(char(8),starttime,3)='" + examtime+ "'";

try {
	   rs = conn.executeQuery( sql );
}catch(Exception e) {
	   out.println("访问考试结果信息数据出错！");
	   return;
}
//if(!rs.next()){out.println("no data!");return;}
%>

<html>

<head>
	<title>察看试卷</title>
    <link rel="stylesheet" href="../public/style.css">
	<Script language="JavaScript">
	//打开新窗口函数openwin
	function openwin(id)
	{
	   window.open('studentinterview.jsp?id='+id,'infoWin', 'height=600,width=800,scrollbars=yes,resizable=yes');
	}
	</Script>
</head>

<body  class="ss">
<center>

<table class=dbt2 width=640 cellSpacing=1 cellPadding=3 border=0>
	<tr class=dbt3 align=middle>
		<TH>编号</TH>
		<TH>学生编号</TH>
		<TH>学生姓名</TH>
		<TH>毕业院校</TH>
		<TH>学历</TH>
		<TH>测试分数</TH>
		<TH>面试</TH>
	</TR>
<%
int k=1;
int tmpstudentid=0;
while(rs.next()) {
	tmp_studentid = rs.getString(1);//rs.getString("studentid");
	tmp_name = rs.getString(2);//rs.getString("name");
	tmp_school = rs.getString(6);//rs.getString("school");
	tmp_degree = rs.getString(9);//rs.getString("degree");
	tmp_score = rs.getString(12);//rs.getString("score");
	tmp_testid = rs.getString(15);//rs.getString("testid");
	tmp_mianshij = rs.getInt(16);//rs.getString("mianshij");

%>
<TR class=dbt4 align=center>
	<TD><%=k%></TD>
    <TD><%=tmp_studentid%>
	</TD>
    <TD><%=tmp_name%></TD>
    <TD><%=tmp_school%></TD>
    <TD><%=tmp_degree%></TD>
    <TD><%=tmp_score%></TD>
	<%
	mianshi_flag = tmp_mianshij;
    if(mianshi_flag==1) {
    %>      
		<TD>已通过面试</TD>
	<%}else if(mianshi_flag==-1) {%>
          <TD>未通过面试</TD>
    <%}else {%>
		  <TD><%="<a href=javascript:openwin('"+tmp_testid+"')>面试</a>"%></TD>
	<%}%>
</TR>
<%
k++;
}	
%>
</table>
</center>
<hr>
</body>
</html>

⌨️ 快捷键说明

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