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