test_save.jsp

来自「实现很多功能 实现很多功能 实现很多功能」· JSP 代码 · 共 29 行

<%@	include file="tags.jsp"%>

<sql:query var="stores" sql="select * from t_dic_chain_store where id=?">
	<sql:param value="${param.sid }"></sql:param>
</sql:query>
<sql:query var="products" sql="select * from t_dic_product where id=?">
	<sql:param value="${param.pid }"></sql:param>
</sql:query>
<c:choose>
<c:when test="${stores.rowCount eq 0 && products.rowCount eq 0}">
storeID and productID are invalid!<br/>
</c:when>
<c:when test="${stores.rowCount eq 0}">
storeID is invalid!<br/>
</c:when>
<c:when test="${products.rowCount eq 0}">
productID is invalid!<br/>
</c:when>
<c:otherwise>
	<sql:update sql="insert into t_data_sale_flow (product_code,store_code) values(?,?)">
		<sql:param value="${param.pid }"></sql:param>
		<sql:param value="${param.sid }"></sql:param>		
	</sql:update>
save successed!<br/>
</c:otherwise>
</c:choose>
<br/>
<input type="button" value="return" onclick="window.location.href='test_input.jsp'"/>