⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 search.jsp

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<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>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement ps=null;
String sqlstr;
ResultSet result;

sqlstr="SELECT COUNT(*) FROM score ";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();
result.next();
int total=result.getInt(1);

sqlstr="SELECT count(*) from score where score>=80";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();
result.next();
%>
<body>
<table width="82%" border="0" align="center" class="table">
  <tr> 
    <td colspan="2" class="table">参加考试总人数:<%=total%>人</td>
    <td class="table">80分以上:<%=result.getInt(1)%>人 
      <%
	sqlstr="SELECT count(*) from score where score>=70 and score<80";
	ps=conn.prepareStatement(sqlstr);
	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";
	ps=conn.prepareStatement(sqlstr);
	result=ps.executeQuery();
	result.next();
	%>
    </td>
    <td class="table">60-70分:<%=result.getInt(1)%>人 
      <%
	sqlstr="SELECT count(*) from score where score<60";
	ps=conn.prepareStatement(sqlstr);
	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 ";
	ps=conn.prepareStatement(sqlstr);
	result=ps.executeQuery();
	result.next();
	%>
  <tr class="table"> 
    <td width="15%" class="table">最高分:</td>
    <td width="12%" class="table"><%=result.getInt("maxscore")%>&nbsp;</td>
    <td width="21%" class="table">最低分:</td>
    <td width="16%" class="table"><%=result.getInt("minscore")%>&nbsp;</td>
    <td width="17%" class="table">平均分:</td>
    <td width="19%" class="table"><%=result.getInt("sumscore")/total%>&nbsp;</td>
  </tr>
  <tr align="center" class="table"> 
    <td class="table">学号</td>
    <td class="table">姓名</td>
    <td class="table">性别</td>
    <td class="table">专业</td>
    <td class="table">年级</td>
	<td class="table">科目</td>
    <td class="table">分数</td>
  </tr>
  <%
sqlstr="SELECT student.S_id, student.S_name, student.sex, student.major, student.grade,score.score FROM score INNER JOIN student ON score.s_id = student.S_id ORDER BY score.score DESC";
ps=conn.prepareStatement(sqlstr);
result=ps.executeQuery();
while (result.next())
{

%>
  <tr align="center" valign="middle" class="table"> 
    <td ><%= result.getString("s_id") %></td>
    <td ><%= result.getString("s_name") %></td>
    <td><%= (result.getString("sex")!=null?result.getString("sex"):"") %></td>
    <td><%= (result.getString("major")!=null?result.getString("major"):"") %></td>
    <td><%= (result.getString("grade")!=null?result.getString("grade"):"") %></td>
    <td><%= result.getString("score") %></td>
  </tr>
  <%
}
%>
</table>
</body>
</html>

⌨️ 快捷键说明

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