Springmvc+spring data is converted using the query.getresultlist () type of the Entitymanager class

Jpaquery.getresultlist the value method after SQL text execution

The return value may be a collection of objects or an array of objects

1,

String sql = "SELECT * from T_order where ..."

Entitymanager Emread;

Query qr = emread.createnativequery (sqlres);

return list<object[]> Listo = Qr.getresultlist ();

Use

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 ();

Use:

Double resum = double.parsedouble (listo.get (0). toString ());