?? studentinterviewsave.jsp
字號(hào):
<%@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>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -