方式一:
String sql="select fi.id, fi.name FROM meeting_fee_item mfi,fee_item fi " +
"where fi.id=mfi.feeitemid and mfi.id=" + meetingFeeItemId;
Session session = getSessionFactory().getCurrentSession();
Query query=session.createSQLQuery(sql);
List alist= query.list();
List<FeeItem> list = new ArrayList<FeeItem>();
if (alist != null && alist.size() > 0) {
for (int i = 0; i < alist.size(); i++) {
Object[] objects = (Object[]) alist.get(i);
FeeItem feeItem = new FeeItem();
feeItem.setId((Integer) objects[0]); // id必须的
feeItem.setName((String) objects[1]); 相对应的配置所查询的字段,如fi.id,f.name,有多少个,就相应配
System.out.println("object: "+(String) objects[1]);
list.add(feeItem);
}
}
return list;
}
解决了类型转换异常问题。。
方式二:
回调模式
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String sql = "select *,d.roomNo as roomNo from (select a.id,a.name,a.zwu,b.name as unitsName,b.address,b.zip,a.phone,a.mail,a.cellphone from user a,units b where a.unitsId=b.id ";
if (unitsTypeId != null && unitsTypeId != 0) {
sql += " and b.unitstypeid=" + unitsTypeId;
}
sql += " ) c left join register d on c.id=d.userid ";
SQLQuery q = session.createSQLQuery(sql).addScalar("name",
Hibernate.STRING).addScalar("zwu", Hibernate.STRING)
.addScalar("unitsName", Hibernate.STRING).addScalar(
"address", Hibernate.STRING).addScalar("zip",
Hibernate.STRING).addScalar("phone",
Hibernate.STRING).addScalar("mail",
Hibernate.STRING).addScalar("cellphone",
Hibernate.STRING).addScalar("roomNo",
Hibernate.STRING);
。。。。
下面进行类型转换,大致如上一。