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>
If you're just beginning to learn Java GUI programming creating an Water System Calculator is a fantastic project for…
GitHub is a powerful tool used by teams and developers around the globe. This guide is…
It's like having a super-smart buddy that is always there to help you write stories,…
The UK is known for its rich history, diverse culture, and most of all its…
Do you have a plan for your next holiday? Being aware of the Bank Holidays within the…
The world is rapidly changing of software development AI-assisted tools for coding have become the main focus. As…