From 4011b8d0b377af33e2bc435f7726329630d706cb Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 02 三月 2021 18:28:52 +0800
Subject: [PATCH] 搜索引擎接口更新
---
src/main/java/com/yeshi/buwan/dao/ConfigDao.java | 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/dao/ConfigDao.java b/src/main/java/com/yeshi/buwan/dao/ConfigDao.java
index b674f44..4b6881b 100644
--- a/src/main/java/com/yeshi/buwan/dao/ConfigDao.java
+++ b/src/main/java/com/yeshi/buwan/dao/ConfigDao.java
@@ -1,5 +1,6 @@
package com.yeshi.buwan.dao;
+import com.yeshi.buwan.dao.base.BaseDao;
import org.springframework.stereotype.Repository;
import com.yeshi.buwan.domain.Config;
@@ -17,16 +18,16 @@
* @return
*/
public List<Config> listBySystemIdAndMaxVersion(Long systemId, int maxVersion) {
- List list = sqlList(" SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", systemId, maxVersion);
+ List list = sqlListWithEntity("SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", Config.class, systemId, maxVersion);
return list;
}
public Config selectByKey(String key, Long systemId, int maxVersion) {
- List list = sqlList(" SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc,`key`=? and vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", key, systemId, maxVersion);
+ List list = sqlListWithEntity("SELECT a.* FROM (SELECT * FROM `wk_video_config` vc where vc.`key`=? and vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", Config.class, key, systemId, maxVersion);
if (list != null && list.size() > 0)
return (Config) list.get(0);
return null;
}
-}
+}
\ No newline at end of file
--
Gitblit v1.8.0