From bf13676673e9f0f090a68bd8cfbaefbf0d696d32 Mon Sep 17 00:00:00 2001
From: EricsHu <hrr145632>
Date: 星期日, 26 十一月 2023 13:03:00 +0800
Subject: [PATCH] 讨论区关键字过滤、首页班级显示班级信息
---
src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java | 13 ++++++++++---
1 files changed, 10 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java b/src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java
index 35b8e91..04a4ca9 100644
--- a/src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java
+++ b/src/main/java/com/qxueyou/scc/exam/dao/ExamResultVDao.java
@@ -11,9 +11,16 @@
@Repository
public class ExamResultVDao extends BaseDAO {
- public List<ExamResultV> getResultList(String classId, Pager pager) {
- String hql = "from ExamResultV where class_Id LIKE ?";
- return this.findList(hql,pager,CollectionUtils.newList(classId),ExamResultV.class);
+ public List<ExamResultV> getResultList(String classId) {
+ String hql = "from ExamResultV where class_Id LIKE ? and score != null and score != 0";
+ return this.find(hql,CollectionUtils.newList(classId),ExamResultV.class);
+ }
+
+ public int getExamCount(String classId) {
+ //id.
+ String hql = "select count(distinct examId) from ExamResultV where class_Id=?";
+
+ return this.findCount(hql, CollectionUtils.newList(classId));
}
--
Gitblit v1.8.0