📄 thirdpickfile.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ 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">
<%
String MESSAGE=request.getParameter("message");
if(MESSAGE==null){MESSAGE="";}
if(MESSAGE.equals("null")){MESSAGE="修改的院校信息不能为空！";}
if(MESSAGE.equals("nocollege")){MESSAGE="不存在该院校！请重新输入！";}
if(MESSAGE.equals("error")){MESSAGE="只允许增加招生人数和降低录取分数线的操作！";}
if(MESSAGE.equals("success")){MESSAGE="院校信息修改成功！";}
String CHECK=request.getParameter("check");
String DOUBLECHECK=(String)session.getAttribute("doublecheck");
if(CHECK==null||DOUBLECHECK.equals("god")){out.print("<font size=+3 color=red>非法进入！请立即退出！");}
else{
%> <center>
<P><font color=blue size=+3>院校信息</font></p>
<%
//获取连接对象和语句对象
Connection conn = null;
Statement stmt = null;
String user = "sox";
String password = "123";
OracleConnection oc = new OracleConnection( user, password );
try{
conn = oc.getConnection();
stmt = conn.createStatement();
}
catch( SQLException e ){ System.out.println( e.getMessage()+"374" ); }
//判断存不存在该编号的考生
String sql = "select * from college order by 院校编号";
ResultSet rs = stmt.executeQuery( sql );
%>
<table border="1">
<tr bgcolor="#FFCC99">
<th nowrap>院校编号</th>
<th nowrap>院校名称</th>
<th nowrap>录取分数线</th>
<th nowrap>招生人数</th>
<th nowrap>录取人数</th>
</tr>
<% while( rs.next() ){
out.print( "<tr> <td>"+rs.getString(1)+"</td><td>"+
rs.getString(2)+"</td><td>"+rs.getString(4)+"</td><td>"+rs.getString(5)+
"</td><td>"+rs.getString(6)+"</td><td>" );
}
%>
</table>
</center>
<BR><font color=blue size=+3>修改院校录取分数线和录取人数：</font>
<form action="UpdateCollege.jsp" method="post">
<table border="1">
<tr bgcolor="#FFCC99">
<th nowrap>院校编号</th>
<th nowrap>招生人数</th>
<th nowrap>录取分数线</th>
</tr>
<tr>
<td><input type="text" name="YXBH"></td>
<td><input type="text" name="ZSRS"></td>
<td><input type="text" name="LQFSX"></td>
</tr>
</table>
<input type="hidden" name="check0" value="<%=CHECK%>">
<input type="submit" value="修改">
</form>
<br><FONT color=blue><%=MESSAGE%></FONT>
<p><a href="ThirdPickAction.jsp"><font size=+3 color=red>考生补录<br>（注意！只有一次补录机会！）</br></font></a></p>
</td>
</tr>
</table>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -