JPQL 查询 user 表

1
package demo.hibernate;
2

3
import jakarta.persistence.EntityManager;
4
import jakarta.persistence.EntityManagerFactory;
5
import jakarta.persistence.TypedQuery;
6

7
import java.util.List;
8

9
public class HqlDemo {
10
    public static void main(String[] args) {
11
        EntityManagerFactory emf = Jpa.createEntityManagerFactory();
12
        EntityManager em = emf.createEntityManager();
13
        try {
14
            TypedQuery<User> byName = em.createQuery(
15
                    "select u from User u where u.userName like :kw order by u.id",
16
                    User.class);
17
            byName.setParameter("kw", "%li%");
18
            List<User> list = byName.getResultList();
19
            System.out.println("like %li% :");
20
            list.forEach(System.out::println);
21

22
            Long count = em.createQuery("select count(u) from User u where u.status = 1", Long.class)
23
                    .getSingleResult();
24
            System.out.println("active users count=" + count);
25
        } finally {
26
            em.close();
27
            emf.close();
28
        }
29
    }
30
}