insertbook.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="addbook.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="insertSQL" value="insert into book(book_name,
		author,publisher,price,price_rebate,publish_date,pagecount,
		format,simple_content,type_id) values('${param.book_name}',
		'${param.author}','${param.publisher}',${param.price},
		${param.price_rebate},'${param.publish_date}',${param.pagecount},
		'${param.format}','${param.simple_content}',${param.book_type})"/>
	<!------数据更新处理------>
	<sql:update sql="${insertSQL}" dataSource="${sqlDS}"/>
</c:catch>
<c:if test="${not empty error}">
	<c:redirect url="addbook.jsp"/>
</c:if>
<c:if test="${empty error}">
	增加书籍数据成功！
	<a href="modibook.jsp">返回</a>
</c:if>
<jsp:include page="../adminmoduledown.jsp"/>