Nearby lessons

4 of 19

Hibernate - Installation Hibernate - First Application Hibernate - Retrieving Records Hibernate - MySQL Integration Hibernate - Struts Integration

Hibernate - Retrieving Records from the Database

📌 What You Will Learn

Understand Hibernate - Retrieving Records from the Database
See working code examples
Learn from common mistakes and Q&A

Learn Hibernate - Retrieving Records from the Database step by step — simple explanations, complete programs with their output, common beginner mistakes, and exam-style MCQs.

Retrieving Records from the Database

} catch (Exception e) {
e.printStackTrace();
}finally {
session_Factory.close();
session.close();

HIBERNATE with My SQL Database

If we want to use MySQL Database for Hibernate applications then we have provide the following changes.

In Hibernate Configuration File: : com.mysql.jdbc.Driver Driver Class Name : jdbc:mysql://localhost:3306/db_Name Driver URL : root DB User Name : root DB Password : org.hibernate.dialect.MySQLDialect Dialect

Note: We must add mysql-connector-java-5.0.8-bin.jar file to Hibernate3_Lib.

In Hibernate Applications, it is not suggestible to manage Configuration object and SessionFactory object in Client Application directly, because, these two objects are providing Hibernate Boot strapping. In futer if we want to change boot strapping mechanisms then we have to provide changes in Client Application, it may effect our persistence operations. To avoid this type of problems we have to use a separate Utility class to prepare Configuration and SessionFactory object.

Example02

JCode Cell

1
2	class HibernateUtil{
3	private static SessionFactory sessionfactory;
4	static{
5	try{
6	Configuration cfg = new Configuration();
7	cfg.configure(---);
8	sessionFactory = cfg.buildSessionFactory();
9	}catch(Exception e){
10	e.printStackTrace();
11	}
12	}
13	public static SessionFactory getSessionFactory(){
14	return sessionFactory;
15	}
16	public static void cleanUp(SessionFactory sf, Session s){
17	s.close();
18	sf.close();
19	}
20	}
21

HIBERNATE with My SQL Database — Employee.java

Example:

Example03

JCode Cell

1
2	package com.durgasoft.hbn.pojo;
3
4	public class Employee {
5	private int eno;
6	private String ename;
7	private float esal;
8	private String eaddr;
9
10	public int getEno() {
11	return eno;
12	}
13	public void setEno(int eno) {
14	this.eno = eno;
15	}
16	public String getEname() {
17	return ename;
18	}
19	public void setEname(String ename) {
20	this.ename = ename;
21	}
22	public float getEsal() {
23	return esal;
24	}
25	public void setEsal(float esal) {
26	this.esal = esal;
27	}
28	public String getEaddr() {
29	return eaddr;
30	}
31	public void setEaddr(String eaddr) {
32	this.eaddr = eaddr;
33	}
34	}
35

HIBERNATE with My SQL Database — Employee.hbm.xml

Example04

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<!DOCTYPE hibernate-mapping PUBLIC
4	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
5	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
6	<hibernate-mapping>
7	<class name="com.durgasoft.hbn.pojo.Employee" table="emp1">
8	<id name="eno"/>
9	<property name="ename"/>
10	<property name="esal"/>
11	<property name="eaddr"/>
12	</class>
13	</hibernate-mapping>
14

HIBERNATE with My SQL Database — hibernate.cfg.xml

Example05

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">com.mysql.jdbc.Driver</property>
9	<property name="connection.url">jdbc:mysql://localhost:3306/durgadb</property>
10	<property name="connection.user">root</property>
11	<property name="connection.password">root</property>
12	<property name="show_sql">true</property>
13	<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
14	<mapping resource="com/durgasoft/hbn/mappings/Employee.hbm.xml"/>
15	</session-factory>
16	</hibernate-configuration>
17

HIBERNATE with My SQL Database — HibernateUtil.java

Example06

JCode Cell

1
2	package com.durgasoft.hbn.util;
3
4	import org.hibernate.Session;
5	import org.hibernate.SessionFactory;
6	import org.hibernate.cfg.Configuration;
7
8	public class HibernateUtil {
9	private static SessionFactory sessionFactory;
10	static {
11	try {
12	Configuration cfg = new Configuration();
13	cfg.configure("/com/durgasoft/hbn/cfgs/hibernate.cfg.xml");
14	sessionFactory = cfg.buildSessionFactory();
15	} catch (Exception e) {
16	e.printStackTrace();
17	}
18	}
19
20	public static SessionFactory getSessionFactory() {
21	return sessionFactory;
22	}
23	public static void cleanUp(SessionFactory sessionFactory, Session session) {
24	session.close();
25	sessionFactory.close();
26	}
27	}
28

HIBERNATE with My SQL Database — ClientApp.java

Example07

JCode Cell

1
2	package com.durgasoft.hbn.test;
3
4	import org.hibernate.Session;
5	import org.hibernate.SessionFactory;
6
7	import com.durgasoft.hbn.pojo.Employee;
8	import com.durgasoft.hbn.util.HibernateUtil;
9
10	public class ClientApp {
11
12	public static void main(String[] args) {
13	try {
14	SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
15	Session session = sessionFactory.openSession();
16	Employee emp = (Employee)session.get("com.durgasoft.hbn.pojo.Employee", 111);
17	if(emp == null) {
18	System.out.println("Employee Not Existed");
19	}else {
20	System.out.println("Employee Details");
21	System.out.println("-----------------------");
22	System.out.println("Employee Number :"+emp.getEno());
23	System.out.println("Employee Name :"+emp.getEname());
24	System.out.println("Employee Salary :"+emp.getEsal());
25	System.out.println("Employee Address :"+emp.getEaddr());
26	}
27	HibernateUtil.cleanUp(sessionFactory, session);
28	} catch (Exception e) {
29	e.printStackTrace();
30	}
31
32	}
33
34	}
35

AWT/GUI-Hibernate Integration Application — Student.java

Example08

JCode Cell

1
2	package com.durgasoft.hbn.pojo;
3
4	public class Student {
5	private String sid;
6	private String sname;
7	private String saddr;
8
9	public String getSid() {
10	return sid;
11	}
12	public void setSid(String sid) {
13	this.sid = sid;
14	}
15	public String getSname() {
16	return sname;
17	}
18	public void setSname(String sname) {
19	this.sname = sname;
20	}
21	public String getSaddr() {
22	return saddr;
23	}
24	public void setSaddr(String saddr) {
25	this.saddr = saddr;
26	}
27
28
29	}
30

AWT/GUI-Hibernate Integration Application — Student.hbm.xml

Example09

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<!DOCTYPE hibernate-mapping PUBLIC
4	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
5	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
6	<hibernate-mapping>
7	<class name="com.durgasoft.hbn.pojo.Student" table="student">
8	<id name="sid" column="SID"/>
9	<property name="sname"/>
10	<property name="saddr"/>
11	</class>
12	</hibernate-mapping>
13

AWT/GUI-Hibernate Integration Application — hibernate.cfg.xml

Example10

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">com.mysql.jdbc.Driver</property>
9	<property name="connection.url">jdbc:mysql://localhost:3306/durgadb</property>
10	<property name="connection.user">root</property>
11	<property name="connection.password">root</property>
12	<property name="show_sql">true</property>
13	<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
14	<mapping resource="com/durgasoft/hbn/mappings/Student.hbm.xml"/>
15	</session-factory>
16	</hibernate-configuration>
17

AWT/GUI-Hibernate Integration Application — HibernateUtil.java

Example11

JCode Cell

1
2	package com.durgasoft.hbn.util;
3
4	import org.hibernate.SessionFactory;
5	import org.hibernate.cfg.Configuration;
6
7	public class HibernateUtil {
8	private static SessionFactory sessionFactory;
9	static {
10	try {
11	Configuration cfg = new Configuration();
12	cfg.configure("/com/durgasoft/hbn/cfgs/hibernate.cfg.xml");
13	sessionFactory = cfg.buildSessionFactory();
14	} catch (Exception e) {
15	e.printStackTrace();
16	}
17	}
18	public static SessionFactory getSessionFactory() {
19	return sessionFactory;
20	}
21	}
22

AWT/GUI-Hibernate Integration Application — StudentService.java

Example12

JCode Cell

1
2	package com.durgasoft.service;
3
4	import org.hibernate.Session;
5	import org.hibernate.SessionFactory;
6
7	import com.durgasoft.hbn.pojo.Student;
8	import com.durgasoft.hbn.util.HibernateUtil;
9
10	public class StudentService {
11	Student std = null;
12	public Student search(String sid) {
13	try {
14	SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
15	Session session = sessionFactory.openSession();
16	std = (Student) session.get("com.durgasoft.hbn.pojo.Student", sid);
17	} catch (Exception e) {
18	e.printStackTrace();
19	}
20	return std;
21	}
22	}
23

AWT/GUI-Hibernate Integration Application — SearchFrame.java

Example13

JCode Cell

1
2	package com.durgasoft.client;
3
4	import java.awt.Button;
5	import java.awt.Color;
6	import java.awt.FlowLayout;
7	import java.awt.Font;
8	import java.awt.Frame;
9	import java.awt.Graphics;
10	import java.awt.Label;
11	import java.awt.TextField;
12	import java.awt.event.ActionEvent;
13	import java.awt.event.ActionListener;
14	import java.awt.event.WindowAdapter;
15	import java.awt.event.WindowEvent;
16
17	import com.durgasoft.hbn.pojo.Student;
18	import com.durgasoft.service.StudentService;
19
20	public class SearchFrame extends Frame implements ActionListener {
21
22	Label l;
23	TextField tf;
24	Button b;
25	Student std;
26
27	SearchFrame(){
28	this.setVisible(true);
29	this.setSize(500, 500);
30	this.setTitle("Student Search Frame");
31	this.setLayout(new FlowLayout());
32	this.setBackground(Color.green);
33	this.addWindowListener(new WindowAdapter() {
34	public void windowClosing(WindowEvent we) {
35	System.exit(0);
36	}
37	});
38
39	l = new Label("Student ID");
40	tf = new TextField(20);
41	b = new Button("SEARCH");
42	b.addActionListener(this);
43
44	Font f = new Font("arial", Font.BOLD, 20);
45	l.setFont(f);
46	tf.setFont(f);
47	b.setFont(f);
48
49	this.add(l);
50	this.add(tf);
51	this.add(b);
52	}
53	@Override
54	public void actionPerformed(ActionEvent ae) {
55
56	String sid = tf.getText();
57	StudentService std_Serv = new StudentService();
58	std = std_Serv.search(sid);
59	repaint();
60	}
61	public void paint(Graphics g) {
62	Font f = new Font("arial", Font.BOLD, 30);
63	this.setForeground(Color.red);
64	g.setFont(f);
65
66	if(std == null) {
67	g.drawString("Student Not Existed", 50, 300);
68	}else {
69	g.drawString("Student ID :"+std.getSid(), 50, 300);
70	g.drawString("Student Name :"+std.getSname(), 50, 350);
71	g.drawString("Student Address :"+std.getSaddr(), 50, 400);
72	}
73	}
74	}
75

AWT/GUI-Hibernate Integration Application — ClientApp.java

Example14

JCode Cell

1
2	package com.durgasoft.client;
3
4	public class ClientApp {
5
6	public static void main(String[] args) {
7	SearchFrame searchFrame = new SearchFrame();
8
9	}
10	}
11

Servlet_Hibernate_Application — loginform.html

Example15

JCode Cell

1
2	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
3	<html>
4	<head>
5	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
6	<title>Insert title here</title>
7	</head>
8	<body>
9	<h2>Durga Software Solutions</h2>
10	<h3>User Login Form</h3>
11	<form method = "POST" action = "./login">
12	<table>
13	<tr>
14	<td>User Name</td>
15	<td><input type="text" name="uname"/></td>
16	</tr>
17	<tr>
18	<td>Password</td>
19	<td><input type="password" name="upwd"/></td>
20	</tr>
21	<tr>
22	<td><input type="submit" value="Login"/></td>
23	</tr>
24	</table>
25	</form>
26	</body>
27	</html>
28

Servlet_Hibernate_Application — success.html

Example16

JCode Cell

1
2	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
3	<html>
4	<head>
5	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
6	<title>Insert title here</title>
7	</head>
8	<body>
9	<h2>Durga Software Solutions</h2>
10	<h3>User Login Status Page</h3>
11	<font color="red" size="6">
12	<b>
13	User Login Success
14	</b>
15	</font>
16	<h3>
17	<a href="./loginform.html">\|User Login Form\|</a>
18	</h3>
19	</body>
20	</html>
21

Servlet_Hibernate_Application — failure.html

Example17

JCode Cell

1
2	<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
3	<html>
4	<head>
5	<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
6	<title>Insert title here</title>
7	</head>
8	<body>
9	<h2>Durga Software Solutions</h2>
10	<h3>User Login Status Page</h3>
11	<font color="red" size="6">
12	<b>
13	User Login Failure
14	</b>
15	</font>
16	<h3>
17	<a href="./loginform.html">\|User Login Form\|</a>
18	</h3>
19	</body>
20	</html>
21

Servlet_Hibernate_Application — hibernate.cfg.xml

Example18

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="hibernate.connection.driver_Class">oracle.jdbc.OracleDriver</property>
9	<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
10	<property name="hibernate.connection.username">system</property>
11	<property name="hibernate.connection.password">durga</property>
12	<property name="show_sql">true</property>
13	<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
14	<mapping resource="com/durgasoft/hbn/mappings/User.hbm.xml"/>
15	</session-factory>
16	</hibernate-configuration>
17

Servlet_Hibernate_Application — User.hbm.xml

Example19

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<!DOCTYPE hibernate-mapping PUBLIC
4	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
5	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
6	<hibernate-mapping>
7	<class name="com.durgasoft.hbn.pojo.User" table="Reg_Users">
8	<id name="uname" column="UNAME"/>
9	<property name="upwd" column="UPWD"/>
10	</class>
11	</hibernate-mapping>
12

Servlet_Hibernate_Application — HibernateUtil.java

Example20

JCode Cell

1
2	package com.durgasoft.hbn.util;
3
4	import org.hibernate.SessionFactory;
5	import org.hibernate.cfg.Configuration;
6
7	public class HibernateUtil {
8	private static SessionFactory sessionFactory;
9	static {
10	try {
11	Configuration cfg = new Configuration();
12	cfg.configure("/com/durgasoft/hbn/cfgs/hibernate.cfg.xml");
13	sessionFactory = cfg.buildSessionFactory();
14	System.out.println(sessionFactory);
15	} catch (Exception e) {
16	e.printStackTrace();
17	}
18	}
19	public static SessionFactory getSessionFactory() {
20	return sessionFactory;
21	}
22	}
23

Servlet_Hibernate_Application — User.java

Example21

JCode Cell

1
2	package com.durgasoft.hbn.pojo;
3
4	public class User {
5	private String uname;
6	private String upwd;
7	public String getUname() {
8	return uname;
9	}
10	public void setUname(String uname) {
11	this.uname = uname;
12	}
13	public String getUpwd() {
14	return upwd;
15	}
16	public void setUpwd(String upwd) {
17	this.upwd = upwd;
18	}
19
20	}
21

Servlet_Hibernate_Application — UserService.java

Example22

JCode Cell

1
2	package com.durgasoft.service;
3
4	import org.hibernate.Session;
5	import org.hibernate.SessionFactory;
6
7	import com.durgasoft.hbn.pojo.User;
8	import com.durgasoft.hbn.util.HibernateUtil;
9
10	public class UserService {
11	String status = "";
12	public String checkLogin(String uname, String upwd) {
13	try {
14	SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
15	Session session = sessionFactory.openSession();
16	System.out.println(session);
17	User user = (User)session.get(com.durgasoft.hbn.pojo.User.class, uname);
18	if(user == null) {
19	status = "failure";
20	}else {
21	if(user.getUpwd().equals(upwd)) {
22	status = "success";
23	}else {
24	status = "failure";
25	}
26	}
27	} catch (Exception e) {
28	e.printStackTrace();
29	}
30	return status;
31	}
32	}
33

Servlet_Hibernate_Application — LoginServlet.java

Example23

JCode Cell

1
2	package com.durgasoft.servlets;
3
4	import java.io.IOException;
5
6	import javax.servlet.RequestDispatcher;
7	import javax.servlet.ServletException;
8	import javax.servlet.http.HttpServlet;
9	import javax.servlet.http.HttpServletRequest;
10	import javax.servlet.http.HttpServletResponse;
11
12	import com.durgasoft.hbn.util.HibernateUtil;
13	import com.durgasoft.service.UserService;
14	public class LoginServlet extends HttpServlet {
15	public void init() {
16	HibernateUtil.getSessionFactory();
17	System.out.println("init()");
18	}
19	private static final long serialVersionUID = 1L;
20	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
21	String uname = request.getParameter("uname");
22	String upwd = request.getParameter("upwd");
23
24	UserService user_Service = new UserService();
25	String status = user_Service.checkLogin(uname, upwd);
26
27	RequestDispatcher requestDispatcher = null;
28	if(status.equals("success")) {
29	requestDispatcher = request.getRequestDispatcher("/success.html");
30	requestDispatcher.forward(request, response);
31	}else {
32	requestDispatcher = request.getRequestDispatcher("/failure.html");
33	requestDispatcher.forward(request, response);
34	}
35	}
36	}
37

