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