Question

Simple code using Java that uses Naive Query Retrieval

Answer 1

Solution:

EmployeeEntity.java

package com.howtodoinjava.jpa.demo.entity; import java.io.Serializable; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.ManyToOne; import javax.persistence.NamedNativeQueries; import javax.persistence.NamedNativeQuery; import javax.persistence.Table;    @Entity(name="EmployeeEntity") @Table (name="employee") @NamedNativeQueries({         @NamedNativeQuery(                 name    =   "getAllEmployees",                 query   =   "SELECT id, firstName, lastName, email, department.id, department.name " +                             "FROM employee, department",                             resultClass=EmployeeEntity.class         ),         @NamedNativeQuery(                 name    =   "getAllEmployeesByDeptId",                 query   =   "SELECT id, firstName, lastName, email, department.id, department.name " +                             "FROM employee, department " +                             "WHERE department.id = ?",                             resultClass=EmployeeEntity.class         ) }) public class EmployeeEntity implements Serializable {     private static final long serialVersionUID = 1L;        @Id     @GeneratedValue     private Integer id;            private String firstName;     private String lastName;     private String email;            @ManyToOne     private DepartmentEntity department;            public EmployeeEntity() {}             public EmployeeEntity(String name, DepartmentEntity department) {         this.firstName = name;         this.department = department;     }             public EmployeeEntity(String name) {         this.firstName = name;     }        //Setters and Getters     @Override     public String toString() {         return "EmployeeVO [id=" + id + ", firstName=" + firstName                 + ", lastName=" + lastName + ", email=" + email                 + ", department=" + department + "]";     } }

DepartmentEntity.java

package com.howtodoinjava.jpa.demo.entity; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.persistence.CascadeType; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; import javax.persistence.OneToMany; import javax.persistence.Table; @Entity(name="DepartmentEntity") @Table (name="department") public class DepartmentEntity implements Serializable {        private static final long serialVersionUID = 1L;            @Id     @GeneratedValue     private Integer id;     private String name;            public DepartmentEntity(){     }        public DepartmentEntity(String name) {         super();         this.name = name;     }            @OneToMany(mappedBy="department",cascade=CascadeType.PERSIST)     private List<EmployeeEntity> employees = new ArrayList<EmployeeEntity>();            //Setters and Getters            @Override     public String toString() {         return "DepartmentVO [id=" + id + ", name=" + name + "]";     } }