...I will check to see what quarter the entered month and year falls into. If the month and year falls in the first quarter(1 Oct-31 Dec.) pull all the idle days values out of the database for that quarter...
But what is your question? I don't know whether you're asking how to tell which quarter a date falls into, or whether you're asking about database connectivity.
Start as small as you can manage. Isolate this little part of your program into a new class called Quarter - maybe temporarily, maybe forever. Can you make this work? Put it in the main() of a throw-away test class. Let's give it a month (0-11 like Date) and ask what quarter it's in (0-3)
Show us what you make for that!
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi