📄 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;
%>
<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="保存面试结果">
<input type="button" value="关闭窗口" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -