modiorderstatus.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" %>
<%@ page isELIgnored="false"%>
<c:if test="${empty sessionScope.user_id}">
	<c:redirect url="index.jsp"/>
</c:if>
<c:if test="${(empty param.order_form_id) or (empty param.status)}">
	<c:redirect url="index.jsp"/>
</c:if>
<!------设置数据源------>
<sql:setDataSource 
  	dataSource="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bookstore,com.microsoft.jdbc.sqlserver.SQLServerDriver,sa,19871127"
	var="sqlDS"/>
<c:set var="selectSQL" value="
	select order_form_id,status from order_form
	 where order_form_id=${param.order_form_id}"/>	 
<sql:query sql="${selectSQL}" var="orderRS" dataSource="${sqlDS}"/>
<c:choose>
	<c:when test="${param.status==1 and orderRS.rowsByIndex[0][1]==0}">
		<c:set var="updateSQL" value="
			update order_form set status=1 where order_form_id=${param.order_form_id}"/>
		<sql:update sql="${updateSQL}" dataSource="${sqlDS}"/>
	</c:when>
	<c:when test="${param.status==2 and orderRS.rowsByIndex[0][1]==1}">
		<c:set var="updateSQL" value="
			update order_form set status=2 where order_form_id=${param.order_form_id}"/>
		<sql:update sql="${updateSQL}" dataSource="${sqlDS}"/>
	</c:when>
	<c:when test="${param.status==3 and orderRS.rowsByIndex[0][1]==2}">
		<c:set var="updateSQL" value="
			update order_form set status=3 where order_form_id=${param.order_form_id}"/>
		<sql:update sql="${updateSQL}" dataSource="${sqlDS}"/>
	</c:when>
	<c:when test="${param.status==4 and orderRS.rowsByIndex[0][1]==2}">
		<c:set var="updateSQL" value="
			update order_form set status=4 where order_form_id=${param.order_form_id}"/>
		<sql:update sql="${updateSQL}" dataSource="${sqlDS}"/>
	</c:when>
	<c:when test="${param.status==5 and (orderRS.rowsByIndex[0][1]==4 or orderRS.rowsByIndex[0][1]==0)}">
		<sql:transaction dataSource="${sqlDS}">
			<c:set var="deleteSQL" value="
				delete from order_form_book where order_form_id=${param.order_form_id}"/>
			<sql:update sql="${deleteSQL}"/>
			<c:set var="deleteSQL" value="
				delete from order_form where order_form_id=${param.order_form_id}"/>
			<sql:update sql="${deleteSQL}"/>
		</sql:transaction>
	</c:when>
</c:choose>
<c:redirect url="${param.redirect_page}"/>