Spring Data jPA 链表由子表查询主表并按条件显示数据

最新推荐文章于 2024-09-26 17:36:49 发布

朴丶心

最新推荐文章于 2024-09-26 17:36:49 发布

阅读量253

点赞数 5

文章标签：链表数据结构

本文链接：https://blog.csdn.net/qq_52054879/article/details/139861121

版权

创建一个对象接收返回值

@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class VehicleArrangementVo  {

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime startTime;

    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime endTime;

    /**
     * 挖机编号
     */
    private String excavatorCode;
    /**
     * 作业点编号
     */
    private String pointCode;
    /**
     * 作业平台编号
     */
    private String operatingPlatform;
    /**
     * 操作人
     */
    private String addPlanPeople;
    /**
     * 车辆编号
     */
    private String code;

查询所需数据并对查询出来的值与我们接受返回对象字段的绑定

 @Override
    public Page<VehicleArrangementVo> queryVehicleArrangement3(VehicleArrangementVo vehicleArrangementVoInfo) {

Mp<String, Object> parameters = new HashMap<String, Object>();

Page<VehicleArrangementVo> page = Page.init();

StringBuffer buffer = new StringBuffer();
buffer.append(" VehicleArrangementCodeContent ");
buffer.append(" p  ");
      
        List<VehicleArrangementCodeContent> results = query.getResultList();
        List<VehicleArrangementVo> datas = new ArrayList<VehicleArrangementVo>();
        for (VehicleArrangementCodeContent r : results) {
            VehicleArrangementVo data = VehicleArrangementVo.builder()
                    .startTime(r.getVehicleArrangement().getStartTime()).endTime(r.getVehicleArrangement().getEndTime())
                    .code(r.getCode()).pointCode(r.getVehicleArrangement().getPointCode()).operatingPlatform(r.getVehicleArrangement().getOperatingPlatform())
                    .addPlanPeople(r.getVehicleArrangement().getAddPlanPeople())
                    .excavatorCode(r.getVehicleArrangement().getExcavatorCode()).build();
            datas.add(data);
            log.debug("zhi:{}", datas);
        }
        page.setData(datas);