📄 core_close.jsp

📁 JavaWeb标签应用开发（随书光盘）为方便读者阅读本书和调试程序
💻 JSP
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<html>
<body bgcolor="#DCDADA">
<!---------导航菜单------------->
<table border="0" width="100%">
  <tr>
    <td width="100%">
      <p align="left">您当前所在位置：学生成绩封存</p>
    </td>
  </tr>  
</table>
<!---------数据输入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
  <tr>
    <td width="100%">
      <table border="0" width="100%">
        <tr>
          <td width="100%" colspan="5">选择要封存的班级和课程：<br><hr></td>
        </tr>
        <form name="add_core_form" action="core_close.jsp" method="post" >
        <tr>
          <td width="25%" align="right">班级：</td>
          <td width="10%">
          <!-----生成班级下拉框------>
          <c:set var="selectRSSQL" value="select class_id,class_name from class"/>
          <sql:query sql="${selectRSSQL}" 
  			var="classRS" dataSource="${sqlDS}"/>
  		  <select name="class_id">
  		  	<option value="">====所有班级====</option>
  		  	<c:forEach items="${classRS.rowsByIndex}" var="cucN">
  		  		<option value="${cucN[0]}">${cucN[1]}</option>
  		  	</c:forEach>
  		  </select> 
          </td>
          <td width="15%" align="right">课程名：</td>
          <td width="20%">
          <!-----生成课程下拉框------>
          <c:set var="selectRSSQL" value="select lession_id,lession_name from lession"/>
          <sql:query sql="${selectRSSQL}" 
  			var="lessionRS" dataSource="${sqlDS}"/>
  		  <select name="lession_id">
  		  	<option value="">====所有课程====</option>
  		  	<c:forEach items="${lessionRS.rowsByIndex}" var="cucN">
  		  		<option value="${cucN[0]}">${cucN[1]}</option>
  		  	</c:forEach>
  		  </select>
          </td>
          <td width="30%"><input type="submit" value="提交"></td>
        </tr>
        </form>
      </table>
    </td>
  </tr>
</table><br>
<c:set var="selectRSSQL" 
	value="select distinct core.lession_id as lession_id,
		class.class_name as class_name,student.class_id as class_id,
		lession.lession_name from core,student,lession,class 
		 where core.student_id=student.student_id and
		 student.class_id=class.class_id and lession.lession_id=core.lession_id"/>
<!--如果class_id请求参数不为空-->	  
<c:if test="${not empty param.class_id}">
	<c:set var="selectRSSQL"
		value="${selectRSSQL} and student.class_id=${param.class_id}
		and  class.class_id=${param.class_id} "/>
</c:if>
<!--如果lession_id请求参数不为空-->	  
<c:if test="${not empty param.lession_id}">
	<c:set var="selectRSSQL"
		value="${selectRSSQL} and lession.lession_id=${param.lession_id}
			 and core.lession_id=${param.lession_id} "/>
</c:if>
<c:set var="selectRSSQL"
	 value="${selectRSSQL}  order by class_id"/>
<!--查询出数据-->
<sql:query sql="${selectRSSQL}" 
  				var="coreCloseStatusCountRS" dataSource="${sqlDS}"/>
<!--得到总记录条数-->
<c:set var="coreCloseStatusCount" value="${coreCloseStatusCountRS.rowCount}"/>
<!--得到当前页的页号-->
<c:if test="${not empty param.page}">
  	<c:set var="page" value="${param.page}"/>
</c:if>
<c:if test="${empty param.page}">
  	<c:set var="page" value="1"/>
</c:if>
<!--设置每页显示记录条数-->
<c:set var="pageSize" value="10"/>
<!--计算总页数-->
<c:if test="${coreCloseStatusCount%pageSize==0}">
  	<c:set var="pageCount" value="${coreCloseStatusCount/pageSize}"/>
</c:if>
<c:if test="${coreCloseStatusCount%pageSize!=0}">
  	<c:set var="pageCount" value="${coreCloseStatusCount/pageSize+1-(coreCloseStatusCount%pageSize)/pageSize}"/>
