From f788607ff771a47bc60d6a86e00b3433c40f3d2c Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期五, 24 九月 2021 15:22:03 +0800 Subject: [PATCH] 接入视频直播 --- src/main/java/com/yeshi/buwan/dao/base/BaseDao.java | 43 +++++++++++++++++++++++++++++++++++++++---- 1 files changed, 39 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/yeshi/buwan/dao/base/BaseDao.java b/src/main/java/com/yeshi/buwan/dao/base/BaseDao.java index e81d1fc..1552e36 100644 --- a/src/main/java/com/yeshi/buwan/dao/base/BaseDao.java +++ b/src/main/java/com/yeshi/buwan/dao/base/BaseDao.java @@ -8,9 +8,9 @@ import org.springframework.orm.hibernate4.HibernateCallback; import org.springframework.orm.hibernate4.HibernateTemplate; import org.springframework.stereotype.Repository; +import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; -import javax.transaction.Transactional; import java.io.Serializable; import java.util.List; @@ -80,6 +80,40 @@ query.setMaxResults(count); log.info("list"); return query.list(); + } + }); + + } + + public List<T> findList(String hql, final int start, final int count, final Serializable[] params) { + final String tempsql = hql; + return (List<T>) hibernateTemplate.execute(new HibernateCallback() { + public Object doInHibernate(Session session) throws HibernateException { + Query query = session.createQuery(tempsql); + if (params != null) + for (int i = 0; i < params.length; i++) { + query.setParameter(i, params[i]); + } + query.setFirstResult(start); + query.setMaxResults(count); + log.info("list"); + return query.list(); + } + }); + + } + + + public void update(String hql, final Serializable[] params) { + hibernateTemplate.execute(new HibernateCallback() { + public Object doInHibernate(Session session) throws HibernateException { + Query query = session.createQuery(hql); + if (params != null) + for (int i = 0; i < params.length; i++) { + query.setParameter(i, params[i]); + } + query.executeUpdate(); + return null; } }); @@ -166,9 +200,10 @@ String hql = "select count(*) " + hqlStr.substring(fromIndex); Query query = session.createQuery(hql); - for (int i = 0; i < wheres.length; i++) { - query.setParameter(i, wheres[i]); - } + if (wheres != null) + for (int i = 0; i < wheres.length; i++) { + query.setParameter(i, wheres[i]); + } return Long.parseLong(query.uniqueResult() + ""); } }); -- Gitblit v1.8.0