📄 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 + -