Servlet_Hibernate_Application — web.xml

Example24

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
4	<display-name>app07</display-name>
5	<welcome-file-list>
6	<welcome-file>index.html</welcome-file>
7	<welcome-file>index.htm</welcome-file>
8	<welcome-file>index.jsp</welcome-file>
9	<welcome-file>default.html</welcome-file>
10	<welcome-file>default.htm</welcome-file>
11	<welcome-file>default.jsp</welcome-file>
12	</welcome-file-list>
13	<servlet>
14	<description></description>
15	<display-name>LoginServlet</display-name>
16	<servlet-name>LoginServlet</servlet-name>
17	<servlet-class>com.durgasoft.servlets.LoginServlet</servlet-class>
18	<load-on-startup>1</load-on-startup>
19	</servlet>
20	<servlet-mapping>
21	<servlet-name>LoginServlet</servlet-name>
22	<url-pattern>/login</url-pattern>
23	</servlet-mapping>
24	</web-app>
25

JSP_Hibernate_Application — searchform.html

Example25

JCode Cell

1
2	<!DOCTYPE html>
3	<html>
4	<head>
5	<meta charset="ISO-8859-1">
6	<title>Insert title here</title>
7	</head>
8	<body>
9	<h2>Durga Software Solutions</h2>
10	<h3>Customer Search Form</h3>
11	<form method="POST" action="./search.jsp">
12	<table>
13	<tr>
14	<td>Customer ID</td>
15	<td><input type="text" name="cid"/></td>
16	</tr>
17	<tr>
18	<td><input type="submit" value="SEARCH"/></td>
19	</tr>
20	</table>
21	</form>
22	</body>
23	</html>
24

