updatebookaction.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"/>
<%@ page isELIgnored="false"%>
<jsp:include page="../adminmoduleup.jsp"/>
<!--数据校验的规则比较简单，读者可根据需要加入一些更多更复杂的检验规则-->
<!------数据校验------>
<c:if test="${(empty param.book_name) or (empty param.book_type)}">
	<c:redirect url="modibook.jsp"/>
</c:if>
<c:catch var="error">
	<fmt:parseDate value="${param.publish_date}" var="publish_date"
	pattern="yyyy'-'M'-'d"/>
	<!------设置数据源------>
	<sql:setDataSource dataSource="jdbc/sqlserver" var="sqlDS"/>
	<!------SQL语句------>
	<c:set var="updateSQL" value="update book set book_name='${param.book_name}',
		author='${param.author}',publisher='${param.publisher}',
		price=${param.price},price_rebate=${param.price_rebate},
		publish_date='${param.publish_date}',pagecount=${param.pagecount},
		format='${param.format}',simple_content='${param.simple_content}',
		type_id=${param.book_type} where book_id=${param.book_id}"/>
	<!------数据更新处理------>
	<sql:update sql="${updateSQL}" dataSource="${sqlDS}"/>
</c:catch>
<c:if test="${not empty error}">
	<c:redirect url="modibook.jsp"/>
</c:if>
<c:if test="${empty error}">
	修改书籍数据成功！
	<a href="modibook.jsp">返回</a>
</c:if>
<jsp:include page="../adminmoduledown.jsp"/>