Spring MVC+Portlet 多条件查询

Service

	/**
	 * query All
	 * @param page
	 * @return
	 */
	public List<KmEntity> getAllInfo(Page page,String userName,String keyState){
		StringBuffer hql= new StringBuffer("from KmEntity where 1=1");
		if(userName!=null&&!"".equals(userName)){
		hql.append(" and userName like'%"+userName+"%'");}
		if(keyState!=null&&!"".equals(keyState)){
		hql.append(" and keyState = "+Integer.parseInt(keyState)+"");
		}
		List<KmEntity>  kmEntityList = this.getListPage(page,null,hql.toString(),null);
		return kmEntityList;
	}

portlet

	/**
	 * index show info
	 * @param request
	 * @param model
	 * @return
	 */
		@RequestMapping
		public String index(Model model,String userName,String keyState,PortletRequest request){
			Page page = new Page();
			page.load(request);
			model.addAttribute("userName",userName);
			if(!"".equals(keyState)&&keyState!=null){
			model.addAttribute("keyState",Integer.parseInt(keyState));
			}
			List<KmEntity> kmList = service.getAllInfo(page,userName,keyState);
			model.addAttribute("kmList",kmList);
			model.addAttribute("page",page);
			return "index";
		}

jsp

<!-- 提交后 如果方法返回的是页面 （页面名称字符串）用 renderURL ； 如果提交的方法返回的是 方法 那么用actionURL-->

	<form id="indexForm" action="<portlet:renderURL><portlet:param name="action" value="index"></portlet:param></portlet:renderURL>" method="post">
	
		<div class="row">
		<div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
			<div class="input-group">
				<span class="input-group-addon">按用户名称 </span>
				<input type="text" id="userName" name="userName" class="form-control" value="${userName}"/>
			</div>
		</div>
		<div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
			<div class="input-group">
				<span class="input-group-addon">按密钥状态</span>
					<select id="keyState" name="keyState"  class="form-control">
					<option value="" selected="selected">点击选择</option>
    				<option value="1">正常</option>
    				<option value="0">过期</option>
    	 		</select>
			</div>
		</div>
			<input type="submit" value="查询" class="btn btn-primary">
			<input type="submit" value="返回" οnclick="backFromIndex()" class="btn btn-primary">
			<a class="btn btn-primary" href="<portlet:renderURL><portlet:param name="action" value="toAddPageAction"></portlet:param></portlet:renderURL>">添加</a>
	</div>

	<c:choose>
		<c:when test="${kmList.size()>0}">
	
	<table class="table table-bordered table-striped with-check">
			<tr>
				<th>用户名称</th>   
				<th>密钥</th>
				<th>密钥状态</th>
				<th>创建时间</th>
				<th colspan="2">操作</th>
			</tr>	
		<c:forEach var="kmList" items="${kmList}">
			<tr align="center">
				 <td>${kmList.userName}</td>
				 <td>${kmList.secretKey}</td>
				 <td>
				 <c:choose>
				 	<c:when test="${kmList.keyState==0}">过期</c:when>
				 	<c:when test="${kmList.keyState==1}">正常</c:when>
				 </c:choose>
				 </td>
			 	 <td>${kmList.createTime}</td>
				<td><a href="<portlet:renderURL><portlet:param name="action" value="toeditKm"></portlet:param><portlet:param name="kmId" value="${kmList.kmId}"></portlet:param></portlet:renderURL>">修改信息</a></td>
				<td><a href="<portlet:actionURL><portlet:param name="action" value="delKm"></portlet:param><portlet:param name="kmId" value="${kmList.kmId}"></portlet:param></portlet:actionURL>">删除</a></td>
			</tr>
		</c:forEach>
	</table>
			<div class="row">
				<div class="col-lg-12 txt-fl-right">
					<jsp:include page="/common/pagination.jsp" />     
				</div>
			</div>
	
		</c:when>
		<c:otherwise>
				没有查询结果
		</c:otherwise>
	</c:choose>

	</form>