jOOQ如何使用可选排序

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

public class JooqExample {
    public static void main(String[] args) {
        // 创建jOOQ的上下文对象
        DSLContext context = DSL.using(SQLDialect.MYSQL);

        // 指定要查询的表和字段
        Table<Record> table = DSL.table("my_table");
        Field<Integer> idField = DSL.field("id", Integer.class);
        Field<String> nameField = DSL.field("name", String.class);

        // 创建查询对象并指定要查询的表和字段
        SelectQuery<Record> query = context.selectQuery();
        query.addFrom(table);
        query.addSelect(idField, nameField);

        // 可选排序
        if (需要排序条件) {
            Field<?> sortField = DSL.field("sort_column");
            SortOrder sortOrder = SortOrder.ASC; // 或者 SortOrder.DESC
            query.addOrderBy(sortField.sort(sortOrder));
        }

        // 执行查询并获取结果
        Result<Record> result = query.fetch();
        for (Record record : result) {
            Integer id = record.get(idField);
            String name = record.get(nameField);
            System.out.println("ID: " + id + ", Name: " + name);
        }
    }
}