D-Net

    @Autowired

    private DataSource dataSource;

    private final static String SEARCH_FUNDERS = "select id, name from funder where lower(name) like lower(?)";

    private final static String GET_FUNDER = "select id, name, url, source from funder where id=?";

    @Override

    public List<Vocabulary> search(String term) {

        return new JdbcTemplate(dataSource).query(SEARCH_FUNDERS,  new String[]{"%" + term + "%"}, new int[]{Types.VARCHAR}, new RowMapper<Vocabulary>() {

            @Override

            public Vocabulary mapRow(ResultSet rs, int rowNum) throws SQLException {

                return new Vocabulary(rs.getString("id"), rs.getString("name"));

            }

        });

    }

    @Override

    public Funder getById(String id) {

        try {

            return new JdbcTemplate(dataSource).queryForObject(GET_FUNDER, new String[]{id}, new int[]{Types.VARCHAR}, new RowMapper<Funder>() {

                @Override

                public Funder mapRow(ResultSet rs, int rowNum) throws SQLException {

                    return new Funder(rs.getString("id"), rs.getString("name"), rs.getString("url"), rs.getString("source"));

                }

            });

        } catch (EmptyResultDataAccessException e) {

            return null;

        }

    }