首页 > 编程语言 > 详细

Spring Data JPA 查询结果返回至自定义实体

时间:2021-06-28 19:39:43      阅读:29      评论:0      收藏:0      [点我收藏+]
    @Query(value = "select new com.sinosoft.sinoep.modules.hygl.meetingApply.dto.MeetingNumDto(a.creJuName as name,count(a.creJuName) as value) from MeetingApply as a where a.creUserDeptUnitType in (‘0‘,‘6‘,‘7‘) and a.meetingRoomId != ‘outside‘ and a.visible = ‘1‘ group by a.creJuName")
    List<MeetingNumDto> getNationalInsideMeetingNum();

DTO类

public class MeetingNumDto implements Serializable {

    private String name;
    private Long value;

    public MeetingNumDto() {
    }

    public MeetingNumDto(String name, Long value) {
        this.name = name;
        this.value = value;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Long getValue() {
        return value;
    }

    public void setValue(Long value) {
        this.value = value;
    }
}

Spring Data JPA 查询结果返回至自定义实体

原文:https://www.cnblogs.com/gkgkgk/p/14944265.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!