<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%@ include file="/public/checkvalidadmin.jsp"%>

<%!
String testid = "";
String sql = "";
ResultSet rs = null;

%>
<html>

<head>
<title>学生详细信息</title>
    <link rel="stylesheet" href="../public/style.css">
</head>
<body>
<center>
<%
testid = request.getParameter("id");
if(testid == null) {
    out.println("非法的ID号！");
	return;
}
sql="SELECT * from test_result_info where testid=" + testid;

try {
   rs = conn.executeQuery( sql );
}catch(Exception ee) {
   out.println("访问数据库错误！");
   return;
}

if(!rs.next()) {
	out.println("错误的ID号");
	return;
}else {
%>
<br><br><br>
<table width="80%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
	  <tr bgcolor="#FAD185"> 
		<td colspan=4 height=20 align=center><b>学生姓名：<%=rs.getString("name")%></b></td>
	  </tr>
      
	  <tr class=dbt4> 
		  <td>性别</td>
		  <td><%=rs.getString("gender")%></td>
          <td>身份证号码</td>
		  <td><%=rs.getString("certid")%></td>
	  </tr>
	  <tr class=dbt4> 
		  <td>毕业学校</td>
		  <td><%=rs.getString("school")%></td>
          <td>专业</td>
		  <td><%=rs.getString("major")%></td>
	  </tr>
	  <tr class=dbt4> 
		  <td>毕业时间</td>
		  <td><%=rs.getString("g_time")%></td>
          <td>最高学历</td>
		  <td><%=rs.getString("degree")%></td>
	  </tr>
	  <tr class=dbt4> 
		  <td>英语水平</td>
		  <td><%=rs.getString("english")%></td>
          <td>工作年限</td>
		  <td><%=rs.getString("work_year")%></td>
	  </tr>
	  <tr class=dbt4> 
		  <td>测试时间</td>
		  <td><%=rs.getString("starttime")%></td>
          <td>测试成绩</td>
		  <td><%=rs.getInt("score")%></td>
	  </tr>

	</table>
<%
}
%>
<hr width="80%"/>
<br><br><br>
<form action="studentinterviewsave.jsp" method="post">
<input type="hidden" name="testid" value="<%=testid%>">
<table width="80%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
	  <tr bgcolor="#FAD185"> 
		<td colspan=4 height=20 align=center><b>请填写面试结果</b></td>
	  </tr>
	  <tr class=dbt4> 
		  <td>面试分数</td>
		  <td>
		  <select name="interviewscore">
		      <option value="10">10</option>
		      <option value="10">20</option>
		      <option value="10">30</option>
		      <option value="10">40</option>
		      <option value="10">50</option>
		      <option value="10">60</option>
		      <option value="10">70</option>
		      <option value="10">80</option>
		      <option value="10">90</option>
		      <option value="10">100</option>
		  </select>
		  </td>
          <td>面试结果</td>
		  <td>
		  <select name="interviewresult">
		      <option value="1">合格</option>
		      <option value="-1">不合格</option>
          </select>
		  </td>
	  </tr>
	  <tr class=dbt4>
	      <td>面试教师建议</td>
		  <td colspan=3>
		  <textarea name="suggest" rows=3 cols=85></textarea>
		  </td>
	  </tr>
	  <tr>
	      <td colspan=4 align="center">
		      <input type="submit" value="保存面试结果">&nbsp;&nbsp;&nbsp;
			  <input type="button" value="关闭窗口" onclick="window.close()">
		  </td>
	  </tr>
</table>
</form>
</body>
</html>