📄 my_report.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="DataBase.DBConn"%>
<%@ page import="java.sql.ResultSet"%>
<html>
<head>
<%!int id1;//成绩的ID
String no; //学生的学号
String name;//学生姓名
String sex;//学生性别
String classs;//学生班级
int k;
int p=0;
String sel;
String bg;
String tg;
int fenshu;
ResultSet rs1;// 成绩的结果集
ResultSet rs2;// 学生信息的结果集
// ResultSet记录的笔数
int rowcount =0;
String str="";
%>
<title>网上考试系统</title>
<link rel="stylesheet" type="text/css" href="css.css">
</head>
<body topmargin="0" leftmargin="0">
<% request.setCharacterEncoding("GBK");
int id=Integer.parseInt(request.getParameter("id"));
DBConn db=new DBConn();
String sql2="select * from student where id='"+id+"'";
rs2=db.Query(sql2);
rs2.next();
name=rs2.getString("name");
sex=rs2.getString("sex");
classs=rs2.getString("class");
no=rs2.getString("no");
%>
<p>
<p align="center"><font class=test1>成绩统计管理</font></p>
<div align="center">
<center>
<table border="1" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="400">
<tr>
<td align="center" colspan="3"><font color=red><%=name %></font>各期考试统计<p>学生基本资料==> 性别：<%=sex %> 班号：<%=classs %>
学号：<%=no%></p>
<%String sql3="select * from chengji where no='"+no+"'";
ResultSet rs3=db.Query(sql3);
int i=0,j=0,p=0; int q=0;
while(rs3.next()){
i++;
if(rs3.getString("sel").equals("0")){
j++;
}
}
%>
<p>（参加过<font color=red><%=i%> </font>期考试,<font color=red> <%=j %> </font> 次不及格）</td>
</tr>
<tr>
<td align="center" bgcolor="#CBEFDC">期数</td>
<td align="center" bgcolor="#CBEFDC">分数</td>
<td align="center" bgcolor="#CBEFDC">及格与否</td>
<td align="center" bgcolor="#CBEFDC">是否考试</td>
</tr>
<% String sql5="select * from test ";
ResultSet rs5=db.Query(sql5);
rs5.last();
rowcount=rs5.getRow();
%>
<%
for(k=1;k<=rowcount;){
%>
<% String sql4="select * from chengji where id1='"+k+"' and no= '"+no+"'";
ResultSet rs4=db.Query(sql4);
if(rowcount==0){%>
<tr><td colspan=5><center><font color=red>没有你查的试题信息</font></center></td></tr>
<%break;}%>
<%k++;if(rs4.next()){
if(k%2==0)
{
bg="#E9F8F0";
}else{
bg="#ffffff";
}
fenshu=rs4.getInt("fenshu");
sel=rs4.getString("sel");
str="参加了";
if(sel.equals("0")){
sel="不及格";
tg="red";
}
else{
p++;
sel="及格";
tg="#000033";
} }else{
q++;
sel="";
tg="red";
fenshu=0;
str="未参加";
if(q%2==0)
{
bg="#E9F8F0";
}else{
bg="#ffffff";
}
}
%>
<tr bgcolor=<%=bg %>>
<td align="center"><%=k-1%></td>
<td align="center"> <font color=<%=tg %>><%=fenshu%></font></td>
<td align="center">
<%=sel%> </td>
<td align="center">
<%=str%> </td>
</tr>
<%}%>
</table>
</center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -