Hibernate条件限制以及与in IN子句的组合

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import java.util.List;

public class HibernateExample {
    public static void main(String[] args) {
        // 配置 Hibernate
        Configuration configuration = new Configuration().configure();
        SessionFactory sessionFactory = configuration.buildSessionFactory();
        Session session = sessionFactory.openSession();

        // 创建 Criteria 对象
        Criteria criteria = session.createCriteria(User.class);

        // 添加 IN 子句条件
        List<Integer> ids = List.of(1, 2, 3);
        criteria.add(Restrictions.in("id", ids));

        // 执行查询
        List<User> users = criteria.list();

        // 输出结果
        for (User user : users) {
            System.out.println(user);
        }

        // 关闭会话和工厂
        session.close();
        sessionFactory.close();
    }
}

// 分批查询示例
List<Integer> ids = List.of(1, 2, 3, ..., 1000);
int batchSize = 100;
for (int i = 0; i < ids.size(); i += batchSize) {
    List<Integer> batchIds = ids.subList(i, Math.min(i + batchSize, ids.size()));
    criteria.add(Restrictions.in("id", batchIds));
    List<User> users = criteria.list();
    // 处理结果
}