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