jpaQuery.getResultList SQL文执行后的取值方法
返回值可能是一个对象集合亦可能是一个对象数组集合
1,
String sql = "select * from T_order where ...."
EntityManager emread;
Query qr = emread.createNativeQuery(sqlres);
return List<Object[]> listo = qr.getResultList();
使用
List<VO> list=new ArrayList<VO>();
for (Object[] objects : listo) {
VO vo=new VO();
int i=0;
vo.setxxx(Integer.parseInt(objects[i++].toString()));
//....
list.add(vo);
}
2,
String sql = "select SUM(money) monery from T_order where ...."
EntityManager emread;
Query qr = emread.createNativeQuery(sqlres);
return List<Object> listo = qr.getResultList();
使用:
Double reSum = Double.parseDouble(listo.get(0).toString());