Spring用回调HibernateCallBack方法

最新推荐文章于 2019-07-26 16:18:53 发布

最新推荐文章于 2019-07-26 16:18:53 发布 · 157 阅读

文章标签：

#Spring #Hibernate #SQL #ORM

Java 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了如何使用Spring框架整合Hibernate，通过自定义HibernateCallback实现数据查询及批量删除操作。提供了具体的代码实例，展示了如何简化复杂的数据访问逻辑。

Spring用回调HibernateCallBack方法实现持久层一些功能,当这些功能不能满足需求时,
我们也可以自已来重写HibernateCallBack,例:
public class UsersDAO extends HibernateDaoSupport {
......
public List getUsers() {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
Query query = s.createQuery("From Users AS user ORDER BY user.username DESC");
List list = query.list();
return list;
}
});
}
......
}
但是这样的代码很难让人理解,可以将其打包
package com.notepad.comm;
import java.sql.SQLException;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
public class HQLCallBackUtil implements HibernateCallback {
private String hql;

public HQLCallBackUtil(){

}

public HQLCallBackUtil(String hql){
this.hql=hql;
}
public String getHql() {
return hql;
}
public void setHql(String hql) {
this.hql = hql;
}
public Object doInHibernate(Session s) throws HibernateException,
SQLException {
if (hql == null || hql.equals("")) {
throw new HibernateException("Can't execute NULL hql!");
}
return s.createQuery(hql).list();
}
}
然后可以通过如下代码进行调用
public class UsersDAO extends HibernateDaoSupport {
......
public List getUsers() {
HQLCallBackUtil callBack=new HQLCallBackUtil();
callBack.setHql("From Users AS user ORDER BY user.username DESC");
return this.getHibernateTemplate().executeFind(callBack);
}
......
}
这样是不是感觉简单很多呢!

<2>利用回调函数处理

public List getApList() ...{
return (List)this.getHibernateTemplate().execute(new HibernateCallback() ...{

        public Object doInHibernate(Session session) throws HibernateException, SQLException ...{
             String[] ids = ...{"1","2","3"};
             String   hql= "from Appinfo where id   in   (:ids)";
             Query query = session.createQuery(hql);
             List list = query.setParameterList("ids", ids).list();
            return list;
         }
         });
     }
(2)删除数据，参数为数组，利用回调函数

public void delInArray() ...{
this.getHibernateTemplate().execute(new HibernateCallback() ...{

        public Object doInHibernate(Session session) throws HibernateException, SQLException ...{
             String[] ids = ...{"1","2","3"};
             String   hql= "delete Appinfo where id   in   (:ids)";
             Query query = session.createQuery(hql);
             query.setParameterList("ids", ids).executeUpdate();
            return null;
         }
         });