📄 qscore.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>学生个人成绩单</title>
</head>
<body background="images/bj.gif" >
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<%
int jige=0;
int bujige=0;
int sum=0;
String snum=request.getParameter("pnum");
String sql="select * from student where snum='"+snum+"'";
ResultSet rs=db.executeQuery(sql);
System.out.println("qscore.jsp 29 line:"+sql);
if(rs.next())
{
String sname=rs.getString("sname");
int ssex=rs.getInt("ssex");
int sno=rs.getInt("sno");
int grade=rs.getInt("grade");
int sclass=rs.getInt("sclass");
int dep=rs.getInt("dep");
String sql1="select depname from departmen where dep='"+dep+"'";
ResultSet rs1=db.executeQuery(sql1);
rs1.next();
String depname=rs1.getString("depname");
rs1.close();
String sql2="select count(snum) as num from success where snum='"+snum+"'";
ResultSet rs2=db.executeQuery(sql2);
rs2.next();
String num=rs2.getString("num");
rs2.close();
%>
<table width="75" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="396" height="30" border="1" align="center" cellpadding="1" cellspacing="1" background="images/bj.gif">
<tr bordercolor="#008000">
<td width="76" height="26" class="ccc"> <div align="center"><font color="#000000"><strong>学
号</strong></font></div></td>
<td width="92" height="26" class="ccc"><font color="#9900FF"><strong><%=snum%></strong></font></td>
<td width="79" height="26" class="ccc"> <div align="center"><font color="#000000"><strong>姓 名</strong></font></div></td>
<td width="126" height="26" class="ccc"><font color="#9900FF"><strong><%=sname%></strong></font></td>
</tr>
</table>
<table width="75" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="396" height="77" cellspacing="1" border=1 align="center" bordercolor="#008000" background="images/bj.gif">
<tr>
<td height="28" colspan="3" class="ccc"> <div align="center"><font color="#000000"><strong>所有考试科目的成绩</strong></font></div></td>
</tr>
<tr>
<td width="150" height="21" class="ccc"> <div align="center"><font color="#000000"><strong>科 目</strong></font></div></td>
<td width="128" height="21" class="ccc"> <div align="center"><font color="#000000"><strong>成
绩</strong></font></div></td>
<td height="21" class="ccc"> <div align="center"><font color="#000000"><strong>补考成绩</strong></font></div></td>
</tr>
<%
String sql5="select subject,success,bsuccess from success where snum='"+snum+"'";
ResultSet rs5=db.executeQuery(sql5);
ResultSet rs6=db.executeQuery(sql5);
if (rs6.next())
{
rs6.close();
while(rs5.next())
{
sum++;
String subject3=rs5.getString("subject");
int success3=rs5.getInt("success");
int bsuccess3=rs5.getInt("bsuccess");
%>
<tr>
<td width="150" valign="center" class="ccc"><font color="#9900FF"><%=subject3%></font></td>
<td width="128" align="center" class="ccc"><font color="#9900FF">
<%if(success3==0)
{%>
<%}else
{ jige++;%>
<%=success3%>
<%}%>
</font></td>
<td width="100" align="center" class="ccc"> <font color="#9900FF">
<%if (bsuccess3==0)
{ ; %>
<%
}else
{
%>
<%=bsuccess3%>
<%
}%>
</font></td>
<%
}%>
</table>
<br>
<br>
<% bujige=sum-jige; %>
<font color="#0033FF" size="2">总计课程：<font color="red"><strong><%=sum%></strong></font> ,合格为：<font color="red"><strong><%=jige%></strong></font>,补考为:<font color="red"><strong><%=bujige%></strong></font></font>
<%
}
else
{ %>
<tr><th clospan="3" ><font color="red">暂无此记录!!!</a></th></tr>
</table>
<%
}
} %>
<br>
<br>
<br>
<center>
<form action="exitqscore.jsp" method="post">
<input type="submit" value="关 闭">
</form>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -