Hibernate – save image into database | save files into database using hibernate

how to save image and files into database using hibernate

For Explanation watch video::

Directory Structure:

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<groupId>com.test</groupId>

<artifactId>ImgFile</artifactId>

<version>0.0.1-SNAPSHOT</version>

<packaging>jar</packaging>

<name>ImgFile</name>

<url>http://maven.apache.org</url>

<properties>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

<maven.compiler.source>1.9</maven.compiler.source>

<maven.compiler.target>1.9</maven.compiler.target>

</properties>

<dependencies>

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>3.8.1</version>

<scope>test</scope>

</dependency>

<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->

<dependency>

<groupId>org.hibernate</groupId>

<artifactId>hibernate-core</artifactId>

<version>5.4.10.Final</version>

</dependency>

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>8.0.22</version>

</dependency>

<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

<version>1.18.20</version>

<scope>provided</scope>

</dependency>

</dependencies>

</project>

hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-5.0.dtd">

<hibernate-configuration>

<session-factory>

<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/new</property>

<property name="hibernate.connection.username">root</property>

<property name="hibernate.connection.password">root</property>

<property name="show_sql">true</property>

<property name="format_sql">true</property>

<property name="hbm2ddl.auto">update</property>

</session-factory>

</hibernate-configuration>

Employee

package com.entity;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Lob;

import javax.persistence.Table;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

@Data

@AllArgsConstructor

@NoArgsConstructor

@Entity

@Table(name = "emptab")

public class Employee {

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Column(name = "eid")

private Integer empId;

@Column(name = "ename")

private String empName;

@Lob

@Column(name = "empPhoto")

private byte[] photo;

@Lob

@Column(name = "empResume")

private char[] resume;

}

HibernateUtil

package com.util;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

import com.entity.Employee;

public class HibernateUtil {

static SessionFactory factory = null;

static {

Configuration cfg = new Configuration();

cfg.configure("hibernate.cfg.xml");

cfg.addAnnotatedClass(Employee.class);

factory = cfg.buildSessionFactory();

}

public static SessionFactory getSessionFactory() {

return factory;

}

public static Session getSession() {

return factory.openSession();

}

}

App

package com.test;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileReader;

import java.io.InputStream;

import java.io.Reader;

import org.hibernate.HibernateException;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import com.entity.Employee;

import com.util.HibernateUtil;

public class App 

{

    public static void main( String[] args )

    {

   

    //get SessionFactory

    SessionFactory factory = HibernateUtil.getSessionFactory();

    //get the session

    Session ses = HibernateUtil.getSession();

    try(factory;ses){

    //read the photo

    File file1 = new File("E:\\Jar Files\\man.png");

    InputStream ip = new FileInputStream(file1);

    byte[] photo = new byte[(int)file1.length()];

    ip.read(photo);

   

   

    //read resume

    File file2 = new File("E:\\Jar Files\\resume.txt");

    Reader reader = new FileReader(file2);

    char[] resume = new char[(int)file2.length()];

    reader.read(resume);

   

    //creat the emp obj

    Employee emp = new Employee();

    emp.setEmpName("SAM");

    emp.setPhoto(photo);

    emp.setResume(resume);

   

    //save this obj

   

   

    //begin the tx

    ses.beginTransaction();

   

    ses.save(emp);

   

    //commit the tx

    ses.getTransaction().commit();

   

    }catch(HibernateException he) {

    he.printStackTrace();

    }catch(Exception e) {

    e.printStackTrace();

    }

    }

}