java - how to pass a argument to choose sql statement in spring API? -

now write 2 api, both of process similar,but difference in sql statement.

my problems are:

can merge 1 process argument, role of argument used select sql statemnt?

how design sql statement?

how build process?

@requestmapping(value="/positions" ,method = requestmethod.get, produces = mediatypes.json_utf_8) public list<weeklyopenposition> getweeklyopenpositions(@requestparam(value="startdate",defaultvalue="20160601") string startdate         ,@requestparam(value="enddate", defaultvalue="20160701") string enddate){          return weeklyreportserviceimpl.getweeklyopenpositions(startdate,enddate);  }  @requestmapping(value="/currentlypos" ,method = requestmethod.get, produces = mediatypes.json_utf_8) public list<weeklyopenposition> getweeklycurrentlyopenpositions(@requestparam(value="startdate",defaultvalue="20160601") string startdate         ,@requestparam(value="enddate", defaultvalue="20161201") string enddate){          return weeklyreportserviceimpl.getweeklycurrentlyopenpositon(startdate, enddate);  } 

1.getweeklyopenpositions() invoke:

select * report open_ts between '20160101' , '20161230' 

2.getweeklycurrentlyopenpositions() invoke:

select * report open_ts between '20160101' , '20161230' , close_ts>now() 

following key point.

params = "myparam=myvalue"  

this link may helpful understand. enter link description here

@getmapping(path = "/pets/{petid}", params = "myparam=myvalue") public void findpet(@pathvariable string ownerid, @pathvariable string  petid, model model) { // implementation omitted } 

following code can integrate 2 paths 1 method

@requestmapping(value={"/employee/remove","/employee/delete"}) 

reference

in case

 @requestmapping(value={"/currentlypos","/positions"},params = "myparam=myvalue" ,method = requestmethod.get, produces = mediatypes.json_utf_8) 

if asking sql level processing

getweeklyopenpositions(boolean flagcurrently){ string query="select * report open_ts between '20160101' , '20161230'";  if(flagcurrently) {  query=query+ " , close_ts>now()"; }  }