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

<%!
    ResultSet rs     = null;                 // 執行Sql語句返回的結果集
    String studentid  = "";
	String password   = "";
	String sql = "";
    int priv = 0;
%>
<%
    studentid = request.getParameter("studentid");
 	password  = request.getParameter("pwd");

	if(studentid ==null || password == null || studentid.equals("") || password.equals("")) {
        out.println( "<center>" );	
        out.println( "<h1>學員ID或密碼輸入非法！請返回重新輸入！</h1><BR><BR>");	
        out.println("<a href=javascript:history.back()>返回</a>");
        out.println( "</center>" );	

		return;
	}
		
 	sql = "select * from test_studentinfo where studentid=" + studentid;
	sql+= " and password='" + password + "'";

	try {
			rs = conn.executeQuery( sql );
	
			// 如果是非法用戶名或密碼，回到登陸界面
			if(!rs.next()) {
%>
				<jsp:forward page="../index.htm"/>

				<!-- 利用forward實現頁面的跳轉，但是卻無法顯示圖片和其他的相對鏈接 -->
				<!--能不能用response.sendRedirect("../index.htm");呢？可是卻出現：無效的指針狀態……-->
				<!--或者用javascript實現？ <script>alert("aa");history.back();</script> -->
				<!-- 發現一個問題：jsp:forward對html的注譯符號不感冒，注不掉它……  -->

<%			
			}
	}catch(Exception ee) { // 其他異常情況
%>


	<jsp:forward page="/public/dberror.jsp"/>



<%		
	}
	session.setAttribute("studentlogin","ok");        // 將權限信息保存到session中
	session.setAttribute("studentid",""+studentid);
    session.setAttribute("studentname",rs.getString("name"));
	session.setMaxInactiveInterval(60*60*24);
	response.sendRedirect("exam.jsp");   
%>