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