SQL query return Boolean if data not exists in DB

 DB Table: 

Result Should be like below:

SQL Query: 

SELECT v.oid,
       (CASE WHEN EXISTS (SELECT 1
      FROM hrm.ap_award_type p
      WHERE p.oid = v.oid
     ) 
     THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT)
END) AS status
FROM (VALUES ('3b54e055-4c8a-40ea-a021-0e872cfc98c3'),
             ('caba5162'),
             ('10000'),
             ('b6d792aa-4bc3-4197-ae1e-f8c921f9ca8b')
) v(oid)

Java List to Map

 Set<String> oids = attendanceListResponseBodyDTOS.stream().map(o -> o.getOid()).collect(Collectors.toSet());

List<AttendanceDTO> resultDB = attendanceService.convertForRead(

attendanceService.getRepository().findByOidInAndIsDeleted(oids,Api.NO)

);

Map<String, AttendanceDTO> attendanceDTOMap = resultDB.stream().collect(

Collectors.toMap(AttendanceDTO::getOid, att -> att)

);

Java List interface sort

Sort by created date ascending

List<UniversalShiftDTO> result1 = new ArrayList<>();

result1.sort(Comparator.comparing(UniversalShiftDTO::getCreatedOn));

Sort by created date descending

List<UniversalShiftDTO> result1 = new ArrayList<>();

result1.sort(Comparator.comparing(UniversalShiftDTO::getCreatedOn).reversed());

Java 8

Return new list sorted by created date ascending

List<UniversalShiftDTO> result1 = new ArrayList<>();

result1 = result1.stream().sorted(Comparator.comparing(UniversalShiftDTO::getCreatedOn)).collect(Collectors.toList());

Return new list sorted by created date descending

List<UniversalShiftDTO> result1 = new ArrayList<>();

result1 = result1.stream().sorted(Comparator.comparing(UniversalShiftDTO::getCreatedOn).reversed()).collect(Collectors.toList());

JSON to java object

@Autowired

ModelMapper modelMapper;

Map<String, Object> metaRequest = dto.getMeta();

MetaSort sort = null;

if (null != metaRequest.get("sort")){

sort = modelMapper.map(metaRequest.get("sort"), MetaSort.class);

}

java object to JSON

@Autowired

ObjectMapper objectMapper;

objectMapper.writeValue(new File("./test.json"),listServiceRequestDTO);