I am not to get how I can remove duplicate values from ArrayList and I am getting values from DataBase using JDBC Template/Spring MVC and I am using this Array List values to display on JSP.Below is my code
@RequestMapping(value = "/getVendorExpenseByDateView", produces = MediaType.APPLICATION_JSON_VALUE, method = RequestMethod.POST)
public ResponseEntity<List<VendorExpensesByDateVO>> getVendorExpenseByDate(@RequestParam
String startDate,
@RequestParam String endDate) throws Exception {
System.out.println("From Get Vendor Expense ");
List<VendorExpensesByDateVO> helperList = new ArrayList<VendorExpensesByDateVO>();
SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
Date sdate = formatter.parse(startDate);
Date edate = formatter.parse(endDate);
SimpleDateFormat formatter1 = new SimpleDateFormat("yyyy-MM-dd");
startDate = formatter1.format(sdate);
endDate = formatter1.format(edate);
List<VendorExpensesByDateVO> vendorExpenseDateViewVOs = acapDataJDBCTemplate.getVendorExpenseDateView(startDate,
endDate);
for(VendorExpensesByDateVO vendorExpensesByDateVO :vendorExpenseDateViewVOs){
VendorExpensesByDateVO vender = new VendorExpensesByDateVO();
if(vendorExpensesByDateVO.getExpenseType().equalsIgnoreCase("In Court")){
System.out.println(" Service Date "+vendorExpensesByDateVO.getServiceDate());
System.out.println(" Claim Number "+vendorExpensesByDateVO.getClaimNumber());
System.out.println(" Expense type "+vendorExpensesByDateVO.getExpenseType());
System.out.println(" Description "+vendorExpensesByDateVO.getDescription());
System.out.println(" In Court Hours "+vendorExpensesByDateVO.getGetHours());
System.out.println("Total Cost "+vendorExpensesByDateVO.getTotalCost());
vender.setServiceDate(vendorExpensesByDateVO.getServiceDate());
vender.setClaimNumber(vendorExpensesByDateVO.getClaimNumber());
vender.setGetHours(vendorExpensesByDateVO.getGetHours());
vender.setDescription(vendorExpensesByDateVO.getDescription());
vender.setExpenseType(vendorExpensesByDateVO.getExpenseType());
vender.setTotalCost(vendorExpensesByDateVO.getTotalCost());
}
if(vendorExpensesByDateVO.getExpenseType().equalsIgnoreCase("Out of Court")||vendorExpensesByDateVO.getExpenseType().equalsIgnoreCase("Capital Out of Court")){
System.out.println(" Service Date "+vendorExpensesByDateVO.getServiceDate());
System.out.println(" Claim Number "+vendorExpensesByDateVO.getClaimNumber());
System.out.println(" Expense type "+vendorExpensesByDateVO.getExpenseType());
System.out.println(" Description "+vendorExpensesByDateVO.getDescription());
System.out.println(" Out Court Hours "+vendorExpensesByDateVO.getGetHours());
System.out.println("Total Cost "+vendorExpensesByDateVO.getTotalCost());
vender.setServiceDate(vendorExpensesByDateVO.getServiceDate());
vender.setClaimNumber(vendorExpensesByDateVO.getClaimNumber());
vender.setGetHours(vendorExpensesByDateVO.getGetHours());
vender.setDescription(vendorExpensesByDateVO.getDescription());
vender.setExpenseType(vendorExpensesByDateVO.getExpenseType());
vender.setTotalCost(vendorExpensesByDateVO.getTotalCost());
}
helperList.add(vender);
}
/*System.out.println(" Claim Number "+vendorExpensesByDateVO.getClaimNumber());
System.out.println(" Description "+vendorExpensesByDateVO.getDescription());
System.out.println(" Date "+vendorExpensesByDateVO.getServiceDate());*/
return new ResponseEntity<List<VendorExpensesByDateVO>>(helperList, HttpStatus.OK);
}