Oracle 11g的JOOQ批量更新日期

CREATE TABLE employees (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  hire_date DATE
);

INSERT INTO employees (id, name, hire_date)
VALUES (1, 'John', TO_DATE('2022-01-01', 'YYYY-MM-DD'));

INSERT INTO employees (id, name, hire_date)
VALUES (2, 'Jane', TO_DATE('2022-02-01', 'YYYY-MM-DD'));

INSERT INTO employees (id, name, hire_date)
VALUES (3, 'Alice', TO_DATE('2022-03-01', 'YYYY-MM-DD'));

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

public class Main {
  public static void main(String[] args) {
    // 创建数据库连接
    String url = "jdbc:oracle:thin:@localhost:1521:xe";
    String username = "your_username";
    String password = "your_password";
    DSLContext context = DSL.using(url, username, password);

    // 执行批量更新日期的操作
    context.update(Tables.EMPLOYEES)
           .set(Tables.EMPLOYEES.HIRE_DATE, DSL.currentDate())
           .execute();
  }
}