JSP_Hibernate_Application — notexisted.html

Example26

JCode Cell

1
2	<!DOCTYPE html>
3	<html>
4	<head>
5	<meta charset="ISO-8859-1">
6	<title>Insert title here</title>
7	</head>
8	<body>
9	<h2>Durga Software Solutions</h2>
10	<h3>Customer Search Status</h3>
11	<font color="red" size="6">
12	<b>
13	Customer Not Existed
14	</b>
15	</font>
16	<h3>
17	<a href="./searchform.html">\|Customer Search Form\|</a>
18	</h3>
19	</body>
20	</html>
21

JSP_Hibernate_Application — display.jsp

Example27

JCode Cell

1
2	<%@page import="com.durgasoft.hbn.pojo.Customer"%>
3	<%!
4	Customer customer = null;
5	%>
6	<%
7	customer = (Customer)request.getAttribute("customer");
8	%>
9	<html>
10	<body>
11	<h2>Durga Software Solutions</h2>
12	<h3>Customer Details</h3>
13	<table border="1">
14	<tr>
15	<td>Customer ID</td>
16	<td><%=customer.getCid() %> </td>
17	</tr>
18	<tr>
19	<td>Customer Name</td>
20	<td><%=customer.getCname() %> </td>
21	</tr>
22	<tr>
23	<td>Customer Address</td>
24	<td><%=customer.getCaddr() %> </td>
25	</tr>
26	<tr>
27	<td>Customer Email</td>
28	<td><%=customer.getCemail() %> </td>
29	</tr>
30	<tr>
31	<td>Customer Mobile</td>
32	<td><%=customer.getCmobile() %> </td>
33	</tr>
34	</table>
35	<h3>
36	<a href="./searchform.html">\|Customer Search Form\|</a>
37	</h3>
38	</body>
39	</html>
40

