在jOOQ中动态创建条件

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

public class Main {
    public static void main(String[] args) {
        String name = "John";
        Integer age = 30;

        Condition condition = DSL.trueCondition(); // 创建一个初始条件

        if (name != null) {
            condition = condition.and(field("name").eq(name)); // 添加name条件
        }

        if (age != null) {
            condition = condition.and(field("age").eq(age)); // 添加age条件
        }

        // 构建查询
        ResultQuery<Record> query = DSL.using(configuration)
                .select()
                .from(table("person"))
                .where(condition);

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

        // 处理查询结果
        for (Record record : result) {
            // ...
        }
    }
}