Book Image

Java Hibernate Cookbook

Book Image

Java Hibernate Cookbook

Overview of this book

This book will provide a useful hands-on guide to Hibernate to accomplish the development of a real-time Hibernate application. We will start with the basics of Hibernate, which include setting up Hibernate – the pre-requisites and multiple ways of configuring Hibernate using Java. We will then dive deep into the fundamentals of Hibernate such as SessionFactory, session, criteria, working with objects and criteria. This will help a developer have a better understanding of how Hibernate works and what needs to be done to run a Hibernate application. Moving on, we will learn how to work with annotations, associations and collections. In the final chapters, we will see explore querying, advanced Hibernate concepts and integration with other frameworks.

Related Content you might be interested in

Current Title:

Small book image
Java Hibernate Cookbook
Sep, 2015 | 250 pages
No titles found
Table of Contents (15 chapters)
Java Hibernate Cookbook
Java Hibernate Cookbook
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Setting Up Hibernate
Setting Up Hibernate
Introduction
Getting the required libraries for hibernate
Creating a hibernate persistent class
Providing an XML-based hibernate mapping
Providing an annotation-based hibernate mapping
Providing a hibernate configuration using an XML file
Providing a hibernate configuration using the properties file
Configuring hibernate programmatically
2
Understanding the Fundamentals
Understanding the Fundamentals
Introduction
Building a SessionFactory
Creating a generic SessionFactory provider class
Opening a new session
Opening a stateless session
Saving an object to the database
Fetching an object from the database
Removing an object from the database
Updating an object
Creating a criteria
Restricting the results using a criteria
Pagination using a criteria
Sorting the results
Transforming a result
Using basic projection
3
Basic Annotations
Basic Annotations
Introduction
Declaring a class as an entity and creating a table in the database – @Entity and @Table
Creating a column in the table – @Column
Creating a primary key and composite primary key column – @Id and @IdClass
Creating an autogenerator column
4
Working with Collections
Working with Collections
Introduction
Persisting List
Persisting Set
Persisting Map
Persisting Array
5
Working with Associations
Working with Associations
Introduction
One-to-one mapping using foreign key association
One-to-one mapping using a common join table
One-to-one mapping using a common primary key
One-to-many mapping or many-to-one mapping
Many-to-many mapping
6
Querying
Querying
Introduction
Working with an alias
Performing aggregate operations
Executing a subquery using a criteria
Executing a native SQL query
Executing a query using HQL
Using formula in hibernate
Working with NamedQuery
7
Advanced Concepts
Advanced Concepts
Introduction
Working with a first-level cache
Working with a second-level cache
Working with a query cache
Working with the table per class hierarchy strategy of inheritance
Working with the table per subclass strategy of inheritance
Working with the table per concrete class strategy of inheritance
Working with the versioning of objects
Maintaining the history of an object
Working with an interceptor
Working with batch processing
8
Integration with Other Frameworks
Integration with Other Frameworks
Introduction
Integration with Spring
Integration with Struts
Index
Index

Restricting the results using a criteria

Let's take a look at how to add restrictions, which are equal to the WHERE clause in SQL.

How to do it…

Let's consider that we have four records in the employee table, as shown in the following tables:

This is the Employee table:

department

salary

firstName

id

1

50000

Yogesh

1

1

35000

Aarush

2

3

30000

Varsha

2

2

75000

Vishal

4

This is the Department table:

deptName

id

development

1

R&D

2

UI/UX

3

Now, the scenario is that we want to get only those employees whose salary is greater than 35000.

The equivalent SQL query to select the above employees is as follows:

SELECT * FROM employee WHERE salary > 35000;

Now, let's look at how to do the same using hibernate.

Code

Enter the following code to create a criteria for employee:

Criteria criteria = session.createCriteria(Employee.class);
criteria.add(Restrictions.gt("salary", 35000));
List<Employee> employees = criteria.list();
for...
Previous Section
End of Section 12
Next Section