1.获得session
public void queryCustoemrCountByIndustry() {
getHibernateTemplate().execute(new HibernateCallback<List>() {
@Override
public List doInHibernate(Session session) throws HibernateException {
return null;
}
});
}
2.调用session进行执行sql语句
public List queryCustoemrCountByIndustry() {
List<Object> list = getHibernateTemplate().execute(new HibernateCallback<List>() {
@Override
public List doInHibernate(Session session) throws HibernateException {
String sql ="SELECT "+
"bd.`dict_item_name`, COUNT(*) total "+
"FROM "+
" customer c, "+
" base_dict bd "+
" WHERE "+
" c.`customerIndustry` = bd.`dict_id` "+
" GROUP BY c.`customerIndustry` "
SQLQuery query = session.createSQLQuery(sql);
List list = query.list();
return list;
}
});
return list;
}
注意:多表查询的条件查询方法进行补充时候的方法进行补充