feat：试卷列表多个部门同时展示

龚焕茏

2024-07-03 2372db59f2dd9b76ef04b7866cc350d0c5ebafd6

feat：试卷列表多个部门同时展示

 src/main/resources/mapper/ExamPaperDepartment.xml

@@ -36,7 +36,12 @@
    </select>

    <select id="selectByUserId" resultType="java.lang.String">
        SELECT b.name FROM t_user_department a INNER JOIN t_department b ON a.department_id = b.id WHERE a.user_id = #{userId}
        SELECT GROUP_CONCAT(b.name)
        FROM t_user_department a
        INNER JOIN t_department b ON a.department_id = b.id
        WHERE a.user_id = #{userId}
        GROUP BY a.user_id
        ORDER BY a.user_id
    </select>

    <delete id="removeByExamPaperId" parameterType="java.lang.Integer">