@Override
public void create(BlogPost post) {
String query = "INSERT INTO post (username, subject, body, timeStamp)\n" + "values(?, ?, ?, ?)";
getJdbcTemplate()
.update(
query,
new Object[] {
post.getUserName(), post.getSubject(), post.getBody(), post.getTimeStamp()
});
}
@Override
public String getBlogID(BlogPost post) {
String query = "Select ID from post where username=? and subject=? and body=? and timestamp=?";
try {
return (String)
getJdbcTemplate()
.queryForObject(
query,
new Object[] {
post.getUserName(), post.getSubject(), post.getBody(), post.getTimeStamp()
},
String.class);
} catch (EmptyResultDataAccessException e) {
return null;
}
}
