Program 1
<%--
Document : DisplayPage
Created on : Dec 16, 2023, 4:17:59 PM
Author : admin
--%>
<%@page import="java.util.List"%>
<%@page import="beans.Product"%>
<%@page import="org.hibernate.Query"%>
<%@page import="org.hibernate.Session"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page import="org.hibernate.cfg.Configuration"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<form method="post" action="DisplayPage.jsp">
First Value<input type="text" name="txt1">
Last Value<input type="text" name="txt2">
<input type="submit" value="Dispaly">
</form>
<%
String s1=null,s2=null;
s1=request.getParameter("txt1");
s2=request.getParameter("txt2");
if(s1!=null || s2!=null)
{
int f,s;
f=Integer.parseInt(s1);
s=Integer.parseInt(s2);
Configuration cfg=new Configuration();
cfg.configure("resources/hibernate.cfg.xml");
SessionFactory sf=cfg.buildSessionFactory();
Session session1=sf.openSession();
Query q=session1.createQuery("From Product");
q.setFirstResult(f);
q.setMaxResults(s);
List<Product> mylist=q.list();
out.println("<table border=1>");
out.println("<tr><th>Product ID</th><th>Product Name</th><th>Product Price</th></tr>");
for(Product P:mylist)
{
out.println("<tr>");
out.println("<td>"+P.getPid()+"</td>");
out.println("<td>"+P.getPname()+"</td>");
out.println("<td>"+P.getPrice()+"</td>");
out.println("</tr>");
}
out.println("</table>");
}
%>
</center>
</body>
</html>Program 2
package beans;
public class Product
{
private int pid;
private String pname;
private int price;
public Product() {
}
public int getPid() {
return pid;
}
public void setPid(int pid) {
this.pid = pid;
}
public String getPname() {
return pname;
}
public void setPname(String pname) {
this.pname = pname;
}
public int getPrice() {
return price;
}
public void setPrice(int price) {
this.price = price;
}
}Program 3
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="beans.Product" table="product" schema="dataflair">
<id name="pid" column="pid"></id>
<property name="pname" column="pname"></property>
<property name="price" column="price"></property>
</class>
</hibernate-mapping>Program 4
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/dataflair</property>
<property name="connection.username">root</property>
<property name="connection.password">root@data</property>
<property name="connection.pool_size">10</property>
<property name="hbm2ddl.auto">update</property>
<property name="show_sql">true</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<mapping resource="resources/product.hbm.xml"/>
</session-factory>
</hibernate-configuration>Program 5
package view;
import beans.Product;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class TestMain
{
public static void main(String[] args)
{
Configuration cfg=new Configuration();
cfg.configure("resources/hibernate.cfg.xml");
SessionFactory sf=cfg.buildSessionFactory();
Session session=sf.openSession();
Product P1=new Product();
P1.setPid(104);
P1.setPname("Mobile");
P1.setPrice(70000);
Product P2=new Product();
P2.setPid(105);
P2.setPname("Watch");
P2.setPrice(7000);
Product P3=new Product();
P3.setPid(106);
P3.setPname("Mike");
P3.setPrice(80000);
Product P4=new Product();
P4.setPid(107);
P4.setPname("KeyBoard");
P4.setPrice(4000);
Product P5=new Product();
P5.setPid(108);
P5.setPname("TV");
P5.setPrice(48000);
session.save(P1);
session.save(P2);
session.save(P3);
session.save(P4);
session.save(P5);
session.beginTransaction().commit();
session.close();
sf.close();
System.out.println("Record Save..........");
}
}
