booktypeview.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" %>
<fmt:requestEncoding value="gb2312"/>
<!------设置数据源------>
<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
<%@ page isELIgnored="false"%>
<c:if test="${not empty param.type_name}">
	<c:set var="insertSQL" value="insert into book_type(type_name)
		 values('${param.type_name}')"/>
	<sql:update sql="${insertSQL}" dataSource="${sqlDS}"/>
</c:if>
<!------系统交互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">
	<tr><td colspan="4">
		<font size="2" color="#000080">增加书藉类型</font>		
	</td></tr>
	<form action="booktypeview.jsp" method="post" focus="booktypename">
	<tr><td colspan="6"><font size="2" color="#000080">
		类型名称：<input type="text" name="type_name" size="40"/>
		<input type="submit" value="提交"/>
	</font></td></tr>
	</form>
<!------构造SQL语句------>
<c:set var="selectSQL" value="
	select type_id,type_name from book_type"/>
<c:set var="selectCountSQL" value="
	select count(*) from book_type"/>
<!------执行SQL查询------>
<sql:query sql="${selectCountSQL}" var="bookTypeCountRS" dataSource="${sqlDS}"/>
<!--得到总记录条数-->
<c:set var="typeCount" value="${bookTypeCountRS.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="${typeCount%pageSize==0}">
  	<c:set var="pageCount" value="${typeCount/pageSize}"/>
</c:if>
<c:if test="${typeCount%pageSize!=0}">
  	<c:set var="pageCount" value="${typeCount/pageSize+1-(typeCount%pageSize)/pageSize}"/>
</c:if>
<fmt:formatNumber value="${pageCount}" maxFractionDigits="0" var="pageCount"/>   
<!--得到当前页数据在SQL查询结果中的起始位置-->
<c:set var="startPosition" value="${(page-1)*pageSize}"/>
<!--查询出当前页的数据-->
<sql:query 
    var="bookTypeRS" dataSource="${sqlDS}" sql="${selectSQL}"
  	startRow="${startPosition}" maxRows="${pageSize}"/>	
	<tr><td colspan="4" align="right"><font size="2" color="#000080">
	所有书籍分类(共${typeCount}类)&nbsp;&nbsp;&nbsp;&nbsp;
    <c:if test="${typeCount!=0}"> 
     当前第${page}页，共${pageCount}页&nbsp;&nbsp;
  	<c:if test="${page!=1}">
  		<a href="${pageContext.request.requestURL}?page=1">首页</a>&nbsp;
  		<a href="${pageContext.request.requestURL}?page=${page-1}">上一页</a>
  	</c:if>
  	<c:if test="${page!=pageCount}">
  		&nbsp;<a href="${pageContext.request.requestURL}?page=${page+1}">下一页</a>
  		&nbsp;<a href="${pageContext.request.requestURL}?page=${pageCount}">尾页</a>）
  	</c:if>
  	</c:if>
	</td></tr>
	<tr><td align="center"><font size="2" color="#000080">ID号</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="${bookTypeRS.rowsByIndex}" var="bookType">
		<tr><td align="center"><font size="2" color="#000080">
			<c:out value="${bookType[0]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<c:out value="${bookType[1]}"/>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<a href="updatebooktype.jsp?type_id=${bookType[0]}">
			修改</a>&nbsp;</font></td>
			<td align="center"><font size="2" color="#000080">
			<a href="deleteBookType.jsp?type_id=${bookType[0]}"
			 onclick="return delete_confirm()">
			删除</a>&nbsp;</font></td>
		</tr>
	</c:forEach>
</table>
<jsp:include page="../adminmoduledown.jsp"/>