Package net.daveray.rewardsapi.srvc

Class QueryService

java.lang.Object

net.daveray.rewardsapi.srvc.QueryService

@Service
public class QueryService
extends Object

QueryService provides JDBC flavored persistence
contains the sql queries and executes prepared statements
returning data to the RewardsService

Since:

November 2023

Constructor Summary

Constructors

Constructor	Description
QueryService()

Method Summary

Modifier and Type	Method	Description
List<Map<String,Object>>	rewardsAll()
List<Map<String,Object>>	rewardsAllMonths(String month)
List<Map<String,Object>>	rewardsSingle(String month, String customerId)
List<Map<String,Object>>	rewardsSingleMonths(int monthBegin, String customerId, int monthEnd)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

QueryService

public QueryService()

Method Details

rewardsAll

public List<Map<String,Object>> rewardsAll()

rewardsAllMonths

public List<Map<String,Object>> rewardsAllMonths(String month)

rewardsSingle

public List<Map<String,Object>> rewardsSingle(String month,
 String customerId)

rewardsSingleMonths

public List<Map<String,Object>> rewardsSingleMonths(int monthBegin,
 String customerId,
 int monthEnd)