JSP_Hibernate_Application — search.jsp

Example28

JCode Cell

1
2	<%@page import="com.durgasoft.hbn.pojo.Customer"%>
3	<%@page import="org.hibernate.Session"%>
4	<%@page import="org.hibernate.SessionFactory"%>
5	<%@page import="org.hibernate.cfg.Configuration"%>
6	<%!
7	Configuration cfg = null;
8	SessionFactory sessionFactory = null;
9	Session ses = null;
10	Customer customer = null;
11	%>
12	<%
13	try{
14	String cid = request.getParameter("cid");
15	cfg = new Configuration();
16	cfg.configure("/com/durgasoft/hbn/cfgs/hibernate.cfg.xml");
17	sessionFactory = cfg.buildSessionFactory();
18	ses = sessionFactory.openSession();
19	customer = (Customer)ses.get(Customer.class, cid );
20	if(customer == null){
21	%>
22	<jsp:forward page="notexisted.html"/>
23	<%
24	}else{
25	request.setAttribute("customer", customer);
26	%>
27	<jsp:forward page="display.jsp"/>
28	<%
29	}
30	}catch(Exception e){
31	e.printStackTrace();
32	}
33	%>
34

JSP_Hibernate_Application — Customer.java

Example29

JCode Cell

1
2	package com.durgasoft.hbn.pojo;
3
4	public class Customer {
5	private String cid;
6	private String cname;
7	private String caddr;
8	private String cemail;
9	private String cmobile;
10
11	public String getCid() {
12	return cid;
13	}
14	public void setCid(String cid) {
15	this.cid = cid;
16	}
17	public String getCname() {
18	return cname;
19	}
20	public void setCname(String cname) {
21	this.cname = cname;
22	}
23	public String getCaddr() {
24	return caddr;
25	}
26	public void setCaddr(String caddr) {
27	this.caddr = caddr;
28	}
29	public String getCemail() {
30	return cemail;
31	}
32	public void setCemail(String cemail) {
33	this.cemail = cemail;
34	}
35	public String getCmobile() {
36	return cmobile;
37	}
38	public void setCmobile(String cmobile) {
39	this.cmobile = cmobile;
40	}
41
42
43	}
44

