public String listarPrestamo() throws SQLException {
        String Recorrertbl = "";
        ResultSet listPrestamo = Pres.consultarPrestamo();
        ResultSet listPrestamo1 = Pres.consultarPrestamo1();
        try {
            while (listPrestamo.next()) {
                Recorrertbl += "<tr>";
                Recorrertbl += "<td Style='display:none'><center>" + listPrestamo.getString("Id_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("Prestador").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("p.Fecha_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("p.Hora_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("NombrePrestador").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("p.Fecha_devolucion").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("p.Hora_devolucion").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo.getString("devolucion").toString().trim() + "</center></td>";
                Recorrertbl += " <td><center><button data-toggle='modal' data-target='#myModal1' onclick ='recibir(" + listPrestamo.getString("Id_prestamo").toString().trim() + ")' class='btn btn-default glyphicon glyphicon-eye-open'  data-toggle='modal' data-target='#myModal1'></button></center></td>";
                if (listPrestamo.getString("devolucion").toString().trim().equals("No Asignado")) {
                    Recorrertbl += "<td><center><button  class='btn btn-danger glyphicon glyphicon-share' data-toggle='modal' data-target='#myModal' onclick='mapear.devolucion(" + '\"' + listPrestamo.getString("NombrePrestador").toString().trim() + '\"' + "," + listPrestamo.getString("Id_prestamo").toString().trim() + ")' ></button></center></td>";
                } else {
                    Recorrertbl += "<td><center><button  class='btn btn-success  glyphicon glyphicon-check'></button></center></td>";
                }
                Recorrertbl += "</tr>";
            }

            while (listPrestamo1.next()) {
                Recorrertbl += "<tr>";
                Recorrertbl += "<td Style='display:none'><center>" + listPrestamo1.getString("Id_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("Prestador").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("p.Fecha_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("p.Hora_prestamo").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("NombrePrestador").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("p.Fecha_devolucion").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("p.Hora_devolucion").toString().trim() + "</center></td>";
                Recorrertbl += "<td><center>" + listPrestamo1.getString("devolucion").toString().trim() + "</center></td>";
                Recorrertbl += " <td><center><button data-toggle='modal' data-target='#myModal1' onclick ='recibir(" + listPrestamo1.getString("Id_prestamo").toString().trim() + ")' class='btn btn-default glyphicon glyphicon-eye-open'  data-toggle='modal' data-target='#myModal1'></button></center></td>";
                if (listPrestamo1.getString("devolucion").toString().trim().equals("No Asignado")) {
                    Recorrertbl += "<td><center><button  class='btn btn-danger glyphicon glyphicon-share' data-toggle='modal' data-target='#myModal' onclick='mapear.devolucion(" + '\"' + listPrestamo1.getString("NombrePrestador").toString().trim() + '\"' + "," + listPrestamo1.getString("Id_prestamo").toString().trim() + ")' ></button></center></td>";
                } else {
                    Recorrertbl += "<td><center><button  class='btn btn-success  glyphicon glyphicon-check'></button></center></td>";
                }
                Recorrertbl += "</tr>";
            }

        } catch (Exception e) {
            Recorrertbl = "error" + e.getMessage();
        }

        return Recorrertbl;
    }