</pre><pre code_snippet_id="365431" snippet_file_name="blog_20140527_2_1782753" name="code" class="html">
@SuppressWarnings({ "unchecked", "rawtypes" })
@Override
public List<Map<String, Object>> getWomenClass(final int num) {
final String hql = "select id as id, name as name from BaseClassBean " +
" where(id >100100 and id < 100200)or (id >100300 and id < 100400) ";
return hibernateTemplate.execute(new HibernateCallback() {
@Override
public List<Map<String, Object>> doInHibernate(Session session)
throws HibernateException, SQLException {
return session.createQuery(hql).setMaxResults(num)
.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP).list();
}
});
}
返回结果:
[{id=100103, name=衬衫}, {id=100301, name=连衣裙}, {id=100106, name=风衣}, {id=100104, name=西服}, {id=100105, name=外套}, {id=100102, name=POLO}, {id=100101, name=T恤}, {id=100108, name=羊毛衫}, {id=100303, name=牛仔裤}, {id=100304, name=铅笔裤}, {id=100306, name=短裤}, {id=100112, name=羽绒服}, {id=100113, name=皮草}, {id=100114, name=皮衣}, {id=100307, name=内裤}, {id=100117, name=毛衣}, {id=100116, name=POLO}, {id=100110, name=吊带/背心}, {id=100111, name=马甲}, {id=100302, name=休闲裤}]