Hello,
I have a question related to correct handling of returns of the DAO library I'm writing for one project. This library probably is going to be used by another people and I want to do it correctly. So I would like to know, how I should deal with return statements of the functions of my DAO.
Example 1
I have function to getCustomer which should return String. In case query doesn't return any result should I return null, empty string or throw some kind of Exception?
Example 2
I have function getCutomerList which return ArrayList. In case query doesn't return any result should I return null, empty ArrayList or throw some Exception?
Example 3
Some sql exception was detected, what should I do: throw exception or do try..catch of the block where it can occur?
What is the "good" practice or "best" practice to apply in my case?
Thanks on advance,
Serhiy.
