modibook.jsp

JavaWeb标签应用开发（随书光盘）为方便读者阅读本书和调试程序

<%@ 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" %>
<%@ page isELIgnored="false"%>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<!------系统交互javascript----->
<script language="JavaScript">
<!--
function delete_confirm() {
//按删除链接时，弹出确认对话框
   if(confirm("确认要删除吗？")){
  		return true;
	}else return false;	
}
-->
</script>
<jsp:include page="../adminmoduleup.jsp"/>
<table border="1" cellpadding="0" cellspacing="0" width="610">
	<form action="modibook.jsp" method="post">
	<tr><td colspan="6"><font size="2" color="#000080">
	 查询条件<hr>书籍种类：
     <c:set var="selectSQL" value="select type_id,type_name from book_type"/>
     <sql:query sql="${selectSQL}" dataSource="${sqlDS}" var="bookTypeRS"/>
     <select name="book_type">
     <c:forEach items="${bookTypeRS.rowsByIndex}" var="bookType">
     	<option value="${bookType[0]}"
     	<c:if test="${bookType[0]==param.book_type}">selected </c:if>>
     	${bookType[1]}</option>
     </c:forEach>
     </select>
		<input type="submit" value="提交">
	</font></td></tr>
	</form>
</table><br>
<!------构造SQL语句------>
<c:set var="selectCountSQL" value="
	select count(*) from book"/>
<c:if test="${not empty param.book_type}">
	<c:set var="selectCountSQL" value="${selectCountSQL} where 
	type_id=${param.book_type}"/>
</c:if>
<c:if test="${empty param.book_type}">
	<c:set var="book_type" value="0"/>
</c:if>
<c:if test="${not empty param.book_type}">
	<c:set var="book_type" value="${param.book_type}"/>
</c:if>
<!--得到总记录条数-->
<sql:query sql="${selectCountSQL}" dataSource="${sqlDS}" var="bookCountRS"/>
<c:set var="bookCount" value="${bookCountRS.rowsByIndex[0][0]}"/>
<!--设置每页显示记录条数-->
<c:set var="pageSize" value="10"/>
<!--得到当前页的页号-->
<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:if test="${bookCount%pageSize==0}">
  	<c:set var="pageCount" value="${bookCount/pageSize}"/>
</c:if>
<c:if test="${bookCount%pageSize!=0}">
  	<c:set var="pageCount" value="${bookCount/pageSize+1-(bookCount%pageSize)/pageSize}"/>
</c:if>
<fmt:formatNumber value="${pageCount}" maxFractionDigits="0" var="pageCount"/> 
<c:set var="sqlStr" value="execute getPageTypeBooks ${page},${book_type},${pageSize}"/>
<sql:query dataSource="${sqlDS}" var="bookRS">
	${sqlStr}
</sql:query>
<table border="1" cellpadding="0" cellspacing="0" width="610">
	<tr><td colspan="6" align="right"><font size="2" color="#000080">
	所有书籍(共${bookCount}种)&nbsp;&nbsp;&nbsp;&nbsp;
    <c:if test="${bookCount!=0}"> 
     当前第${page}页，共${pageCount}页&nbsp;&nbsp;
  	<c:if test="${page!=1}">
  		<a href="${pageContext.request.requestURL}?page=1&book_type=${param.book_type}">首页</a>&nbsp;
  		<a href="${pageContext.request.requestURL}?page=${page-1}&book_type=${param.book_type}">上一页</a>
  	</c:if>
  	<c:if test="${page!=pageCount}">
  		&nbsp;<a href="${pageContext.request.requestURL}?page=${page+1}&book_type=${param.book_type}">下一页</a>
  		&nbsp;<a href="${pageContext.request.requestURL}?page=${pageCount}&book_type=${param.book_type}">尾页</a>
  	</c:if>
  	</c:if>		
	</td></tr>
	<tr><td align="center"><font size="2" color="#000080">ID号</font></td>
		<td width="200" align="center"><font size="2" color="#000080">书名</font></td>
		<td align="center"><font size="2" color="#000080">作者</font></td>
		<td align="center"><font size="2" color="#000080">出版社</font></td>
		<td align="center"><font size="2" color="#000080">修改?</font></td>
		<td align="center"><font size="2" color="#000080">删除?</font></td>
	</tr>
	<c:forEach items="${bookRS.rowsByIndex}" var="book">
		<tr><td align="center"><font size="2" color="#000080">
			<c:out value="${book[0]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:out value="${book[1]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:out value="${book[2]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:out value="${book[3]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<a href="updateBook.jsp?book_id=${book[0]}">
			修改</a>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<a href="deleteBook.jsp?book_id=${book[0]}" onclick="return delete_confirm()">
			删除</a>&nbsp;</font></td>
		</tr>
	</c:forEach>
</table>
<jsp:include page="../adminmoduledown.jsp"/>