📄 studentinterview.jsp
字号:
<%@ 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;
String tmp_name;
String tmp_certid;
String tmp_gender;
String tmp_school;
String tmp_major;
String tmp_g_time;
String tmp_degree;
String tmp_work_year;
String tmp_score;
String tmp_starttime;
String tmp_english;
%>
<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 {
tmp_name = rs.getString("name");
tmp_certid = rs.getString("certid");
tmp_gender = rs.getString("gender");
tmp_school = rs.getString("school");
tmp_major = rs.getString("major");
tmp_g_time = rs.getString("g_time");
tmp_degree = rs.getString("degree");
tmp_english = rs.getString("english");
tmp_work_year = rs.getString("work_year");
tmp_score = rs.getString("score");
tmp_starttime = rs.getString("starttime");
%>
<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>学生姓名：<%=tmp_name%></b></td>
</tr>
<tr class=dbt4>
<td>性别</td>
<td><%=tmp_gender%></td>
<td>身份证号码</td>
<td><%=tmp_certid%></td>
</tr>
<tr class=dbt4>
<td>毕业学校</td>
<td><%=tmp_school%></td>
<td>专业</td>
<td><%=tmp_major%></td>
</tr>
<tr class=dbt4>
<td>毕业时间</td>
<td><%=tmp_g_time%></td>
<td>最高学历</td>
<td><%=tmp_degree%></td>
</tr>
<tr class=dbt4>
<td>英语水平</td>
<td><%=tmp_english%></td>
<td>工作年限</td>
<td><%=tmp_work_year%></td>
</tr>
<tr class=dbt4>
<td>测试时间</td>
<td><%=tmp_starttime%></td>
<td>测试成绩</td>
<td><%=tmp_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="20">20</option>
<option value="30">30</option>
<option value="40">40</option>
<option value="50">50</option>
<option value="60">60</option>
<option value="70">70</option>
<option value="80">80</option>
<option value="90">90</option>
<option value="100">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="保存面试结果">
<input type="button" value="关闭窗口" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -