Spring Boot 27：Springboot配置两个数据库

public class JdbcTemplate extends JdbcAccessor implements JdbcOperations {

    public JdbcTemplate(DataSource dataSource) {

        setDataSource(dataSource);

        afterPropertiesSet();

    }

    

    @Override

    public List<Map<String, Object>> queryForList(String sql) throws DataAccessException {

        return query(sql, getColumnMapRowMapper());

    }



    @Override

    public <T> List<T> query(String sql, RowMapper<T> rowMapper) throws DataAccessException {

        return result(query(sql, new RowMapperResultSetExtractor<>(rowMapper)));

    }



    @Override

    @Nullable

    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 (logger.isDebugEnabled()) {

            logger.debug("Executing SQL query [" + sql + "]");

        }



        /**

         * Callback to execute the query.

         */

        class QueryStatementCallback implements StatementCallback<T>, SqlProvider {

            @Override

            @Nullable

            public T doInStatement(Statement stmt) throws SQLException {

                ResultSet rs = null;

                try {

                    rs = stmt.executeQuery(sql);

                    return rse.extractData(rs);

                }

                finally {

                    JdbcUtils.closeResultSet(rs);

                }

            }

            @Override

            public String getSql() {

                return sql;

            }

        }



        return execute(new QueryStatementCallback());

    }



    @Override

    @Nullable

    public <T> T execute(StatementCallback<T> action) throws DataAccessException {

        Assert.notNull(action, "Callback object must not be null");



        Connection con = DataSourceUtils.getConnection(obtainDataSource());

        Statement stmt = null;

        try {

            stmt = con.createStatement();

            applyStatementSettings(stmt);

            T result = action.doInStatement(stmt);

            handleWarnings(stmt);

            return result;

        }

        catch (SQLException ex) {

            // Release Connection early, to avoid potential connection pool deadlock

            // in the case when the exception translator hasn't been initialized yet.

            String sql = getSql(action);