首先 写jsp页面
<select id="keyState" name="keyState">
<option value="" selected="selected">点击选择</option>
<option value="1">正常</option>
<option value="0">过期</option>
</select>
<span style="white-space:pre"> </span><input type="submit" value="查询" class="btn btn-primary">
<span style="white-space:pre"> </span><input type="submit" value="返回" οnclick="backFromIndex()" class="btn btn-primary">
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;
}
service中掺杂这text条件查询,还有index页面中全部查询
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";
}