📄 teachlessionman.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>
<jsp:include page="navigator.txt"/>
</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_teachlession_form" action="teachlessionman.jsp" method="post">
        <tr>
          <td width="33%" align="right">授课教师：</td>
          <td width="13%">
          <!-----生成教师下拉框------>
          <c:set var="selectRSSQL" value="select teacher_id,teacher_name from teacher"/>
          <sql:query sql="${selectRSSQL}" 
  			var="teacherRS" dataSource="${sqlDS}"/>
  		  <select name="teacher_id">
  		  	<option value="">====所有教师====</option>
  		  	<c:forEach items="${teacherRS.rowsByIndex}" var="cucN">
  		  		<option value="${cucN[0]}">${cucN[1]}</option>
  		  	</c:forEach>
  		  </select> 
          </td>
          <td width="10%" align="right">课程：</td>
          <td width="17%">
          <!-----生成课程下拉框------>
          <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>
<!-------生成查询数据库的SQL语句-------->
<c:set var="selectRSSQL" 
	value="select distinct teachlession.teachlession_id as teachlession_id,
	teachlession.teacher_id as teacher_id,teachlession.lession_id as lession_id,
	teacher.teacher_name as teacher_name,lession.lession_name as lession_name
	 from teachlession,teacher,lession where lession.lession_id=teachlession.lession_id
	  and teacher.teacher_id=teachlession.teacher_id"/>
<c:set var="selectCountSQL" 
	value="select count(*) as teachlessionCount 
	  from teachlession,teacher,lession where lession.lession_id=teachlession.lession_id
	  and teacher.teacher_id=teachlession.teacher_id"/>
<!--如果lession_id请求参数不为空-->	  
<c:if test="${not empty param.lession_id}">
	<c:set var="selectRSSQL" 
		value="${selectRSSQL} and lession.lession_id=${param.lession_id}
		 and teachlession.lession_id=${param.lession_id}"/>
	<c:set var="selectCountSQL" 
		value="${selectCountSQL} and lession.lession_id=${param.lession_id}
		 and teachlession.lession_id=${param.lession_id}"/>
</c:if>
<!--如果teacher_id请求参数不为空-->	  
<c:if test="${not empty param.teacher_id}">
	<c:set var="selectRSSQL" 
		value="${selectRSSQL} and teacher.teacher_id=${param.teacher_id}
		 and teachlession.teacher_id=${param.teacher_id}"/>
	<c:set var="selectCountSQL" 
		value="${selectCountSQL} and teacher.teacher_id=${param.teacher_id}
		 and teachlession.teacher_id=${param.teacher_id}"/>
</c:if>
<!--查询出总记录条数-->
<sql:query sql="${selectCountSQL}" 
  				var="teachlessionCountRS" dataSource="${sqlDS}"/>
<!--得到当前页的页号-->
<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="teachlessionCount" value="${teachlessionCountRS.rowsByIndex[0][0]}"/>
<!--设置每页显示记录条数-->
<c:set var="pageSize" value="10"/>
<!--计算总页数-->
<c:if test="${teachlessionCount%pageSize==0}">
  	<c:set var="pageCount" value="${teachlessionCount/pageSize}"/>
</c:if>
<c:if test="${teachlessionCount%pageSize!=0}">
  	<c:set var="pageCount" value="${teachlessionCount/pageSize+1-(teachlessionCount%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="teachlessionRS" 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">
    	所有教师授课信息(共${teachlessionCount}条)&nbsp;&nbsp;&nbsp;&nbsp;
    	<c:if test="${teachlessionCount!=0}"> 
		当前第${page}页，共${pageCount}页&nbsp;&nbsp;
    	<c:if test="${page!=1}">
  			<a href="${pageContext.request.requestURL}?page=1&lession_id=${param.lession_id}&teacher_id=${param.teacher_id}">首页</a>&nbsp;
  			<a href="${pageContext.request.requestURL}?page=${page-1}&lession_id=${param.lession_id}&teacher_id=${param.teacher_id}">上一页</a>
  		</c:if>
  		<c:if test="${page!=pageCount}">
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${page+1}&lession_id=${param.lession_id}&teacher_id=${param.teacher_id}">下一页</a>
  			&nbsp;<a href="${pageContext.request.requestURL}?page=${pageCount}&lession_id=${param.lession_id}&teacher_id=${param.teacher_id}">尾页</a>）
  		</c:if>
  		</c:if>
    </td>
  </tr>
  <tr>
    <td width="20%" align="center">教师授课信息序号</td>
    <td width="15%" align="center">教师姓名</td>
    <td width="25%" align="center">所教课程</td>
    <td width="20%" align="center">修改？</td>
    <td width="20%" align="center">删除？</td>
  </tr>
<c:if test="${teachlessionRS.rowCount>=1}">
  <c:forEach items="${teachlessionRS.rowsByIndex}" var="cucN">
  <tr>
    <td align="center" width="132">${cucN[0]}</td>
    <td align="center" width="163">${cucN[3]}</td>
    <td align="center" width="234">${cucN[4]}</td>
    <td align="center" width="176">
    <a href='teachlession_update1.jsp?lession_id=${cucN[2]}&teacher_id=${cucN[1]}'>修改</a>
    </td>
    <td align="center" width="176">
    <a href="teachlession_delete.jsp?lession_id=${cucN[2]}&teacher_id=${cucN[1]}" onclick="return delete_confirm()">×</a>
    </td>
  </tr>
  </c:forEach> 
</c:if> 
</table><br>
</body>
</html>
💿 文件大小 10976 K
👤 上传用户 feitiandy001
📂 所属分类 Java编程
🏷️ 相关标签

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

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