5-17 作业提交系统-CSDN博客

本文链接：https://blog.csdn.net/m0_66545700/article/details/139048822

问题描述

客户端学生课程无法显示
客户端教师添加作业信息,学生端和管理端不显示
学生端作业按学院显示，教师给对应的学院布置作业

# 启动前问题

vue启动错误，因为node版本不同，所以使用node16.20.2
springboot要启动redis

客户端学生课程无法显示

发现时通过院系id显示的，可是后端的数据库中的 college_id 是空的。根据要求，我们要通过专业进行筛选。

    <select id="getList" resultType="com.project.demo.entity.LearningResource" parameterType="int">
        select *
        from learning_resource
        <where>
            <if test="userId != null and userId != ''">
                college_id =
                    (select college_information_id
                    from college_information
                    where college_name =
                        (select college_name
                        from student_users
                        where user_id = #{userId}))
                    or teacher_users = #{userId}
            </if>
        </where>
        LIMIT ${startIndex},${size};
    </select>

解决

    <select id="getList" resultType="com.project.demo.entity.LearningResource" parameterType="int">
        select *
        from learning_resource
        <where>
            <if test="userId != null and userId != ''">
                professional_name =
                        (select professional_name
                        from student_users
                        where user_id = #{userId})
            </if>
        </where>
        LIMIT ${startIndex},${size};
    </select>

客户端教师添加作业信息,学生端和管理端不显示

查看代码可知，通过learning_resoutce 和 assignment_information 链接，是通过两者的图片地址进行连接的。如果没有上传图片，那么无法查询到。

    <select id="getStudentAss1" parameterType="int" resultType="map">
        select a.*,l.college_name,l.resource_name
        from learning_resource l,assignment_information a
        where a.course_cover = l.resource_images
          and a.status = 1
          and l.college_name =
              (select college_name
               from student_users
               where user_id = #{userId})
    </select>

解决

我们通过课程名将两个表进行连接。

 <select id="getStudentAss" parameterType="int" resultType="map">
        select a.*,l.college_name,l.resource_name
        from learning_resource l,assignment_information a
        where a.course_name = l.resource_name
          and a.status = 1
          and l.college_name =
              (select college_name
               from student_users
               where user_id = #{userId})
    </select>