Hibernate distinct

 

/**
	 * 得到大区编号和名称
	 * @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>