def sql = new Sql(conn)



  try{

  Statement stmt = conn.createStatement();

    ResultSet rs;

    rs = stmt.executeQuery(query);



    while (rs.next()){

      typ = rs.getString("Typ_transakcji")



  table = "<style type=\"text/css\">" +

            "table.tftable {font-size:10px;color:#333333;width:100%;border-width: 1px;border-color: #a9a9a9;border-collapse: collapse;}" +

            "table.tftable th {font-size:12px;background-color:#b8b8b8;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;}" +

            "table.tftable tr {background-color:#ffffff;}" +

            "table.tftable td {font-size:12px;border-width: 1px;padding: 8px;border-style: solid;border-color: #a9a9a9;}" +

            "</style>" +

            "<table class=\"tftable\">" +



            "<tr><td><b>Typ</b></td><td>Kontrahent</td><td>Nr Faktury</td></tr>" +

    "<tr><td>${typ}</td><td>${kontrahent}</td><td>${nrFaktury}</td></tr>" +

            "</table>"

    }

                } finally{

      sql.close()

    }







    return table