How do I populate an arraylistType with a result fetched from the mysql database using Hibernate?

Question

How do I populate an arraylistType with a result fetched from the mysql database using Hibernate?

Navigation

#1 by (1 votes)

1

On many topics I see a piece of code I can not reproduce:

 Query query = session.createQuery()

I can not create this session object with the createQuery () method as an option. Can someone show me an example of how to populate an ArrayList using Hibernate?

Thank you guys!

mysql java hibernate jpa

asked by anonymous 05.09.2015 / 16:16

1 answer

Show only one record of each ID Icons do not stay on the same line

score 1 · Answer 1

In this case you already have to have your project configured with hibernate packages.

From here you can follow this small example: Create a utility class:

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {

private static final SessionFactory sessionFactory = buildSessionFactory();

private static SessionFactory buildSessionFactory() {
    try {
        // Create the SessionFactory from hibernate.cfg.xml
        return new Configuration().configure().buildSessionFactory();
    }
    catch (Throwable ex) {
        // Make sure you log the exception, as it might be swallowed
        System.err.println("Initial SessionFactory creation failed." + ex);
        throw new ExceptionInInitializerError(ex);
    }
}

public static SessionFactory getSessionFactory() {
    return sessionFactory;
}

public static void shutdown() {
    // Close caches and connection pools
    getSessionFactory().close();
}

}

Now create one to test:

public class App 
{
public static void main( String[] args )
{
    Session session = HibernateUtil.getSessionFactory().openSession();

    Query query = session.createQuery("from Stock where stockCode = :code");
    query.setParameter("code", "7277");
    List list = query.list();
}
}