@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);
}
}