JSP_Hibernate_Application — Customer.hbm.xml

Example30

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<!DOCTYPE hibernate-mapping PUBLIC
4	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
5	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
6	<hibernate-mapping>
7	<class name="com.durgasoft.hbn.pojo.Customer" table="customer">
8	<id name="cid" column="CID"/>
9	<property name="cname" column="CNAME"/>
10	<property name="caddr" column="CADDR"/>
11	<property name="cemail" column="CEMAIL"/>
12	<property name="cmobile" column="CMOBILE"/>
13	</class>
14	</hibernate-mapping>
15

JSP_Hibernate_Application — hibernate.cfg.xml

Example31

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">com.mysql.jdbc.Driver</property>
9	<property name="connection.url">jdbc:mysql://localhost:3306/durgadb</property>
10	<property name="connection.username">root</property>
11	<property name="connection.password">root</property>
12	<property name="show_sql">true</property>
13	<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
14	<mapping resource="com/durgasoft/hbn/mappings/Customer.hbm.xml"/>
15	</session-factory>
16	</hibernate-configuration>
17

JSP_Hibernate_Application — web.xml

Example32

JCode Cell

1
2	<?xml version="1.0" encoding="UTF-8"?>
3	<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
4	<display-name>app08</display-name>
5	<welcome-file-list>
6	<welcome-file>index.html</welcome-file>
7	<welcome-file>index.htm</welcome-file>
8	<welcome-file>index.jsp</welcome-file>
9	<welcome-file>default.html</welcome-file>
10	<welcome-file>default.htm</welcome-file>
11	<welcome-file>default.jsp</welcome-file>
12	</welcome-file-list>
13	</web-app>
14

