Nearby lessons

17 of 19

Hibernate - Native SQL Hibernate - Criteria API Hibernate - Filters Hibernate - Mappings Hibernate - Inheritance Mapping

Hibernate - Filters

📌 What You Will Learn

Understand Hibernate - Filters
See working code examples
Learn from common mistakes and Q&A

Learn Hibernate - Filters step by step — simple explanations, complete programs with their output, common beginner mistakes, and exam-style MCQs.

Filters — Employee.java

Note: Like HQL, we are able to provide custom properties over the Criteria object by using tghe following methods.

public void setFetchSize(int size) public void setFirstResult(int position) public void setMaxResults(int val) public void readOnly(boolean b) pbulic void cacheable(boolean b) ---- ------

Example:

Example01

JCode Cell

1
2	package com.durgasoft.pojo;
3
4	import javax.persistence.Column;
5	import javax.persistence.Entity;
6	import javax.persistence.Id;
7	import javax.persistence.Table;
8
9	@Entity
10	@Table(name="emp1")
11	public class Employee {
12	@Id
13	@Column(name="ENO")
14	private int eno;
15	@Column(name="ENAME")
16	private String ename;
17	@Column(name="ESAL")
18	private int esal;
19	@Column(name="EADDR")
20	private String eaddr;
21
22	public int getEno() {
23	return eno;
24	}
25	public void setEno(int eno) {
26	this.eno = eno;
27	}
28	public String getEname() {
29	return ename;
30	}
31	public void setEname(String ename) {
32	this.ename = ename;
33	}
34	public int getEsal() {
35	return esal;
36	}
37	public void setEsal(int esal) {
38	this.esal = esal;
39	}
40	public String getEaddr() {
41	return eaddr;
42	}
43	public void setEaddr(String eaddr) {
44	this.eaddr = eaddr;
45	}
46
47
48	}
49

Filters — hibernate.cfg.xml

Example02

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<!DOCTYPE hibernate-configuration PUBLIC
4	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
5	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
6	<hibernate-configuration>
7	<session-factory>
8	<property name="connection.driver_Class">oracle.jdbc.OracleDriver</property>
9	<property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
10	<property name="connection.user">system</property>
11	<property name="connection.password">durga</property>
12	<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
13	<property name="show_Sql">true</property>
14	<mapping class="com.durgasoft.pojo.Employee"/>
15	</session-factory>
16	</hibernate-configuration>
17

Filters — Test.java

Example03

JCode Cell

1
2	package com.durgasoft.test;
3
4	import java.util.List;
5
6	import org.hibernate.Criteria;
7	import org.hibernate.Session;
8	import org.hibernate.SessionFactory;
9	import org.hibernate.boot.registry.StandardServiceRegistry;
10	import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
11	import org.hibernate.cfg.Configuration;
12	import org.hibernate.criterion.Criterion;
13	import org.hibernate.criterion.Order;
14	import org.hibernate.criterion.ProjectionList;
15	import org.hibernate.criterion.Projections;
16	import org.hibernate.criterion.Restrictions;
17
18	import com.durgasoft.pojo.Employee;
19
20	public class Test {
21
22	public static void main(String[] args) throws Exception{
23	Configuration cfg = new Configuration();
24	cfg.configure();
25	StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder();
26	builder = builder.applySettings(cfg.getProperties());
27	StandardServiceRegistry registry = builder.build();
28	SessionFactory sessionFactory = cfg.buildSessionFactory(registry);
29	Session session = sessionFactory.openSession();
30
31	Criteria c = session.createCriteria(Employee.class);
32
33	Criterion c1 = Restrictions.ge("esal",6000);
34	Criterion c2 = Restrictions.le("esal", 8000);
35	c.add(c1);
36	c.add(c2);
37
38	ProjectionList pl = Projections.projectionList();
39	pl.add(Projections.property("eno"));
40	pl.add(Projections.property("ename"));
41	pl.add(Projections.property("esal"));
42	pl.add(Projections.property("eaddr"));
43	c.setProjection(pl);
44
45	Order order = Order.desc("ename");
46	c.addOrder(order);
47
48

📝 Key Takeaways

Key ideas of Hibernate - Filters explained simply
Ready-to-use code examples
Exam-style questions at the end

Hibernate

Nearby lessons

Hibernate - Filters

01Filters — Employee.java

02Filters — hibernate.cfg.xml

03Filters — Test.java

Filters — Employee.java

Filters — hibernate.cfg.xml

Filters — Test.java