如何在Spring应用程序中使用非jta数据源将select查询重定向到复制数据库

<bean id="primaryDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://primary-database:3306/primary_db"/>
    <property name="username" value="primary_user"/>
    <property name="password" value="primary_password"/>
</bean>

<bean id="replicaDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://replica-database:3306/replica_db"/>
    <property name="username" value="replica_user"/>
    <property name="password" value="replica_password"/>
</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="primaryDataSource"/>
</bean>

@Autowired
private JdbcTemplate jdbcTemplate;

public List<User> getUsers() {
    String sql = "SELECT * FROM users";
    
    // 使用主数据库
    jdbcTemplate.setDataSource(primaryDataSource);
    List<User> users = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
    
    // 使用复制数据库
    jdbcTemplate.setDataSource(replicaDataSource);
    List<User> replicaUsers = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
    
    // 合并结果
    users.addAll(replicaUsers);
    
    return users;
}