/**
   * 得到大区编号和名称
   * @return
   */
  public List<Object> getRegionCodeAndName() throws DataAccessException {
    finder = new Finder("")
    .append(" SELECT DISTINCT dlaid, dlaname FROM ClubDealerSmallArea c ")
    .append(" ORDER BY dlaid ");
    return findO(finder);
  }

 

distinct 后，得到的是对象数组，是object[]，取值的话直接用object[i]

 

@SuppressWarnings("unchecked")
  public List<Object> findO(Finder finder) throws DataAccessException {
    try {
      Query query = getSession().createQuery(finder.getOrigHql());
      finder.setParamsToQuery(query);
      query.setFirstResult(finder.getFirstResult());
      if (finder.getMaxResults() > 0) {
        query.setMaxResults(finder.getMaxResults());
      }
      List list = query.list();
      if(list!=null && list.size()<1)
        list = null;
      return list;
    } catch (Exception e) {
      log.error("method:find(Finder finder)",e);
      throw new DataAccessException();
    }
  }

 在action中set到request中

setRequestAttr("objList", objList);

 在jsp页面中：

选择经销商：
          大区
          <select id="region" name="region">
            <option value="0">---请选择---</option>
            <c:forEach items="${objList }" var="obj">
              <option value="${obj[0] }">${obj[1] }</option>
            </c:forEach>
          </select>