springboot中动态读取多sqlite文件

1、添加DataSourceAutoConfiguration类

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;


@Configuration
public class DataSourceAutoConfiguration {

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("org.sqlite.JDBC");
        dataSource.setUrl("");
        dataSource.setUsername("");
        dataSource.setPassword("");

        return dataSource;
    }
}

2、在使用处注入dataSource，并将sqlite文件动态设置

@Autowired
    private DriverManagerDataSource dataSource;
    
    
for (String dbFilePath : fileAddressList) {
  dataSource.setUrl("jdbc:sqlite:" + dbFilePath);

  BaseInfo baseInfo = service.queryBaseInfo();
  
  ...
}