</c:if>
<fmt:formatNumber value="${pageCount}" maxFractionDigits="0" var="pageCount"/> 
<!--得到当前页数据在SQL查询结果中的起始位置-->
<c:set var="startPosition" value="${(page-1)*pageSize}"/>
<!--查询出当前页的数据-->
<sql:query 
  	sql="${selectRSSQL}" 
  	var="coreCloseStatusRS" dataSource="${sqlDS}" startRow="${startPosition}" maxRows="${pageSize}"/>
<!---------数据输出------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
 <tr>
    <td colspan="5" align="center">
    	所有有成绩的班级的课程(共${coreCloseStatusCount}个)&nbsp;&nbsp;&nbsp;&nbsp;
    	<c:if test="${coreCloseStatusCount!=0}"> 
		当前第${page}页，共${pageCount}页&nbsp;&nbsp;
    	<c:if test="${page!=1}">
  			<a href="${pageContext.request.requestURL}?page=1&lession_id=${param.lession_id}&class_id=${param.class_id}">首页</a>&nbsp;
  			<a href="${pageContext.request.requestURL}?page=${page-1}&lession_id=${param.lession_id}&class_id=${param.class_id}">上一页</a>
  		</c:if>
  		<c:if test="${page!=pageCount}">
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${page+1}&lession_id=${param.lession_id}&class_id=${param.class_id}">下一页</a>
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${pageCount}&lession_id=${param.lession_id}&class_id=${param.class_id}">尾页</a>）
  		</c:if>
  		</c:if> 
 	</td>
  </tr>
  <tr>
    <td width="20%" align="center">班级名称</td>
    <td width="20%" align="center">课程名称</td>
    <td width="20%" align="center">目前封存状态</td>
    <td width="20%" align="center">封存？</td>
    <td width="20%" align="center">解封？</td>
  </tr>
<c:if test="${coreCloseStatusRS.rowCount>=1}">
  <c:forEach items="${coreCloseStatusRS.rowsByIndex}" var="cucN">
  <tr>
    <td align="center">${cucN[1]}</td>
    <td align="center">${cucN[3]}</td>
    <td align="center">
    <!--得到当前班级的当前课程的封存状态-->
    <c:set var="selectRSSQL" value="select distinct core.lession_id as lession_id,student.class_id as class_id,
    	core.close_status as close_status from core,student 
    	where core.student_id=student.student_id and student.class_id=${cucN[2]}
    	  and core.lession_id=${cucN[0]}"/>   	 
   	<sql:query sql="${selectRSSQL}" 
  				var="closeStatusRS" dataSource="${sqlDS}"/>
  	<c:choose>
  		<c:when test="${closeStatusRS.rowCount==0}">
  			未封存
  		</c:when>
  		<c:when test="${closeStatusRS.rowCount==2}">
  			部分封存
  		</c:when>
  		<c:when test="${closeStatusRS.rowCount==1}">		
  			<c:forEach items="${closeStatusRS.rowsByIndex}" var="cucNclose">
  				<c:choose>
  					<c:when test="${cucNclose[2]==0}">
  						未封存
  					</c:when>
  					<c:when test="${cucNclose[2]==1}">
  						已封存
  					</c:when>
  					<c:when test="${cucNclose[2]==2}">
  						部分封存
  					</c:when>
  				</c:choose>
  			</c:forEach>
  		</c:when>	
  	</c:choose>
    </td>
    <td align="center">
    <a href='core_close_save.jsp?class_id=${cucN[2]}&lession_id=${cucN[0]}'>封存</a></td>
    <td align="center">
    <a href='core_open_save.jsp?class_id=${cucN[2]}&lession_id=${cucN[0]}'>解封</a></td>
    </td>
  </tr>
  </c:forEach> 
</c:if> 
</table><br>
<!----------操作提示信息--------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
  <tr>
    <td width="100%">
      <table border="0" width="100%">
        <tr>
          <td width="100%">注意：1.如果封存状态为部分封存或未知，请再作一次封存或解封操作。<br>
         </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>
💿 文件大小 10976 K
👤 上传用户 feitiandy001
📂 所属分类 Java编程
🏷️ 相关标签

#JavaWeb #标签 #应用开发 #光盘
⌨️ 快捷键说明

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