Hibernate With Select Stored Procedure

                                          
                                                Download 

Hibernate Find All Products With StoredProcedure

Database

CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `price` decimal(10,0) DEFAULT NULL,
  `quantity` int(45) DEFAULT NULL,
  `description` varchar(450) DEFAULT NULL,
  `photo` varchar(45) DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `createiondate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
)

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getproducts`()
BEGIN

SELECT id as id,
name as name,
price as price,
quantity as quantity ,
description as description,
photo as photo ,
active as active,
createiondate as createiondate
 FROM product;
END$$
DELIMITER ;

hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                                         "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory >
  <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  <property name="hibernate.connection.password">ravi</property>
  <property name="hibernate.connection.url">jdbc:mysql://localhost/hibernate</property>
  <property name="hibernate.connection.username">root</property>
  <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="hibernate.current_session_context_class">thread</property>
  <mapping class="java9r.entites.com.Product"/>
 </session-factory>
</hibernate-configuration>

hibernate.reveng.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
</hibernate-reverse-engineering>

HibernateUtil.java

package java9r.util.com;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
 
@SuppressWarnings("deprecation")
public class HibernateUtil {
    private static SessionFactory sessionFactory;
     
    static{
     try{
      sessionFactory=new AnnotationConfiguration().configure().buildSessionFactory();
     }catch (Throwable ex) {
      System.err.println("Initial sessionFactory creation failed."+ex);
      throw new ExceptionInInitializerError(ex);
  
  }
    }
 
    public static SessionFactory getSessionFactory() {
   
        return sessionFactory;
    }
}

Product.java

package java9r.entites.com;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
@Table(name = "product", catalog = "hibernate")
public class Product implements java.io.Serializable {

 private Integer id;
 private String name;
 private Long price;
 private Integer quantity;
 private String description;
 private String photo;
 private Boolean active;
 private Date createiondate;

 public Product() {
 }

 public Product(Date createiondate) {
  this.createiondate = createiondate;
 }

 public Product(String name, Long price, Integer quantity,
   String description, String photo, Boolean active, Date createiondate) {
  this.name = name;
  this.price = price;
  this.quantity = quantity;
  this.description = description;
  this.photo = photo;
  this.active = active;
  this.createiondate = createiondate;
 }

 @Id
 @GeneratedValue(strategy = IDENTITY)
 @Column(name = "id", unique = true, nullable = false)
 public Integer getId() {
  return this.id;
 }

 public void setId(Integer id) {
  this.id = id;
 }

 @Column(name = "name", length = 45)
 public String getName() {
  return this.name;
 }

 public void setName(String name) {
  this.name = name;
 }

 @Column(name = "price", precision = 10, scale = 0)
 public Long getPrice() {
  return this.price;
 }

 public void setPrice(Long price) {
  this.price = price;
 }

 @Column(name = "quantity")
 public Integer getQuantity() {
  return this.quantity;
 }

 public void setQuantity(Integer quantity) {
  this.quantity = quantity;
 }

 @Column(name = "description", length = 450)
 public String getDescription() {
  return this.description;
 }

 public void setDescription(String description) {
  this.description = description;
 }

 @Column(name = "photo", length = 45)
 public String getPhoto() {
  return this.photo;
 }

 public void setPhoto(String photo) {
  this.photo = photo;
 }

 @Column(name = "active")
 public Boolean getActive() {
  return this.active;
 }

 public void setActive(Boolean active) {
  this.active = active;
 }

 @Temporal(TemporalType.TIMESTAMP)
 @Column(name = "createiondate", nullable = false, length = 19)
 public Date getCreateiondate() {
  return this.createiondate;
 }

 public void setCreateiondate(Date createiondate) {
  this.createiondate = createiondate;
 }

}

ProductDAO.java

package java9r.dao.com;
import java9r.entites.com.*;
import java9r.util.com.*;
import java.util.*;
import org.hibernate.*;

public class ProductDAO {
 private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
 @SuppressWarnings("unchecked")

 public List<Product> FindAllProducts(){
  










try {  
if(!sessionFactory.getCurrentSession().getTransaction().isActive())
sessionFactory.getCurrentSession().getTransaction().begin();
SQLQuery sqlq = sessionFactory.getCurrentSession()
.createSQLQuery("call getproducts()");
return sqlq.addEntity(Product.class).list();
} catch (Exception e) {
return null;
}
}

}

ProductMain.java

package java9r.main.com;
import java.util.List;
import java9r.dao.com.*;
import java9r.entites.com.*;
public class ProductMain {
 public static void main(String[] args) {
  ProductDAO product=new ProductDAO();
  List<Product> liProducts=product.FindAllProducts();
  System.out.println("Number of Products - " + liProducts.size());
  for (Product p : liProducts){
   System.out.println("Id " + p.getId());
   System.out.println("Name " + p.getName());
   System.out.println("Price  " + p.getPrice());
   System.out.println("Description  " + p.getDescription());
   System.out.println("Status  " + p.getActive());
   System.out.println("---------------");
  }
 }

}

Output