This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Also, I wouldn't handle connections in the servlet. Hide the connections from the front end. Being as you are returning an ArrayList and not a ResultSet this should be easy enough to do. [ September 20, 2006: Message edited by: steve souza ]