JdbcTemplate.queryForList(String sql)

Number One 

DAO 

public List<?> getResourceTotalOfParentType() {return jdbcTemplate.queryForList("SELECT count(*) as c FROM resource GROUP BY parentTypeId");}

public String execute() throws Exception {List<?> list = manager.getResourceTotalOfParentType();String key = "c";for (int i = 0; i < list.size(); i++) {Map m = (Map) list.get(i);Long count = (Long) m.get(key);System.out.println(count);}return SUCCESS;}