用jOOQ查询具有多个IN值的组合键

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

public class JooqExample {
    public static void main(String[] args) {
        // 创建数据库连接
        String url = "jdbc:mysql://localhost:3306/mydb";
        String username = "root";
        String password = "password";
        ConnectionProvider connectionProvider = new DriverManagerConnectionProvider(url, username, password);
        DSLContext dslContext = DSL.using(connectionProvider, SQLDialect.MYSQL);

        // 定义表和实体类
        Table<CustomerRecord> customerTable = table("customer", CustomerRecord.class);

        // 创建查询
        SelectConditionStep<Record> query = dslContext.select()
                .from(customerTable)
                .where(field("id").in(1, 2, 3)
                .and(field("name").in("John", "Bob", "Alice")));

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

        // 处理查询结果
        for (Record record : result) {
            int id = record.getValue(field("id", Integer.class));
            String name = record.getValue(field("name", String.class));
            System.out.println("ID: " + id + ", Name: " + name);
        }
    }
}