studentinterview.jsp
资源名称:examasp.rar [点击查看]
上传用户:hjt198082
上传日期:2015-04-16
资源大小:95k
文件大小:4k
源码类别:
MySQL数据库
开发平台:
Java
- <%@ 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>