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