Question

spring jdbcTemplate.queryForList 的详细用法，该怎么处理

Answer 1

你看下源码就清楚了，org.springframework.jdbc.core.JdbcTemplate。
public class JdbcTemplate extends JdbcAccessor implements JdbcOperations，
public <T> List<T> queryForList(String sql, Class<T> elementType) throws DataAccessException {
return this.query(sql, this.getSingleColumnRowMapper(elementType));
}
最终执行的还是以下代码：
public <T> T query(final String sql, final ResultSetExtractor<T> rse) throws DataAccessException {
Assert.notNull(sql, "SQL must not be null");
Assert.notNull(rse, "ResultSetExtractor must not be null");
if(this.logger.isDebugEnabled()) {
this.logger.debug("Executing SQL query [" + sql + "]");
}

class QueryStatementCallback implements StatementCallback<T>, SqlProvider {
QueryStatementCallback() {
}

public T doInStatement(Statement stmt) throws SQLException {
ResultSet rs = null;

Object var4;
try {
rs = stmt.executeQuery(sql);
ResultSet rsToUse = rs;
if(JdbcTemplate.this.nativeJdbcExtractor != null) {
rsToUse = JdbcTemplate.this.nativeJdbcExtractor.getNativeResultSet(rs);
}

var4 = rse.extractData(rsToUse);
} finally {
JdbcUtils.closeResultSet(rs);
}

return var4;
}

public String getSql() {
return sql;
}
}

return this.execute((StatementCallback)(new QueryStatementCallback()));
}