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

📄 showstudnet.jsp

📁 用Java编写的简易的学生信息管理系统,有涉及到java web等
💻 JSP
字号:
<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@page import="com.bean.Student" %>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>
	<base href="${basePath}">
		<link rel="stylesheet" href="css/index.css" type="text/css"/>
	<title>学生管理系统</title>
	<link rel="stylesheet" type="text/css" href="css/index.css">
	<link rel="stylesheet" type="text/css" href="css/index2.css">
	<link rel="stylesheet" type="text/css" href="css/index3.css">
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="学生信息管理系统">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
	<style type="text/css">
<!--
.dlin {
	BORDER-RIGHT: #b0c7e2 1px solid; BORDER-TOP: #b0c7e2 1px solid; MARGIN-TOP: 5px; BACKGROUND: #f0f6fc; BORDER-LEFT: #b0c7e2 1px solid; WIDTH: 120px; BORDER-BOTTOM: #b0c7e2 1px solid; HEIGHT: 19px
}
.STYLE6 {font-size: 12px}
-->
    </style>
</head>
  
<body>

<table cellspacing="1" cellpadding="2" class="tbg">
  <tr  class="rbg">
    <td  height="22"  align="center">学生信息【<a href="stumess?n=add">添加</a>】</td>
  </tr>
  <tr align="center">
    <td height="68"><table width="100%"  cellspacing="1" cellpadding="2" class="tbg">
      <tr class="s7">
        <td  align="center"><span class="STYLE6">学号</span></td>
        <td  align="center"><span class="STYLE6">姓名</span></td>
        <td  align="center"><span class="STYLE6">专业</span></td>
        <td  align="center"><span class="STYLE6">科目</span></td>
        <td  align="center"><span class="STYLE6">成绩1【<a href="<c:url value='/stumess?n=compositor&param=1'/>">排序${param1}</a>】</span></td>
        <td  align="center"><span class="STYLE6">成绩2【<a href="<c:url value='/stumess?n=compositor&param=2'/>">排序${param2}</a>】</span></td>
        <td  align="center"><span class="STYLE6">成绩3【<a href="<c:url value='/stumess?n=compositor&param=3'/>">排序${param3}</a>】</span></td>
        <td  align="center"><span class="STYLE6">成绩4【<a href="<c:url value='/stumess?n=compositor&param=4'/>">排序${param4}</a>】</span></td>
        <td  align="center"><span class="STYLE6">平均分</span></td>
        <td  align="center"><span class="STYLE6">总分</span></td>
        <td  align="center"><span class="STYLE6">删除</span></td>
      </tr>
	 

			  <c:forEach items="${list}" var="student">
				<tr class="s7">
				  <td align="center" ><span class="STYLE6">${student.SStuNo}</span></td>
				  <td align="center" ><span class="STYLE6">${student.SName}</span></td>
				  <td align="center" ><span class="STYLE6">${student.SSpecialty}</span></td>
				  <td align="center" ><span class="STYLE6">${student.SDepartment}</span></td>
				  <td align="center" ><span class="STYLE6">${student.FScore1}</span></td>
				  <td align="center" ><span class="STYLE6">${student.FScore2}</span></td>
				  <td align="center" ><span class="STYLE6">${student.FScore3}</span></td>
				  <td align="center" ><span class="STYLE6">${student.FScore4}</span></td>
				  <td align="center" ><span class="STYLE6">${(student.FScore1+student.FScore2+student.FScore3+student.FScore4)/4}</span></td>
				  <td align="center" ><span class="STYLE6">${student.FScore1+student.FScore2+student.FScore3+student.FScore4}</span></td>
				  <td align="center" ><a href="javascript:if(confirm('确定要删除学号为${student.SStuNo}的相关记录吗?')){location.href='<c:url value='/stumess?n=delete&sStuNo=${student.SStuNo}'/>'}">
				  <img src="img\del.gif" width="12" height="12" title="删除">
				  </a></td>
				</tr>
			  </c:forEach>
 	  <tr class="s7">
      <td align="center" colspan="11" >
      <form action="stumess?n=stumes" method="post">
		<table class="tbg" cellspacing="0" cellpadding="2" width="100%">
		<tr>
		<td width="60"><b>查找:</b></td>
		<td width="40">学号:</td>
		<td width="40"><input class="fm f30" type="Text" name="studentNo" value="${studentNo}" maxlength="5"></td>
		
		<td width="40" align="center"><i>或者</i></td>
		<td width="40">姓名</td>
		<td width="40"><input class="fm f80" type="Text" name="studentName" value="${studentName}" size="10" maxlength="20"></td>
		
		<td class="cr7">
		<input type="image" value="ok" border="0" name="s1" src="img/ok1.gif" width="50" height="20"></input>
		</td>
		</tr>
		</table>
	</form>
		</td>
      </tr>
	
    </table>
    <p><a href="<c:url value='/stumess?n=everyavg'/>">各个成绩的平均分</a></p></td>
  </tr>
  <tr>
    <td height="68" align="center"><table width="40%"  cellspacing="1" cellpadding="2" class="tbg">
      
	 <c:choose>
						<c:when test="${requestScope.avglist==null}">											
						</c:when>
						<c:otherwise>
							<tr>
		<td align="center"><span class="STYLE6">成绩1平均分 </span></td>
        <td  align="center"><span class="STYLE6">成绩2平均分</span></td>
        <td  align="center"><span class="STYLE6">成绩3平均分</span></td>
        <td  align="center"><span class="STYLE6">成绩4平均分</span></td>		
							</tr>	
							 <c:forEach items="${avglist}" var="avgs">
        <tr>
          <td align="center" ><span class="STYLE6">${avgs.FScore1}</span></td>
          <td align="center" ><span class="STYLE6">${avgs.FScore2}</span></td>
          <td align="center" ><span class="STYLE6">${avgs.FScore3}</span></td>
          <td align="center" ><span class="STYLE6">${avgs.FScore4}</span></td>
        </tr>
      </c:forEach>
	  						</c:otherwise>
					</c:choose>
     
    </table>    
    </td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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