@Override
public int criarPost(Post post) {
try {
int codigo = 0;
String sql = "insert into Post(idBlog, usuarioLogin, titulo, texto)" + " values (?,?,?,?)";
String sqlRecuperaCodigo = "select max(cod) from Post";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, post.getBlog().getId());
ps.setString(2, post.getUsuario().getLogin());
ps.setString(3, post.getTitulo());
ps.setString(4, post.getTexto());
ps.executeUpdate();
ps = con.prepareStatement(sqlRecuperaCodigo);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
codigo = rs.getInt(1);
}
ps.close();
con.close();
return codigo;
} catch (SQLException e) {
e.printStackTrace();
throw new RuntimeException("Falha ao criar post em JDBCPostDAO", e);
}
}
@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);
}
}