From c6c5a8ce0f42d46ea2fe0312c9eda67a49fd3917 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 01 二月 2021 18:58:21 +0800
Subject: [PATCH] 完善根据IP屏蔽广告,创建会员实体
---
src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java | 20 ++++++++++++++++++++
1 files changed, 20 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java b/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
index 0875469..eb9c7aa 100644
--- a/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
+++ b/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
@@ -1,6 +1,9 @@
package com.yeshi.buwan.dao;
import com.yeshi.buwan.dao.base.BaseDao;
+import org.hibernate.HibernateException;
+import org.hibernate.Session;
+import org.springframework.orm.hibernate4.HibernateCallback;
import org.springframework.stereotype.Repository;
import com.yeshi.buwan.domain.VideoInfo;
@@ -45,4 +48,21 @@
return list(hql, videos);
}
+ /**
+ * 缁熻瑙嗛闄勫姞淇℃伅锛堝寘鍚湴鍖猴紝鍒嗙被锛屾潵婧愶級
+ *
+ * @param videoId -瑙嗛ID
+ */
+ public void statisticVideoExtraInfo(final String videoId) {
+ excute(new HibernateCallback() {
+ @Override
+ public Object doInHibernate(Session session) throws HibernateException {
+ session.getTransaction().begin();
+ session.createSQLQuery(String.format("call copyvideotemp(%s)", videoId)).executeUpdate();
+ session.getTransaction().commit();
+ return null;
+ }
+ });
+ }
+
}
--
Gitblit v1.8.0