String sql="from Member m where m.state= '有效'"; Session session =HibernateSessionFactory.getSession(); Query q = session.createQuery(sql); List list =query.list(); SQLQuery 返回的当然不是对象了
String sql="select memberno, username shopID from member where state= '有效 '"; Session session =HibernateSessionFactory.getSession(); SQLQuery query =session.createSQLQuery(sql); List list =query.list(); Iterator it = list.iterator(); while(it.hasNext()){ Object[] ob = (Object[])it.next(); System.out.println("memberno:"+ob[0]); System.out.println("username:"+ob[1]); System.out.println("shopID:"+ob[2]); } 解决了请结贴给分,谢谢
Session session =HibernateSessionFactory.getSession();
Query q = session.createQuery(sql);
List list =query.list(); SQLQuery 返回的当然不是对象了
返回的不是实体对象,而是一个Map
因此list.get(i);要强制转型为Map,而不是你的实体对象
Session session =HibernateSessionFactory.getSession();
SQLQuery query =session.createSQLQuery(sql);
List list =query.list();
Iterator it = list.iterator();
while(it.hasNext()){
Object[] ob = (Object[])it.next();
System.out.println("memberno:"+ob[0]);
System.out.println("username:"+ob[1]);
System.out.println("shopID:"+ob[2]);
}
解决了请结贴给分,谢谢