Скачать или смотреть Lesson - 41 : Hibernate - Named Queries using XML and Annotation based Configuration

Hibernate – Named Queries In Hibernate:
1. Named queries concept is used for making either HQL Queries or an SQL Queries has a reusable one.
2. Named queries are two types
A. Named HQl Query.
B. Named native SQL Query.
3. We used named query concept when we want to run same query from multiple clients of the application.
4. The named queries are configured in a mapping file or hbm file.

To configure HQL Query we use ＜query＞ tag :
Employee.hbm.xml:
＜hibernate-mapping＞
＜class＞
＜/class＞
＜query name = "q1"＞
from Employee e where e.deptNumber=?
＜/query＞
＜/hibernate-mapping＞

To configure native SQL Query to configure or we use ＜sql-query＞ tag :
Employee.hbm.xml:
＜hibernate-mapping＞
＜class＞
＜/class＞
＜sql-query name="q2"＞
select * from employee where deptno=?
＜/sql-query＞
＜/hibernate-mapping＞

To configure HQL Query we use ＜query＞ tag :
Employee.hbm.xml:
＜hibernate-mapping＞
＜query name = "q1"＞
from Employee e where e.deptNumber=?
＜/query＞
＜/hibernate-mapping＞

To configure native SQL Query we use ＜sql-query＞ tag :
Employee.hbm.xml:
＜hibernate-mapping＞
＜sql-query name="q2"＞
select * from employee where deptno=?
＜/sql-query＞
＜/hibernate-mapping＞

To run named query from a client application we need to a query reference using alias name of that query.
Ex:client.java
Query qry = session.getnamedQuery("q1");
qry.setParameter(0,10);
List list = qry.list();
Query qry1 = session.getNamedQuery("q2");
qry1.setParameter(0,20);
List list1 = qry1.list();

Hibernate Examples Project Github Link : https://github.com/SadaLearningHub1/H...