spring-jdbcTemplate使用

Object o = scope.getContext().getBean("dataSource");//用数据源构造JdbcTemplate t = new JdbcTemplate((ComboPooledDataSource) o);List<T> res = t.query("select agentName from agent",new RowMapper() {public Object mapRow(ResultSet rs, int rowNum)throws SQLException {T m = new T();m.setName(rs.getString("agentName"));return m;}}); 

public class T {private String name;public String getName() {return name;}public void setName(String name) {this.name = name;}}