From fc7a6634496066fe45dca8ea9832bdd2f7341db4 Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 13 十月 2020 10:25:39 +0800
Subject: [PATCH] 百度内容联盟前端分类，首页弹窗广告
---
src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java b/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
index 0d52732..0875469 100644
--- a/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
+++ b/src/main/java/com/yeshi/buwan/dao/VideoInfoDao.java
@@ -1,9 +1,48 @@
package com.yeshi.buwan.dao;
+import com.yeshi.buwan.dao.base.BaseDao;
import org.springframework.stereotype.Repository;
import com.yeshi.buwan.domain.VideoInfo;
+import org.yeshi.utils.StringUtil;
+
+import java.io.Serializable;
+import java.util.ArrayList;
+import java.util.Arrays;
+import java.util.List;
+
@Repository
public class VideoInfoDao extends BaseDao<VideoInfo> {
-
+
+ /**
+ * 鏍规嵁鍚嶅瓧鏌ヨ
+ *
+ * @param name
+ * @param start
+ * @param count
+ * @return
+ */
+ public List<VideoInfo> listByName(String name, int start, int count) {
+ return list("from VideoInfo vi where vi.name=?", start, count, new Serializable[]{name});
+ }
+
+
+ /**
+ * 鏍规嵁涓婚敭鎵归噺鏌ヨ
+ *
+ * @param videoIds
+ * @return
+ */
+ public List<VideoInfo> listByVideoIds(List<String> videoIds) {
+ String hql = "from VideoInfo vi where ";
+ List<String> ors = new ArrayList<>();
+ for (String vi : videoIds) {
+ ors.add(" vi.id=? ");
+ }
+ hql += StringUtil.concat(ors, "or");
+ String[] videos = new String[videoIds.size()];
+ videoIds.toArray(videos);
+ return list(hql, videos);
+ }
+
}
--
Gitblit v1.8.0