/**
* Save the given biblio record in the database. Transaction management is the caller's
* responsibility.
*
* @param bibliosDAO the data to be saved
*/
@Override
public void save(BibliosDAO bibliosDAO) {
java.sql.Date sqlDate = Utils.tryParseToDbDate(bibliosDAO.getLast_change());
final String statement =
"UPDATE biblios SET title = ?, author1 = ?, author2 = ?, year = ?, journal = ?, username = ?, "
+ "volume = ?, pages = ?, pubmed_id = ?, updated = ?, last_change = ?, notes = ?"
+ "WHERE id_biblio = ?";
jdbcTemplate.update(
statement,
new Object[] {
bibliosDAO.getTitle(),
bibliosDAO.getAuthor1(),
bibliosDAO.getAuthor2(),
bibliosDAO.getYear(),
bibliosDAO.getJournal(),
bibliosDAO.getUsername(),
bibliosDAO.getVolume(),
bibliosDAO.getPages(),
bibliosDAO.getPubmed_id(),
bibliosDAO.getUpdated(),
sqlDate,
bibliosDAO.getNotes(),
bibliosDAO.getId_biblio()
});
}
