chain_store_add.jsp.svn-base

实现很多功能 实现很多功能 实现很多功能

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

<%
	int stoId = -1;
	boolean stoIdValid = false;
	String _stoId = request.getParameter("storeId");
	try{
		stoId = Integer.parseInt(_stoId);
	}catch(NumberFormatException e){
		stoId = -1;
	}
	
	if(stoId<=9999 && stoId>=0){
		pageContext.setAttribute("storeIdValid",Boolean.TRUE);
		
		stoIdValid = true;
	}else{
		pageContext.setAttribute("storeIdValid",Boolean.FALSE);
		
		stoIdValid = false;
	}
	
 %>

<sql:query var="checkId" sql="select id from t_dic_chain_store where id=?">
	<sql:param value="${param.storeId }"/>
</sql:query>

<sql:query var="checkName" sql="select id from t_dic_chain_store where name=?">
	<sql:param value="${fn:base64Decode(param.storeName,'utf-8') }"/>
</sql:query>

<c:choose>
	<c:when test="${(pageScope.storeIdValid) && (checkId.rowCount eq 0) && (checkName.rowCount eq 0) }">

		<sql:update var="insertRows"
		  sql="insert into t_dic_chain_store(id,name) values(?,?)" >
		  <sql:param value="${param.storeId }"></sql:param>
		  <sql:param value="${fn:base64Decode(param.storeName,'utf-8') }"></sql:param>
		</sql:update>


		<response>
			<server>
				<needlogin>false</needlogin>
				<needprivilege>false</needprivilege>
				<error>false</error>
			</server>
			<form>
				<accept>true</accept>
				
				<fielderrors>
						<field>
							<name>spacer</name>
							<info>spacer</info>
						</field>
				</fielderrors>
				<results>
				
				</results>
			</form>
			<list>
				
			</list>
		</response>
	
	</c:when>
	
	<c:otherwise>
		<response>
			<server>
				<needlogin>false</needlogin>
				<needprivilege>false</needprivilege>
				<error>false</error>
			</server>
			<form>
				<accept>false</accept>
				
				<fielderrors>
						<field>
							<name>spacer</name>
							<info>spacer</info>
						</field>
						<c:if test="${checkId.rowCount ne 0 }">
							<field>
								<name>storeId</name>
								<info><%=new String("连锁店编号已经存在".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						</c:if>
						<c:if test="${checkName.rowCount ne 0 }">
							<field>
								<name>storeName</name>
								<info><%=new String("连锁店名称已经存在".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						</c:if>
						<%if(stoIdValid==false){ %>
							<field>
								<name>storeId</name>
								<info><%=new String("编号无效，正确的编号由四位数字组成".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						<%} %>
				</fielderrors>
				<results>
				
				</results>
			</form>
			<list>
				
			</list>
		</response>	
	
	</c:otherwise>

</c:choose>