try {
            Connection conexion=null;
            ResultSet rs = null;
            conexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/ticketsdetrabajo", "root", "Cuatro:2cuatro");
            //creamos objeto Statement
            Statement st=conexion.createStatement();
            rs=st.executeQuery(consultaSQL);

            while(rs.next()){
            aprobado=(int)rs.getObject("Aprobado");
            %>
                <tr>
            <td class="table2"><%=rs.getObject("NParte")%><br>
            </td>
            <td class="table2" ><%=rs.getObject("Nempleado")%><br>
            </td>
            <td class="table2" ><%=rs.getObject("Nombre")%><br>
            </td>
            <td class="table2"><%=rs.getObject("Apellidos")%><br>
            </td>
            <td class="table2"><%=rs.getObject("DescripcionTarea")%><br>
            </td>
            <td class="table2"><%=rs.getObject("TiempoEmpleado")%><br>
            </td>
            <td class="table2"><%=rs.getObject("FechaEntrada")%><br>
            </td>
            <td class="table2"><%=rs.getObject("FechaEntrega")%><br>
            </td>
            <td class="table2"><% if (aprobado==1){%>Si
            <%}else {%>No<%} %>

            <br>
            </td>
            <td class="table2"><button name="btnlapiz" class="botonplano" onclick="location.href='editarpartesdetrabajo.jsp'" ><img alt="editar" src="lapiz.png"></button></td>
          </tr>
        <%}

      }catch (java.sql.SQLException sqle){
            System.out.println("Error: " + sqle);

        }

            %>