Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Query | Fundamentals of Hibernate
Java Data Manipulation with Hibernate
course content

Course Content

Java Data Manipulation with Hibernate

Java Data Manipulation with Hibernate

1. JDBC Overview
2. Fundamentals of Hibernate
3. Final Touches

bookChallenge: Query

It's time to practice

In the previous chapter, we implemented 2 methods in the Employee service layer. We used queries to fetch the necessary data, and now you will have to do a similar task.

Your work will involve 4 classes:

  1. DepartmentDaoImpl;
  2. EmployeeDaoImpl;
  3. DepartmentServiceImpl;
  4. EmployeeServiceImpl.

You need to implement methods such as getAll and getEmployeesWithSalaryMoreThan(Double salary). To implement these methods, you will need to use either Query or NativeQuery, depending on what you choose to use, HQL or SQL. You will also need to use parameter substitution and return a list.

After you implement the methods, you can test your solution in the Main class, and then run the tests that I have written for you to check if you have implemented everything correctly.

Note

Don't forget to set up a connection to your database in hibernate.cfg.xml.

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 2. Chapter 8
some-alt