?? studentinterview.jsp
字號(hào):
<%@ 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>學(xué)生詳細(xì)信息</title>
<link rel="stylesheet" href="../public/style.css">
</head>
<body>
<center>
<%
testid = request.getParameter("id");
if(testid == null) {
out.println("非法的ID號(hào)！");
return;
}
sql="SELECT * from test_result_info where testid=" + testid;
try {
rs = conn.executeQuery( sql );
}catch(Exception ee) {
out.println("訪問數(shù)據(jù)庫錯(cuò)誤！");
return;
}
if(!rs.next()) {
out.println("錯(cuò)誤的ID號(hào)");
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>學(xué)生姓名：<%=tmp_name%></b></td>
</tr>
<tr class=dbt4>
<td>性別</td>
<td><%=tmp_gender%></td>
<td>身份證號(hào)碼</td>
<td><%=tmp_certid%></td>
</tr>
<tr class=dbt4>
<td>畢業(yè)學(xué)校</td>
<td><%=tmp_school%></td>
<td>專業(yè)</td>
<td><%=tmp_major%></td>
</tr>
<tr class=dbt4>
<td>畢業(yè)時(shí)間</td>
<td><%=tmp_g_time%></td>
<td>最高學(xué)歷</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>測試時(shí)間</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>請(qǐng)?zhí)顚懨嬖嚱Y(jié)果</b></td>
</tr>
<tr class=dbt4>
<td>面試分?jǐn)?shù)</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>面試結(jié)果</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="保存面試結(jié)果">
<input type="button" value="關(guān)閉窗口" onclick="window.close()">
</td>
</tr>
</table>
</form>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -