hibernate

1.createSQLQuery  ，sql语句。如果是HQL语句用createQuery

String sql1="SELECT i.groupid from wanbu_group_info i INNER JOIN wanbu_group_user u ON i.groupid=u.groupid where u.userid="+userid+" and i.activeid=-1 and i.forefathergroupid=-1";

Query queryObject1 = getSession().createSQLQuery(sql1).addScalar("groupid",StandardBasicTypes.INTEGER);   

addScalar：将获取的id封装到groupid中

List<Integer> list1=queryObject1.list(); 装入list

2.Query query =session.createSQLQuery(sql).addEntity(XXXXXXX.class); 将查出的数据封装到实体中