📝 Key Takeaways

Key ideas of Hibernate - Retrieving Records from the Database explained simply
Ready-to-use code examples
Exam-style questions at the end

Hibernate

Nearby lessons

Hibernate - Retrieving Records from the Database

01Retrieving Records from the Database

02HIBERNATE with My SQL Database

03HIBERNATE with My SQL Database — Employee.java

04HIBERNATE with My SQL Database — Employee.hbm.xml

05HIBERNATE with My SQL Database — hibernate.cfg.xml

06HIBERNATE with My SQL Database — HibernateUtil.java

07HIBERNATE with My SQL Database — ClientApp.java

08AWT/GUI-Hibernate Integration Application — Student.java

09AWT/GUI-Hibernate Integration Application — Student.hbm.xml

10AWT/GUI-Hibernate Integration Application — hibernate.cfg.xml

11AWT/GUI-Hibernate Integration Application — HibernateUtil.java

12AWT/GUI-Hibernate Integration Application — StudentService.java

13AWT/GUI-Hibernate Integration Application — SearchFrame.java

14AWT/GUI-Hibernate Integration Application — ClientApp.java

15Servlet_Hibernate_Application — loginform.html

16Servlet_Hibernate_Application — success.html

17Servlet_Hibernate_Application — failure.html

18Servlet_Hibernate_Application — hibernate.cfg.xml

