import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class SQLClose extends HttpServlet {

    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException {

        HttpSession session = request.getSession(true) ;

        Connection conn = (Connection) session.getAttribute("connection") ;
        if(conn == null) {
            response.sendError(HttpServletResponse.SC_OK,
                        "Session timed out.") ;
        } else {
            try {
                conn.close() ;
            } catch (SQLException e) {} 

            response.sendRedirect("/dbc/sqlconnect.html") ;
        }
    }
}