📄 student.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="DataBaseConnection.OracleConnection" %>
<html>
<body bgcolor=cyan>
<center>
<font size=7>
<HEAD>
<TITLE>考生信息</TITLE>
</HEAD>
<%--对获取的编号进行判断和处理--%>
<%
//如果为空就转回去
String bh = request.getParameter( "BH" );
String mm =request.getParameter("MM");
if( bh==null||bh.trim().equals( "" ) ){
%>
<jsp:forward page ="login.jsp"/>
<%
}
if( mm==null||mm.trim().equals( "" ) ){
%>
<jsp:forward page ="login.jsp"/>
<%
}
//如果count不是数字就转回去
int number;
try{
number = Integer.parseInt( bh );
}catch( Exception e ) {
%>
<jsp:forward page ="login.jsp"/>
<% }
try{
number = Integer.parseInt( mm );
}catch( Exception e ) {
%>
<jsp:forward page ="login.jsp"/>
<% }
%>
<%
//获取连接对象和语句对象
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" ); }
//判断存不存在该编号的考生
ResultSet rs = stmt.executeQuery( "select count(*) from student where 编号= '"+bh+"' and 出生年月日='"+mm+"' " );
rs.next();
if( rs.getInt(1) == 0 ){
out.print( "不存在此考生" );
}
//若存在则输出他的相关信息
else{
String sql = "select 姓名,总分,录取院校 from student where 编号='"+bh+"' ";
String sql2="select 语文,数学,英语,综合,X科 from score where 号码='"+bh+"'";
String lqzt;
String s1,s2,s3,s4,s5,s6,s7,s8;
rs = stmt.executeQuery( sql );
rs.next();
s1=rs.getString(1);s2=rs.getString(2);s3=rs.getString(3);
rs = stmt.executeQuery( sql2 );
rs.next();
s4=rs.getString(1);s5=rs.getString(2);s6=rs.getString(3);s7=rs.getString(4);s8=rs.getString(5);
if( s3 != null){
sql = "select 院校名称 from college where 院校编号= '"+s3+"' ";
rs = stmt.executeQuery( sql );
rs.next();
s3 = rs.getString(1);
lqzt = "你已被"+s3+"录取!";
}
else
lqzt = "还未被录取!";
out.print( "考生:"+s1+"<br>"+"总分为:"+s2+"<br>"+"各科成绩：<br>"+"语文:"+s4+" 数学:"+s5+" 英语:"+s6+" 综合:"+s7+" X科:"+s8+"<br><br><font color=red>"+lqzt+"</font>" );
}
%>
<p><a href="login.jsp">退出</a></p>
</font>
</center>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -