hibernateservice.java

Extjs2增删改查

package com.tcg.core.Utils;

import org.hibernate.Criteria;
import org.hibernate.SQLQuery;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;

import java.io.File;
import java.util.List;

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: 2008-10-6
 * Time: 13:20:09
 * To change this template use File | Settings | File Templates.
 */
public class HibernateService {
    private static SessionFactory sessionFactory;
    private static Session session;

    static {

        try {
            // Create the SessionFactory
            sessionFactory = new Configuration().configure(new File("src/hibernate.cfg.xml"))
                    .buildSessionFactory();
            session = sessionFactory.openSession();
        }catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static List findBySQL(String sql) {
        SQLQuery query = session.createSQLQuery(sql);
        List list = query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP).list();
        return list;
    }

}