Dao类代码
@Override
public List find() {
SessionFactory sf = this.getHibernateTemplate().getSessionFactory();
Session s = sf.getCurrentSession();
List list = s.createSQLQuery(“SELECT b.dict_type_name,COUNT(*) AS count FROM cst_customer a,base_dict b WHERE a.cust_source=b.dict_id GROUP BY b.dict_item_name”)
.setResultTransformer(Transformers.aliasToBean(Count.class)).list();
for (Count count : list) {
System.out.println(count);
}
return null;
}
对象类:
public class Count {
private BigInteger count;
public String dict_type_name;
public String getDict_type_name() {
return dict_type_name;
}
public void setDict_type_name(String dict_type_name) {
this.dict_type_name = dict_type_name;
}
public BigInteger getCount() {
return count;
}
public void setCount(BigInteger count) {
this.count = count;
}
@Override
public String toString() {
return "Count [count=" + count + ", dict_type_name=" + dict_type_name + "]";
}
}