📄 forscore.jsp

📁 这个也是师兄的毕业设计,具体的功能我也不清楚,不过是可以用来答辩的,完整的毕业设计,有源代码,可执行文件,文档资料.
💻 JSP
字号:
<%@ page  language="java" import="java.sql.*"%>
<%//request.setCharacterEncoding("gb2312");%>
<%@ include file="author.jsp" %>
<%@ include file="change.jsp" %>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<html>
<head>

<title>考试成绩一览</title>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 {
	font-size: 12px;
	font-weight: lighter;
	color: #FF0000;
	text-decoration: none;
}
-->
</style>
</head>
<form action="searchscore.jsp" method="post" name="formloginD" id="formloginD">
<body>
<%////////////////////////////////////

Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
String sqlstr;
String yuwen="语文";
String shuxue="数学";
String luoji="逻辑";
String yingyu="英语";
ResultSet result;
int total=0;

sqlstr="SELECT COUNT(*) FROM score where subject=?";
ps=conn.prepareStatement(sqlstr);
ps.setString(1,yuwen);
result=ps.executeQuery();
//result.next();
while (result.next())
{
  total=result.getInt(1);
%>
<font color='#fff111' size="3" ><div align="left">成绩统计:</div></font>
<br>
<table width="85%" border="0" align="center" class="table">
  <tr><th rowspan=2>语文</th>
    <td colspan="2" class="table">参加考试总人数:<%=total%>人</td>
<% sqlstr="SELECT count(*) from score where score>=80 and subject=?";
   ps=conn.prepareStatement(sqlstr);
   ps.setString(1,yuwen);
   result=ps.executeQuery();
   result.next();%>
    <td class="table">80分以上:<%=result.getInt(1)%>人</td>
	<%
	sqlstr="SELECT count(*) from score where score>=70 and score<80 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yuwen);
	result=ps.executeQuery();
	result.next();
	%>
    <td class="table">70-80分:<%=result.getInt(1)%>人</td>
	 <%
	sqlstr="SELECT count(*) from score where score>=60 and score<70 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yuwen);
	result=ps.executeQuery();
	result.next();
	%>
    <td class="table">60-70分:<%=result.getInt(1)%>人</td>
	 <%
	sqlstr="SELECT count(*) from score where score<60 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yuwen);
	result=ps.executeQuery();
	result.next();
	%>
    <td class="table">60分以下:<%=result.getInt(1)%>人</td>
  </tr>
  <%
	sqlstr="SELECT max(score) as maxscore,min(score) as minscore,sum(score) as sumscore from score where subject=?";
	ps=conn.prepareStatement(sqlstr);
    ps.setString(1,yuwen);
	result=ps.executeQuery();
	result.next();
%>
  <tr class="table"> 
    <td colspan=2 width="27%" class="table">最高分:<%=result.getInt("maxscore")%>&nbsp;</td>
    <td colspan=2 width="37%" class="table">最低分:<%=result.getInt("minscore")%>&nbsp;</td>
    <td colspan=2 width="47%" class="table">平均分:<%=result.getInt("sumscore")/total%>&nbsp;</td>
  </tr>
</table>
<table width="85%" border="0" align="center" class="table">
  <tr><th rowspan=2>数学</th>
  <%}	////////////////////////////////////////////////////////////
  /////////////数学///////////////
	sqlstr="SELECT COUNT(*) FROM score where subject=?";
    ps=conn.prepareStatement(sqlstr);
    ps.setString(1,shuxue);
    result=ps.executeQuery();
    //result.next();
	while (result.next())
{
    total=result.getInt(1);
%>
    <td colspan="2" class="table">参加考试总人数:<%=total%>人</td>
	<% sqlstr="SELECT count(*) from score where score>=80 and subject=?";
   ps=conn.prepareStatement(sqlstr);
   ps.setString(1,shuxue);
   result=ps.executeQuery();
   result.next();%>
    <td class="table">80分以上:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score>=70 and score<80 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,shuxue);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">70-80分:<%=result.getInt(1)%>人 
   <%
	sqlstr="SELECT count(*) from score where score>=60 and score<70 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,shuxue);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60-70分:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score<60 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,shuxue);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60分以下:<%=result.getInt(1)%>人</td>
  </tr>
  <%
	sqlstr="SELECT max(score) as maxscore,min(score) as minscore,sum(score) as sumscore from score where subject=?";
	ps=conn.prepareStatement(sqlstr);
    ps.setString(1,shuxue);
	result=ps.executeQuery();
	result.next();
