@Override public Post consultarPost(int cod) { try { Post post = new Post(); Blog blog = new Blog(); Profile usuario = new Profile(); String sql = "select * from Post where cod = ?"; PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, cod); ResultSet rs = ps.executeQuery(); if (rs.next()) { post.setCod(rs.getInt("cod")); post.setBlog(blog.consultarBlog(rs.getInt("idBlog"))); post.setUsuario(usuario.consultarPorLogin(rs.getString("usuarioLogin"))); post.setTexto(rs.getString("texto")); post.setTitulo(rs.getString("titulo")); } ps.close(); con.close(); return post; } catch (SQLException e) { e.printStackTrace(); throw new RuntimeException("Falha ao consultar post em JDBCPostDAO", e); } }