讨论区关键字过滤、首页班级显示班级信息

EricsHu

2023-11-26 bf13676673e9f0f090a68bd8cfbaefbf0d696d32

 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));
    }