%>
  <tr class="table"> 
    <td colspan=2 width="27%" class="table">最高分:<%=result.getInt("maxscore")%>&nbsp;</td>
    <td colspan=2 width="37%" class="table">最低分:<%=result.getInt("minscore")%>&nbsp;</td>
    <td colspan=2 width="47%" class="table">平均分:<%=result.getInt("sumscore")/total%>&nbsp;</td>
  </tr>
</table>
<%	}
	sqlstr="SELECT COUNT(*) FROM score where subject=?";
    ps=conn.prepareStatement(sqlstr);
    ps.setString(1,luoji);
    result=ps.executeQuery();
    //result.next();
	while (result.next())
{
    total=result.getInt(1);
%>
<table width="85%" border="0" align="center" class="table">
  <tr><th rowspan=2>逻辑</th>
    <td colspan="2" class="table">参加考试总人数:<%=total%>人</td>
	<% sqlstr="SELECT count(*) from score where score>=80 and subject=?";
   ps=conn.prepareStatement(sqlstr);
   ps.setString(1,luoji);
   result=ps.executeQuery();
   result.next();%>
    <td class="table">80分以上:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score>=70 and score<80 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,luoji);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">70-80分:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score>=60 and score<70 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,luoji);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60-70分:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score<60 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,luoji);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60分以下:<%=result.getInt(1)%>人</td>
  </tr>
  <%
	sqlstr="SELECT max(score) as maxscore,min(score) as minscore,sum(score) as sumscore from score where subject=?";
	ps=conn.prepareStatement(sqlstr);
    ps.setString(1,luoji);
	result=ps.executeQuery();
	result.next();
%>
  <tr class="table"> 
    <td colspan=2 width="27%" class="table">最高分:<%=result.getInt("maxscore")%>&nbsp;</td>
    <td colspan=2 width="37%" class="table">最低分:<%=result.getInt("minscore")%>&nbsp;</td>
    <td colspan=2 width="47%" class="table">平均分:<%=result.getInt("sumscore")/total%>&nbsp;</td>
  </tr>
</table>

<%	}
	sqlstr="SELECT COUNT(*) FROM score where subject=?";
    ps=conn.prepareStatement(sqlstr);
    ps.setString(1,yingyu);
    result=ps.executeQuery();
    //result.next();
	while (result.next())
{
    total=result.getInt(1);
%>
<table width="85%" border="0" align="center" class="table">
  <tr><th rowspan=2>英语</th>
    <td colspan="2" class="table">参加考试总人数:<%=total%>人</td>
	<% sqlstr="SELECT count(*) from score where score>=80 and subject=?";
   ps=conn.prepareStatement(sqlstr);
   ps.setString(1,yingyu);
   result=ps.executeQuery();
   result.next();%>
    <td class="table">80分以上:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score>=70 and score<80 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yingyu);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">70-80分:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score>=60 and score<70 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yingyu);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60-70分:<%=result.getInt(1)%>人 
    <%
	sqlstr="SELECT count(*) from score where score<60 and subject=?";
	ps=conn.prepareStatement(sqlstr);
	ps.setString(1,yingyu);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60分以下:<%=result.getInt(1)%>人</td>
  </tr>
  <%
	sqlstr="SELECT max(score) as maxscore,min(score) as minscore,sum(score) as sumscore from score where subject=?";
	ps=conn.prepareStatement(sqlstr);
    ps.setString(1,yingyu);
	result=ps.executeQuery();
	result.next();
%>
  <tr class="table"> 
    <td colspan=2 width="27%" class="table">最高分:<%=result.getInt("maxscore")%>&nbsp;</td>
    <td colspan=2 width="37%" class="table">最低分:<%=result.getInt("minscore")%>&nbsp;</td>
    <td colspan=2 width="47%" class="table">平均分:<%=result.getInt("sumscore")/total%>&nbsp;</td>
  </tr>
</table><%}%>
<p><br>
<div align="center">
学号：<input name="xh" id="xh" type="text" class="textborder"><br>
姓名：<input name="xm" id="xm" type="text" class="textborder"><br>
科目：<input name="km" id="km" type="text" class="textborder"><br><p>
<input type="submit" name="Submit" value="查询">  <input type=reset value="重设">

</div>
</form>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -