public List<Category> findChildByParent(String pid){
Session session=HibernateUtils.openSession();
Transaction tx=session.beginTransaction();
String sql="select * from categorys where c_id=?";
Query query=session.createSQLQuery(sql);
query.setParameter(0, pid);
List<Category> list=query.list();
if(list!=null){
System.out.println("~~~~~~~~~~~~~~~~~~~~~~~"+list.get(0).getCname());
}
tx.commit();
session.close();
return list;
}
无法获取list.get(0).getCname()
错误提示:: [Ljava.lang.Object; cannot be cast to com.liveshop.category.entity.Category
------解决思路----------------------
Query query=session.createSQLQuery(sql);改成
Query query=session.createSQLQuery(sql).addEntity(Category.class);