firstpickfile.jsp

来自「一个挺好的招生管理系统」· JSP 代码 · 共 34 行

<%@ 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)==0){
					try{
							
							cstmt = conn.prepareCall ( "call AUTOPROC(1)" );
							cstmt.execute();
							cstmt.close();
							conn.close();
						}
					catch( SQLException e ){ isSuccess = false; }
					if( isSuccess ){ out.print( "一志愿投档成功" );}
				    else {out.print( "一志愿投档失败" );}
                    }
					else if(rs.getInt(1)==1){  out.print("一志愿投档已完成！请进行二志愿投档！");}
					else if(rs.getInt(1)==2){out.print("一志愿，二志愿投档已完成！<br>请进行补录操作！");}
                    else if(rs.getInt(1)==3){out.print("投档操作已完成！<br>请进行其它操作！");} 
					%> 
					</font></p>