<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
	<p><font color="#003366" size="+4">
		<% 
				String driver = "oracle.jdbc.driver.OracleDriver";
				String url = "jdbc:oracle:thin:@localhost:1521:oracle";
				String user = "sox";
				String password = "123";
				boolean isSuccess = true;
				Connection conn = null;
				CallableStatement cstmt = null;
				OracleConnection oc = new OracleConnection( user, password );
				                 conn = oc.getConnection();
				                cstmt = conn.prepareCall ( "select times from note" );
                                ResultSet rs=cstmt.executeQuery();
								rs.next();
  if(rs.getInt(1)==1){
					try{
							
							cstmt = conn.prepareCall ( "call AUTOPROC(2)" );
							cstmt.execute();
							cstmt.close();
							conn.close();
						}
					catch( SQLException e ){ isSuccess = false; }
					if( isSuccess ) out.print( "二志愿投檔成功" );
				else out.print( "二志愿投檔失敗" );
				   }
				   else if(rs.getInt(1)==0){  out.print("請先執行一志愿投檔！");}
					else if(rs.getInt(1)==2){out.println("一志愿和二志愿投檔已完成！<br>請進行補錄操作！");}
                    else if(rs.getInt(1)==3){out.print("投檔操作已完成！<br>請執行其它操作！");} 
					%> 
					</font></p>