在Struts2中，使用绑定select进行页面查询

  使用绑定数据的select框作为查询条件进行列表查询参考小例子

1 自定义下拉框Vo对象

publicclass GameNameSelectVO {
 
    private String id; //游戏名称ID
    private String gameName; //游戏名称
 
    public String getId() {
       return id;
    }
    public voidsetId(String id) {
       this.id = id;
    }
    public String getGameName() {
       return gameName;
    }
    public voidsetGameName(String gameName) {
       this.gameName = gameName;
    }
}

2 Action 作为查询控制器

privateList<GameNameSelectVO> gameNameList;   //页面游戏名称下拉对象集合
private String gameNameID;            //游戏名称
需要提供get set方法

方法

/**
	 * 进入游戏参数查询页面
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public String toParameterPage(){
		
		//获得省份信息
		fundvo = gameInfoMonitorService.getProvinceInfo(String.valueOf(pid));		
		if(null == gameNameID){
			gameNameID = "0";//初始查询全部
		}
		//获得游戏名称下拉数据集合
		gameNameList = gameInfoMonitorService.getGameNameSelectList();
		
		//得到每页记录数
		PropertyUtil p = new PropertyUtil();
		int pageSize = Integer.parseInt(p.getProperty("/system.properties", "account.alarm.pageSize"));
		// 获得查询记录总数
		int count = gameInfoMonitorService.getParameterListCount();		
		// 根据总记录数、每页记录数、当前页码生成分页对象
		page = new Page<GameInfoPageVO>(count, pageSize, getCurrentPage());
		
		gameInfoVOList = gameInfoMonitorService.getParameterList(gameNameID,page.getCurrentPage(),page.getPageSize());		
		
		return "parameterPage";		
	}

3 Impl 实现类

    /**
     * 获得游戏名称下拉集合
     */
    public List<GameNameSelectVO>getGameNameSelectList() {
       StringBuffer hql = new StringBuffer();
       hql.append(" select rd.id,rd.game_name fromT_RCVD_GAME_DEFINITION rd " );
       List<GameNameSelectVO>  volist = new ArrayList<GameNameSelectVO>();
       try{
           List list = hibernateDao.queryBySql(hql.toString());
          
           for(Iterator it =list.iterator();it.hasNext();){
              Object [] objs = (Object[])it.next();
              GameNameSelectVO vo = new GameNameSelectVO();
              vo.setId(objs[0].toString());
              vo.setGameName(objs[1].toString());
              volist.add(vo);
           }
       }catch(Exception e){e.printStackTrace();}    
       return volist;
    }

4 JSP页面

     <div class="searchtime">
            游戏名称：<select name="gameNameID" id="" style="width: 10%;"  >
                             <option value="0">--全部--</option>
                             <s:iterator value="gameNameList"  var="gameNameVo">
                                   <option  value="<s:property value="id"/>" <c:if test="${gameNameVo.id eq gameNameID }" >selected</c:if> >   <s:property value="gameName"/></option>
                             </s:iterator>
               </select>
             <input type="submit" value="查询" class="button"/>
           </div>