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

<%!
ResultSet rs = null;

String testid;
String teachername;
String mianshif;
String mianshij;
String suggest;

String sql = "";
int result = 0;
%>

<%
request.setCharacterEncoding("GBK");
testid   = request.getParameter("testid");
teachername   = request.getParameter("teachername");
mianshif      = request.getParameter("interviewscore");
mianshij      = request.getParameter("interviewresult");
suggest       = request.getParameter("suggest");

// 避免用戶直接在瀏覽器地址欄輸入頁(yè)面地址所產(chǎn)生的Exception
if(testid==null || testid.equals("")) {
    out.println("<center>");
	out.println("請(qǐng)進(jìn)行合法操作！");
	out.println("</center>");
	return;
}

try{
	sql  = "select * from test_result_info where ";
	sql += " testid=" + testid;
	rs = conn.executeQuery( sql );

	if(!rs.next()) {
		out.println("<center>");
		out.println("數(shù)據(jù)庫(kù)沒有代號(hào)為" + testid + "的測(cè)試結(jié)果信息！<br>");
		out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
		out.println("</center>");
	} else {
		sql = "update test_result set teachername='" + (String)session.getAttribute("adminname") + "'";
		sql+= ",mianshif=" + mianshif;
		sql+= ",mianshij=" + mianshij;
		sql+= ",suggest='" + suggest + "'";
		sql+= " where testid=" + testid ;
		result = conn.executeUpdate( sql );
		if(result !=1 ) {
			out.println("<center>");
			out.println("保存面試結(jié)果操作失敗！<br><br>");
			out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
			out.println("</center>");
		}
	}
}catch(Exception ee) {
	out.println("<center>");
	out.println("保存面試結(jié)果操作失敗！<br><br>");
	out.println("請(qǐng)將下列信息告知管理員<br><br>");
	out.println(ee.toString() + "<br><br>");
	out.println("單擊這里<a href=javascript:history.back()>返回</a><br>");
	out.println("</center>");
}
%>
<jsp:forward page="studentinterview.jsp">
   <jsp:param name="id" value="<%=testid%>"/>
</jsp:forward>
</center>
</Body>

</html>