10000 Queries adopted to NamedQueries from TypedQueries on Employee entity · anirtek/java-persistence-api@c1a1fed · GitHub
[go: up one dir, main page]

Skip to content

Commit c1a1fed

Browse files
author
anirtek
committed
Queries adopted to NamedQueries from TypedQueries on Employee entity
1 parent a408f02 commit c1a1fed

File tree

4 files changed

+11
-5
lines changed

4 files changed

+11
-5
lines changed

src/main/java/io/anirtek/persistence/PersistenceTester.java

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -55,13 +55,12 @@ public static void main(String[] args) {
5555
// }
5656

5757
// FIND ALL
58-
// TypedQuery<Employee> query = em.createQuery("SELECT e FROM Employee e",
59-
// Employee.class);
60-
// List<Employee> employees = query.getResultList();
61-
// System.out.println(employees);
58+
// TypedQuery<Employee> query = em.createNamedQuery("Employee.findAll", Employee.class);
59+
// List<Employee> employees = query.getResultList();
60+
// System.out.println(employees);
6261

6362
//FIND BY EMAIL
64-
TypedQuery<Employee> query = em.createQuery("SELECT e FROM Employee e where e.email=:pEmail", Employee.class); //pEmail is just a name used
63+
TypedQuery<Employee> query = em.createNamedQuery("Employee.findByEMail", Employee.class); //pEmail is just a name used
6564
query.setParameter("pEmail", "atekade1@binghamton.edu");
6665
List<Employee> employees = query.getResultList();
6766
System.out.println(employees);

src/main/java/io/anirtek/persistence/entity/Employee.java

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5,8 +5,15 @@
55
import javax.persistence.Column;
66
import javax.persistence.Entity;
77
import javax.persistence.Id;
8+
import javax.persistence.NamedQueries;
9+
import javax.persistence.NamedQuery;
810

911
@Entity
12+
@NamedQueries({
13+
@NamedQuery(name = "Employee.findAll", query = "SELECT e FROM Employee e ORDER BY e.firstName"),
14+
@NamedQuery(name = "Employee.findByEmail", query = "SELECT e FROM Employee e where e.email=:pEmail")
15+
})
16+
1017
public class Employee {
1118

1219
@Id
Binary file not shown.
Binary file not shown.

0 commit comments

Comments
 (0)
0