如何使用criteriaquery转换sql查询mysql

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

public class CriteriaQueryExample {
    public static void main(String[] args) {
        // 创建EntityManagerFactory
        EntityManagerFactory emf = Persistence.createEntityManagerFactory("your-persistence-unit-name");
        
        // 创建EntityManager
        EntityManager em = emf.createEntityManager();
        
        // 创建CriteriaBuilder
        CriteriaBuilder cb = em.getCriteriaBuilder();
        
        // 创建CriteriaQuery
        CriteriaQuery<EntityClass> cq = cb.createQuery(EntityClass.class);
        
        // 定义查询根
        Root<EntityClass> root = cq.from(EntityClass.class);
        
        // 定义查询条件
        cq.where(cb.equal(root.get("fieldName"), value));
        
        // 执行查询
        TypedQuery<EntityClass> query = em.createQuery(cq);
        List<EntityClass> result = query.getResultList();
        
        // 处理查询结果
        for (EntityClass entity : result) {
            // 处理每个实体对象
        }
        
        // 关闭EntityManager和EntityManagerFactory
        em.close();
        emf.close();
    }
}