19Servlet_Hibernate_Application — User.hbm.xml

20Servlet_Hibernate_Application — HibernateUtil.java

21Servlet_Hibernate_Application — User.java

22Servlet_Hibernate_Application — UserService.java

23Servlet_Hibernate_Application — LoginServlet.java

24Servlet_Hibernate_Application — web.xml

25JSP_Hibernate_Application — searchform.html

26JSP_Hibernate_Application — notexisted.html

27JSP_Hibernate_Application — display.jsp

28JSP_Hibernate_Application — search.jsp

29JSP_Hibernate_Application — Customer.java

30JSP_Hibernate_Application — Customer.hbm.xml

31JSP_Hibernate_Application — hibernate.cfg.xml

32JSP_Hibernate_Application — web.xml

Retrieving Records from the Database

HIBERNATE with My SQL Database

HIBERNATE with My SQL Database — Employee.java

HIBERNATE with My SQL Database — Employee.hbm.xml

HIBERNATE with My SQL Database — hibernate.cfg.xml

HIBERNATE with My SQL Database — HibernateUtil.java

HIBERNATE with My SQL Database — ClientApp.java

AWT/GUI-Hibernate Integration Application — Student.java

AWT/GUI-Hibernate Integration Application — Student.hbm.xml

AWT/GUI-Hibernate Integration Application — hibernate.cfg.xml

AWT/GUI-Hibernate Integration Application — HibernateUtil.java

AWT/GUI-Hibernate Integration Application — StudentService.java

AWT/GUI-Hibernate Integration Application — SearchFrame.java

AWT/GUI-Hibernate Integration Application — ClientApp.java

Servlet_Hibernate_Application — loginform.html

Servlet_Hibernate_Application — success.html

Servlet_Hibernate_Application — failure.html

Servlet_Hibernate_Application — hibernate.cfg.xml

Servlet_Hibernate_Application — User.hbm.xml

Servlet_Hibernate_Application — HibernateUtil.java

Servlet_Hibernate_Application — User.java

Servlet_Hibernate_Application — UserService.java

Servlet_Hibernate_Application — LoginServlet.java

Servlet_Hibernate_Application — web.xml

JSP_Hibernate_Application — searchform.html

JSP_Hibernate_Application — notexisted.html

JSP_Hibernate_Application — display.jsp

JSP_Hibernate_Application — search.jsp

JSP_Hibernate_Application — Customer.java

JSP_Hibernate_Application — Customer.hbm.xml

JSP_Hibernate_Application — hibernate.cfg.xml

JSP_Hibernate_Application — web.xml