public Snippet findById(Long id) {
final String sql = "SELECT * FROM snippet " + "WHERE id=?";
Map<String, Object> row = jdbcTemplate.queryForMap(sql, id);
Snippet snippet = new Snippet();
snippet.id = id;
snippet.title = (String) row.get("title");
snippet.language = (String) row.get("language");
snippet.code = (String) row.get("code");
return snippet;
}
private List<Snippet> queryForSnippets(String sql, Object... sqlArgs) {
List<Snippet> snippets = new ArrayList<>();
List<Map<String, Object>> rows = jdbcTemplate.queryForList(sql, sqlArgs);
for (Map row : rows) {
Snippet snippet = new Snippet();
snippet.id = (Long) row.get("id");
snippet.title = (String) row.get("title");
snippet.language = (String) row.get("language");
snippet.code = (String) row.get("code");
snippet.dateAdded = (Date) row.get("date_added");
snippets.add(snippet);
}
return snippets;
}
