使用Hibernate或SQL比较两个枚举集合

public enum Color {
    RED,
    GREEN,
    BLUE
}

@Entity
public class Product {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;

    @Enumerated(EnumType.STRING)
    private Color color;

    // 构造函数、getter和setter方法
}

Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();

Query query = session.createQuery("from Product where color = :color");
query.setParameter("color", Color.RED);
List<Product> redProducts = query.list();

transaction.commit();
session.close();

SELECT * FROM product WHERE color = 'RED';

Set<Color> colors1 = new HashSet<>(Arrays.asList(Color.RED, Color.GREEN));
Set<Color> colors2 = new HashSet<>(Arrays.asList(Color.BLUE, Color.GREEN));

Set<Color> commonColors = new HashSet<>(colors1);
commonColors.retainAll(colors2);

Set<Color> uniqueColors1 = new HashSet<>(colors1);
uniqueColors1.removeAll(commonColors);

Set<Color> uniqueColors2 = new HashSet<>(colors2);
uniqueColors2.removeAll(commonColors);

System.out.println("Common colors: " + commonColors);
System.out.println("Unique colors in set 1: " + uniqueColors1);
System.out.println("Unique colors in set 2: " + uniqueColors2);

Common colors: [GREEN]
Unique colors in set 1: [RED]
Unique colors in set 2: [BLUE]