【JPA】SpringBoot JPA 使用GroupBy 进行分组查询

转自https://blog.csdn.net/winnershili/article/details/80695218

首先建立一个实体 装数据用

public class OrderGoods {
    
    
    private Goods goods;
    
    private Integer year = 0; //年份
    
    private Integer month = 0;//月份
    private Integer day=0; //日期
        private Double num =0d;//该商品数量
 
 
}

其次Repository

    @RestResource(exported = false)
    @Query("select sum(t.num) as num,t.goods as goods from OrderformDetail t group by t.goods")
    List findGroupByGoods();

很简单 就是在订单详细表中 按商品分组 列出商品数量 方便进货

然后在Service 中

List<OrderGoods> list = new ArrayList<>();
    List _list = dao.findGroupByGoods();
    for(Object row:_list){
        Object[] cells = (Object[]) row;  
        OrderGoods orderGoods = new OrderGoods();
        orderGoods.setNum((Double) cells[0]);
        orderGoods.setGoods((Goods) cells[1]);
        list.add(orderGoods);
   }
return list;
关键语句 

Object[] cells = (Object[]) row;