Hibernate SQL查询 也是可以自动装实体的

主要是createSQLQuery后面要跟addEntity……

http://docs.jboss.org/hibernate/core/4.1/javadocs/org/hibernate/SQLQuery.html#addEntity(java.lang.Class)

http://docs.jboss.org/hibernate/core/4.1/manual/en-US/html/ch18.html#d5e8271

比如 

/** *  * findAllGoods:根据分类parent获取所有商品,暂未分页 * TODO 分页 *  * @author 刘各欢 * @param parentId * @return * @since 　Ver 1.1 */@SuppressWarnings("unchecked")public List<Goods> findAllGoods(String parentId){Session session = getSession();String sql = "";List<Goods> list = null;if(parentId == null ||"".equals(parentId)){sql = "SELECT * FROM t_goods WHERE cat IN (SELECT id FROM t_cat WHERE id IN (SELECT id FROM t_cat WHERE parent IS NULL))";Query query = session.createSQLQuery(sql).addEntity(Goods.class);list = query.list();}else{sql = "SELECT * FROM t_goods WHERE cat IN (SELECT id FROM t_cat WHERE id IN (SELECT id FROM t_cat WHERE parent = :parentId))";Query query = session.createSQLQuery(sql).addEntity(Goods.class);query.setParameter("parentId", parentId);list = query.list();}    return list;}