LinkedHashMap<String, Object> hasMap = new LinkedHashMap<>(); hasMap.put("adcd", adcd); hasMap.put("name", name); hasMap.put("mobile", mobile); List<Map<String, Object>> list = vwWarningHystNewService.execProc("pro_adcd_warn_receiver", hasMap); long startPage = (long) pageSize * (pageNumber - 1); List<Map<String, Object>> collect = list.stream().skip(startPage).limit(pageSize).collect(Collectors.toList()); PageData<List<Map<String, Object>>> pageData = new PageData(list.size(), collect);
sqlServer
@Query(value = "exec Pro_Section_Water_Level_New @dt=?1,@adcd=?2", nativeQuery = true) List<Map<String, Object>> getSectionWaterLevel(Timestamp timestamp,String adcd);