vue +jpa 日期字段按年份查询解决方案

1、vue

// 按年时间范围查询
<el-date-picker
          style="width: 200px;"
          v-model="query.year"
          v-if="hasQuery(queryOptions,'year')"
          :default-time="['00:00:00','23:59:59']"
          type="year" placeholder="选择年"
          range-separator=":"
          size="small"
          class="date-item"
          value-format="yyyy-MM-dd HH:mm:ss"
          start-placeholder="年份起始"
          end-placeholder="年份截止"
        />

2、QueryCriteria 年份查询字段

// 接收开始时间与结束时间
 /** BETWEEN */
    @Query(type = Query.Type.BETWEEN)
    private List<Timestamp> year;

3、controll

 public ResponseEntity<Object> query(DataFosterBaseQueryCriteria criteria, Pageable pageable){
 //处理年份查询
        if(criteria.getYear() !=null && criteria.getYear().size() == 1)
        {
            List<Timestamp> yearlist = criteria.getYear();
            java.sql.Timestamp timestamp = (Timestamp) yearlist.get(0);
            long endtime =timestamp.getTime()+(long)1000*3600*24*365;
            Timestamp endTimestamp =new Timestamp(endtime);
            yearlist.add(endTimestamp);
            criteria.setYear(yearlist);
        }
        return new ResponseEntity<>(dataFosterBaseService.queryAll(criteria,pageable),HttpStatus.OK);
    }