From d73687bc6115007145b4aab050e4e29ff87fd8ae Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期一, 01 三月 2021 18:44:36 +0800
Subject: [PATCH] 布丸代码优化
---
src/main/java/com/yeshi/buwan/service/imp/ClassService.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/yeshi/buwan/service/imp/ClassService.java b/src/main/java/com/yeshi/buwan/service/imp/ClassService.java
index 4c94e05..8811335 100644
--- a/src/main/java/com/yeshi/buwan/service/imp/ClassService.java
+++ b/src/main/java/com/yeshi/buwan/service/imp/ClassService.java
@@ -234,7 +234,7 @@
if (StringUtil.isNullOrEmpty(type)) {
return getVideoInfoData(videoInfoDao.sqlList(
"select v.id,v.`name`,v.`tag`,v.`picture`,v.`hpicture`,v.`latest_hpicture`,v.watchcount,v.commentcount from wk_video_video v INNER JOIN (SELECT DISTINCT(v.id) FROM wk_category_video ca LEFT JOIN wk_video_video v ON v.id= ca.videoid LEFT JOIN wk_resource_video rv ON rv.`videoid`= v.`id` AND( ? ) WHERE v.show= 1 and ca.id is not null AND rv.`resourceid` IS NOT NULL ? ) a using(id)",
- (page - 1) * pageCount, pageCount, new Serializable[]{resourceWhere, orderby,}),resourceList);
+ (page - 1) * pageCount, pageCount, new Serializable[]{resourceWhere, orderby,}), resourceList);
}
List<VideoInfo> list = new ArrayList<VideoInfo>();
@@ -264,7 +264,7 @@
});
System.out.println("鏌ヨSQL璐规椂:" + (System.currentTimeMillis() - startTime));
- return getVideoInfoData(list,resourceList);
+ return getVideoInfoData(list, resourceList);
}
public List<VideoInfo> getVideoInfoData(List list, List<Long> resourceIdList) {
@@ -579,7 +579,7 @@
*/
@SuppressWarnings("unchecked")
- public List<com.yeshi.buwan.domain.web.VideoTypeAdmin> getVideoTypeAdmin(final int detailSystem, final int pid,
+ public List<com.yeshi.buwan.domain.web.VideoTypeAdmin> getVideoTypeAdmin(final String systemId, final int detailSystem, final int pid,
final int page) {
return (List<com.yeshi.buwan.domain.web.VideoTypeAdmin>) videoTypeDao
.excute(new HibernateCallback<List<com.yeshi.buwan.domain.web.VideoTypeAdmin>>() {
@@ -587,7 +587,7 @@
throws HibernateException {
List<com.yeshi.buwan.domain.web.VideoTypeAdmin> hotTypeList = new ArrayList<com.yeshi.buwan.domain.web.VideoTypeAdmin>();
try {
- List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem").list();
+ List<DetailSystem> detailSystemList = session.createQuery("from DetailSystem ds where ds.system.id=" + systemId).list();
String where = "";
List<VideoType> list = null;
--
Gitblit v1.8.0