java中使用hutool的DbUtil工具类实现连接多个数据源

首先在图片目录创建db.setting文件

按照图片所示填写数据库信息

代码示例如下

public Result SynchronizeData(){

    Connection conn = null;
    javax.sql.DataSource ds = null;

    for (int i = 1; i < 19; i++) {
        ds = DSFactory.get("group_db"+i);
        log.info("第{}个数据源:{}", i, ds);
        Db.use(ds);
        try {
            conn = ds.getConnection();

            ControlCollectInfo controlCollectInfo = new ControlCollectInfo();

            String today = DateUtil.today().toString();
            String substring = today.substring(0, 10);
            //sql拼接
            Entity query = SqlExecutor.query(conn, "SELECT * FROM  xxxx WHERE CTRL_TIME LIKE " + "'" + substring + "%" + "'", new EntityHandler());
       
            this.save(controlCollectInfo);

        } catch (SQLException e) {
            e.printStackTrace();
            return Result.error("500","入库失败");
        } finally {
            DbUtil.close(conn);
        }
    }
    return new Result("200","入库成功");

}