Java Database Connectivity (JDBC) - An Introduction to Network Programming with Java - page 218

return acctDetails;
}
public void close() throws SQLException
{
//Any error on disconnecting is handled by servlet.
connection.close();
}
}
A simple example servlet that makes use of an instance of the above DAO class
is shown below.
Example
This servlet calls method getAcctDetails on the DAO object and displays the results
in an HTML table.
import myDAOs.*;
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.WebServlet;
import java.sql.*;
import javax.sql.*; //*** NOTE! ***
import javax.naming.*;
@WebServlet("/DataSourceTestServlet")
public class DAOTestServlet extends HttpServlet
{
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
try
{
processRequest(request, response);
}
catch (SQLException sqlEx)
{
System.out.println("Error: " + sqlEx);
sqlEx.printStackTrace();
}
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException