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>