jOOQ WITH子句的动态数量

import static org.jooq.impl.DSL.*;

public class JooqExample {
    public static void main(String[] args) {
        DSLContext context = DSL.using("jdbc:mysql://localhost:3306/dbname", "username", "password");

        // 定义WITH子句
        WithStep<?> withStep = with();

        // 动态添加临时表
        for (int i = 1; i <= 3; i++) {
            withStep = withStep.as("temp" + i,
                    select(field("column1"), field("column2"))
                            .from(table("table" + i))
                            .where(field("column1").eq(i)));
        }

        // 构建查询
        SelectConditionStep<Record> query = context.select()
                .from(table("main_table"))
                .join(table(name("temp1"))).on(field("main_table.column1").eq(field(name("temp1.column1"))))
                .join(table(name("temp2"))).on(field("main_table.column2").eq(field(name("temp2.column2"))))
                .join(table(name("temp3"))).on(field("main_table.column3").eq(field(name("temp3.column3"))))
                .where(field("main_table.column4").eq("value"));

        // 执行查询
        Result<Record> result = query.fetch();

        // 处理查询结果
        for (Record record : result) {
            // 处理每一行记录
        }
    }
}