select 下拉框条件查询

最新推荐文章于 2023-06-14 15:43:48 发布

恩C

最新推荐文章于 2023-06-14 15:43:48 发布

阅读量1.4k

点赞数

分类专栏： java Spring mvc 文章标签： java多条件查询 spring mvc 下拉框查询

本文链接：https://blog.csdn.net/ensey/article/details/39396133

版权

java 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

Spring mvc

4 篇文章 0 订阅

订阅专栏

首先写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";
		}