hibernate使用hql查询有诸多不便,比如无法在from后面使用select子查询,(貌似可以解决但是挺麻烦)
所以这里记录下自己找到的一些写法
首先拿到session对象:
|- HibernateSessionFactory.getSession();
这个类是我找的一个工具类,下面会附上工具代码,直接丢里面用就好了
最后在执行sql的时候有些不同
要使用
session.createSQLQuery 而不是session.createQuery
返回一个list的集合:
|- List list = session.createSQLQuery(sql.toString()).list();
注意:
这里的list集合是Object类型,如果想要其返回指定的类型需要做一些变动
返回指定类型的list集合
List list = session.createSQLQuery(sql.toString())
.addScalar("name")
.addScalar("amount",Hibernate.DOUBLE)
.addScalar("sum",Hibernate.INTEGER)
.setResultTransformer(Transformers.aliasToBean(实体.class)).list();
如果你要返回的数据并不多的话,直接addScalar 添加字段的名称和类型进去 ,String类型的数据是不需要加入类型参数的,最后将你需要得到的实体类型加进去
(感谢贡献者!)
package com.ap.batch.util;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html }.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
* Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file.
* The default classpath location of the hibernate config file is
* in the default package. Use #setConfigFile() to update
* the location of the configuration file for the current session.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
private static Configuration configuration = new Configuration();
private static org.hibernate.SessionFactory sessionFactory;
private static String configFile = CONFIG_FILE_LOCATION;
public HibernateSessionFactory() {
}
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session getAnotherSession() throws HibernateException{
if (sessionFactory == null) {
rebuildSessionFactory();
}
return sessionFactory.openSession();
}
public static Session getSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
if (sessionFactory == null) {
rebuildSessionFactory();
}
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
/**
* Rebuild hibernate session factory
*
*/
public static void rebuildSessionFactory() {
try {
configuration.configure(configFile);
sessionFactory = configuration.buildSessionFactory();
} catch (Exception e) {
System.err
.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
/**
* return session factory
*
*/
public static org.hibernate.SessionFactory getSessionFactory() {
return sessionFactory;
}
public static void setConfigFile(String configFile) {
HibernateSessionFactory.configFile = configFile;
sessionFactory = null;
}
/**
* return hibernate configuration
*
*/
public static Configuration getConfiguration() {
return configuration;
}
}