hql、sql、还有标准查询

hql查询：

@Override
public Page<Topic> getTopicByTitle(String title, Pageable page) {


if (StringUtils.isEmpty(title)) {
return null;
}
Map<String, Object> filterMap = new HashMap<String, Object>();
String hql = "from Topic  where  title like :title";

filterMap.put("title", "%" + title + "%");
return super.getPages(hql, filterMap, page);
}

sql查询：

@Override
public Page<Map<String, Object>> getMyTopicByTitle(String title,
List<String> resourceId, Pageable page) {
if (StringUtils.isEmpty(title)) {
return null;
}


StringBuffer sql = new StringBuffer();
sql.append("select a.*,b.name,c.real_name ");
sql.append("from discuss.diz_topic as a ");
sql.append("INNER JOIN discuss.diz_circle as b ");
sql.append("ON a.title like :title and a.resource_id=b.id ");
sql.append("INNER JOIN discuss.sys_user as c ");
sql.append("on a.create_userid=c.id ");
sql.append("where a.resource_id in :resourceId");
// 分页处理
SQLQuery queryPage = (SQLQuery) getSession().createSQLQuery(
sql.toString()).setResultTransformer(
Transformers.ALIAS_TO_ENTITY_MAP);
queryPage.setParameter("title", "%" + title + "%");
queryPage.setParameterList("resourceId", resourceId);
List<Map<String, Object>> items = queryPage.list();
Long allCounts = (long) items.size();
queryPage.setFirstResult(page.getOffset());
queryPage.setMaxResults(page.getPageSize());
List<Map<String, Object>> list = queryPage.list();
Page<Map<String, Object>> pager = new PageImpl<Map<String, Object>>(
list, page, allCounts);
return pager;
}