public class Merchants extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        resp.setContentType("text/html; charset=UTF-8");
        ServletContext application = getServletContext();
        HttpSession session = req.getSession();

        Document pageXml = DocumentHelper.createDocument();
        Element root = pageXml.addElement("page");
        Element merchants = root.addElement("merchants");

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            conn = DB1.getConnection();
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT SHOPNAME, SHOPURL, SHOPDESCRIPTION, IMAGENAME " +
");
            while(rs.next()) {
                Element merchant = merchants.addElement("merchant");
                merchant.addAttribute("name", rs.getString("SHOPNAME"));
                merchant.addAttribute("link", rs.getString("SHOPURL"));
                merchant.addAttribute("description", rs.getString("SHOPDESCRIPTION"));
                merchant.addAttribute("img", rs.getString("IMAGENAME"));
            }
        } catch (Exception ex) {
            System.err.println("Exception: " + ex);
        } finally {
            try {
                if(rs != null) rs.close();
                if(stmt != null) stmt.close();
                if(conn != null) DB1.freeConnection(conn);
            } catch (SQLException sqle) {
                System.err.println("SQLException: " + sqle);
            }
        }

        try {
            XslXmlTransformer.getInstance(resp, session, "template").writeHtml(pageXml, "merchants.xsl");
        } catch (Exception er){ System.err.println(er);}
    }
}

            rs = stmt.executeQuery("SELECT SHOPNAME, SHOPURL, SHOPDESCRIPTION, IMAGENAME " +
");

        } catch (Exception ex) {
            System.err.println("Exception: " + ex);
        } finally {

            try {
                if(rs != null) rs.close();
                if(stmt != null) stmt.close();
                if(conn != null) DB1.freeConnection(conn);