// UPDATE
public void update(Author author) throws Exception {
Query query = new Query();
query.addCriteria(Criteria.where("_id").is(author.getAuthorId()));
Update update = new Update();
update.set("authorName", author.getAuthorName());
// FindAndModifyOptions().returnNew(true) = newly updated document
// FindAndModifyOptions().returnNew(false) = old document (not update yet)
mongoOps.findAndModify(
query, update, new FindAndModifyOptions().returnNew(true), Author.class, AUTHOR_COLLECTION);
}
/** *************************************************************************************** */
public void DeleteAuthor(Author author) throws Exception {
ConnectionUtil c = new ConnectionUtil();
Connection conn = c.createConnection();
try {
if (author == null
|| author.getAuthorName() == null
|| author.getAuthorName().length() == 0
|| author.getAuthorName().length() > 45) {
throw new Exception("The Author cannot be null");
} else {
AuthorDAO adao = new AuthorDAO(conn);
adao.delete(author);
conn.commit();
}
} catch (Exception e) {
e.printStackTrace();
conn.rollback();
} finally {
conn.close();
}
}
public void update(Author author) throws Exception {
save(
"update tbl_author set authorName = ? where authorId = ?",
new Object[] {author.getAuthorName(), author.getAuthorId()});
}
public void create(Author author) throws Exception {
save("insert into tbl_author (authorName) values(?)", new Object[] {author.getAuthorName()});
}