Tutusfunny

Hibernate is an object relational mapping model develop the framework for java.in article we use to get the current date and time and MySQL version using Hibernate (ORM).

you have to download the following dependencies

mysql connector jar

hibernate-core 5.3.29 download jar

after download the dependencies you have add into the lib folder i attached the video lesson below.how to make step by
step.

Create the Class Appinitializer

Appinitializer

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.Metadata;
import org.hibernate.boot.MetadataSources;
import org.hibernate.boot.registry.StandardServiceRegistry;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Environment;

import java.util.HashMap;
import java.util.Map;

public class Appinitializer{


    public static void main(String args[]) {

        printDateTime();
        MysqlVersion();

}

    public  static  void MysqlVersion() 
    {
        try(Session session = HibranateUtil.getSessionFactory().openSession())
        {
            Object obj = session.createNativeQuery("SELECT VERSION()").getSingleResult();
            System.out.println(obj);
        }
    }

    public  static  void printDateTime()
    {
        try(Session session = HibranateUtil.getSessionFactory().openSession())
        {
            Object obj = session.createNativeQuery("SELECT NOW()").getSingleResult();
            System.out.println(obj);
        }
    }
}

HibranateUtil.java

import org.hibernate.SessionFactory;
import org.hibernate.boot.Metadata;
import org.hibernate.boot.MetadataSources;
import org.hibernate.boot.registry.StandardServiceRegistry;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Environment;
import java.util.HashMap;
import java.util.Map;

public class HibranateUtil {


    private static StandardServiceRegistry standardServiceRegistry;
    private static SessionFactory sessionFactory;

    static {
        try {

            if (sessionFactory == null) 
            {
                standardServiceRegistry = new StandardServiceRegistryBuilder().configure("hibernate.cfg.xml").build();
                MetadataSources metadataSources = new MetadataSources(standardServiceRegistry);
                Metadata metadata = metadataSources.getMetadataBuilder().build();
                sessionFactory = metadata.getSessionFactoryBuilder().build();
            }
            
        } catch (Exception e) {
            if (standardServiceRegistry != null)
            {
                StandardServiceRegistryBuilder.destroy(standardServiceRegistry);
            }
        }

    }
    public static SessionFactory getSessionFactory()
    {
        return sessionFactory;
    }

}

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="connection.url">jdbc:mysql://localhost:3306/dbsms?createDatabaseIfNotExist=true </property>
    <property name="connection.driver_class">com.mysql.cj.jdbc.Driver </property>
     <property name="connection.username">root</property>
     <property name="connection.password">root123</property>
    <property name="dialect">org.hibernate.dialect.MySQL57Dialect</property>
  <property name="hibernate.hbm2ddl.auto">update</property>
  </session-factory>
</hibernate-configuration>

I have attached the video link below. which will do this tutorials step by step.