hibernate使用apache-poi在外键字段中插入空值

// 创建数据对象类
@Entity
@Table(name = "your_table_name")
public class YourEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "foreign_key_column")
    private Long foreignKey;

    // 其他属性和方法
}

// 在代码中使用Hibernate和Apache POI插入空值
public void insertDataWithNullForeignKey() {
    // 创建Excel文件
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet("Data");

    // 设置要插入的数据
    List<YourEntity> data = new ArrayList<>();
    YourEntity entity1 = new YourEntity();
    entity1.setForeignKey(null); // 设置外键字段为空值
    data.add(entity1);

    // 遍历数据集合，保存数据
    Session session = sessionFactory.openSession();
    Transaction transaction = session.beginTransaction();
    for (int i = 0; i < data.size(); i++) {
        YourEntity entity = data.get(i);
        session.save(entity);
        if (i % 20 == 0) { // 每20条数据进行一次批量保存
            session.flush();
            session.clear();
        }
    }
    transaction.commit();
    session.close();

    // 保存Excel文件
    try (FileOutputStream outputStream = new FileOutputStream("data.xlsx")) {
        workbook.write(outputStream);
    } catch (IOException e) {
        e.printStackTrace();
    }
}