thirdpick.jsp

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

JSP
46
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?