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