?? thirdpick.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>投檔錄取</title>
</head>
<body bgcolor="#00FFFF">
<table width="93%" height="413" border="0">
<tr>
<td height="83" colspan="2"><%@ include file="Top.jsp" %> </td>
</tr>
<tr>
<td width="18%"><%@ include file="Left.jsp" %></td>
<td width="82%" align="center">
<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)==2){
%><jsp:forward page="ThirdPickFile.jsp">
<jsp:param name="check" value="1"/>
</jsp:forward>
<%
}
else if(rs.getInt(1)==0){ out.print("請進行一志愿投檔!");}
else if(rs.getInt(1)==1){out.print("請進行二志愿投檔!");}
else if(rs.getInt(1)==3){out.print("補錄操作已完成!<br>請進行其它操作!");}
%> </td>
</font></p>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -