product_add.jsp

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

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

<%
	int proId = -1;
	boolean proIdValid = false;
	String _proId = request.getParameter("productId");
	try{
		proId = Integer.parseInt(_proId);
	}catch(NumberFormatException e){
		proId = -1;
	}
	
	if(proId<=9999 && proId>=0){
		pageContext.setAttribute("productIdValid",Boolean.TRUE);
		System.out.println("number valid");
		proIdValid = true;
	}else{
		pageContext.setAttribute("productIdValid",Boolean.FALSE);
		System.out.println("number invalid");
		proIdValid = false;
	}
	
 %>

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

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

<c:choose>
	<c:when test="${(pageScope.productIdValid) && (checkId.rowCount eq 0) && (checkName.rowCount eq 0) }">
	System.out.println("pass");
		<sql:update var="insertRows"
		  sql="insert into t_dic_product(id,name) values(?,?)" >
		  <sql:param value="${param.productId }"></sql:param>
		  <sql:param value="${fn:base64Decode(param.productName,'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>
	System.out.println("number invalid");
		<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>productId</name>
								<info><%=new String("产品编号已经存在".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						</c:if>
						<c:if test="${checkName.rowCount ne 0 }">
							<field>
								<name>productName</name>
								<info><%=new String("产品名称已经存在".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						</c:if>
						<%if(proIdValid==false){ %>
							<field>
								<name>productId</name>
								<info><%=new String("编号无效，正确的编号由四位数字组成".getBytes("iso-8859-1"),"utf-8") %></info>
							</field>
						<%} %>
				</fielderrors>
				<results>
				
				</results>
			</form>
			<list>
				
			</list>
		</response>	
	
	</c:otherwise>

</c:choose>