java JPA:从多行查询结果创建JSON对象
是否可以从返回多行的查询中创建自定义JSON结果
存储库
@Query("SELECT new DTO.KaytDto(d.id, e.name) "
+ "FROM Session e INNER JOIN e.users d WHERE d.id=999")
现在,这当然会打印JSON对象数组,该数组包含的对象数量与数据库中的行数相同:
[{"id":999,"name":John"},
{"id":999,"name":Peter"}]
是否可以将其转换为以下JSON对象格式:
[{
"Names": {
"name": ["John", "Peter"]
}
}]
DTO类
public class KaytDto {
private Long Id;
private String name;
public KaytDto(Long Id, String name) {
this.Id = Id;
this.name = name;
}
//setters/getters
@Override
public String toString() {
return "KaytDto [name=" + name + ", id=" + Id + "]";
}
}
共 (0) 个答案