如何使用jOOQ创建SELECT EXISTS (子查询)？

import org.jooq.*;
import org.jooq.impl.*;

public class JooqExample {
    public static void main(String[] args) {
        // 创建数据库连接
        Connection connection = // 创建数据库连接的代码

        // 创建jOOQ的配置
        Configuration configuration = new DefaultConfiguration().set(connection);

        // 创建DSLContext对象
        DSLContext dslContext = DSL.using(configuration);

        // 创建子查询
        SelectConditionStep<Record1<Integer>> subquery = dslContext.selectCount()
                .from("table")
                .where("column = ?", value);

        // 创建主查询
        SelectConditionStep<Record1<Boolean>> query = dslContext.select(DSL.exists(subquery))
                .from("other_table")
                .where("other_column = ?", otherValue);

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

        // 处理查询结果
        for (Record1<Boolean> record : result) {
            Boolean exists = record.value1();
            // 处理exists的值
        }

        // 关闭数据库连接
        connection.close();
    }
}