您的查询返回了
Listof,
Object[]因为您没有选择
EquipEntity,而是只选择了中的列:
Query query = manager.createNativeQuery("SELECT" + " checksl.id_check_lists as IdCheckLists," + " checksl.titre_check as NomCheckLists," + " checksl.recommendation as Recommendation, " + " resp.id_responsescheck as IdResponse, " + " resp.conformite as Conformite, " + " resp.date_response as DateResponse, " + " resp.missions_id as IdMission "Hibernate不会将
ResultSet结果转换为
Equip实体对象,结果将是的数组,
object因为Hibernate不会确定所选列的类型。
您需要遍历此
List元素,然后将每个元素手动转换
Object[]为
Equip对象。
编辑:
这是您应如何实施:
List<Object[]> res = query.getResultList();List<Equip> list= new ArrayList<Equip>();JSonObject obj = new JSonObject();Iterator it = res.iterator();while(it.hasNext()){ Object[] line = it.next(); Equip eq = new Equip(); eq.setIdEquipement(line[0]); eq.setTitre(line[1]); eq.setDescription(line[2]); //And set all the Equip fields here //And last thing add it to the list list.add(eq);}


