?? studentscore_2.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 + -