一.课程包含课时
xml如下:
<resultMap id="culTrainCoursePO" type="com.thinkgem.jeesite.modules.train.entity.CulTrainCoursePO"> <id column="id" jdbcType="VARCHAR" property="id" /> <result column="course_name" jdbcType="VARCHAR" property="courseName" /> <result column="bel_project_id" jdbcType="VARCHAR" property="belProjectId" /> <result column="lesson_num" jdbcType="VARCHAR" property="lessonNum" /> <result column="lesson_hour" jdbcType="VARCHAR" property="lessonHour" /> <result column="need_student_num" jdbcType="VARCHAR" property="needStudentNum" /> <result column="now_student_num" jdbcType="VARCHAR" property="nowStudentNum" /> <result column="check_status" jdbcType="VARCHAR" property="checkStatus" /> <result column="course_type" jdbcType="VARCHAR" property="courseType" /> <result column="course_status" jdbcType="VARCHAR" property="courseStatus" /> <result column="course_teacher" jdbcType="VARCHAR" property="courseTeacher" /> <result column="course_address" jdbcType="VARCHAR" property="courseAddress" /> <result column="course_start_time" jdbcType="VARCHAR" property="courseStartTime" /> <result column="course_end_time" jdbcType="VARCHAR" property="courseEndTime" /> <result column="course_pic_url" jdbcType="VARCHAR" property="coursePicUrl" /> <result column="teacher_intro" jdbcType="VARCHAR" property="teacherIntro" /> <result column="need_know" jdbcType="VARCHAR" property="needKnow" /> <result column="course_intro" jdbcType="VARCHAR" property="courseIntro" /> <result column="create_by" jdbcType="VARCHAR" property="createBy.id" /> <result column="create_date" jdbcType="TIMESTAMP" property="createDate" /> <result column="update_by" property="updateBy.id" /> <result column="update_date" jdbcType="TIMESTAMP" property="updateDate" /> <result column="remarks" jdbcType="VARCHAR" property="remarks" /> <result column="del_flag" jdbcType="CHAR" property="delFlag" /> <result column="is_need_card" jdbcType="VARCHAR" property="isNeedCard" /> <result column="is_need_look" jdbcType="VARCHAR" property="isNeedLook" /> <result column="is_need_check" jdbcType="VARCHAR" property="isNeedCheck" /> <result column="is_draw_able" jdbcType="VARCHAR" property="isDrawAble" /> <result column="sex_need" jdbcType="VARCHAR" property="sexNeed" /> <result column="score_need" jdbcType="VARCHAR" property="scoreNeed" /> <result column="min_age" jdbcType="VARCHAR" property="minAge" /> <result column="max_age" jdbcType="VARCHAR" property="maxAge" /> <result column="enroll_num" jdbcType="VARCHAR" property="enrollNum" /> <result column="is_special" jdbcType="VARCHAR" property="isSpecial" /> <result column="is_cancel" jdbcType="VARCHAR" property="isCancel" /> <result column="key_word" jdbcType="VARCHAR" property="keyWord" /> <result column="store_count" jdbcType="VARCHAR" property="storeCount" /> <result column="support_count" jdbcType="VARCHAR" property="supportCount" /> <result column="comment_count" jdbcType="VARCHAR" property="commentCount" /> <result column="share_count" jdbcType="VARCHAR" property="shareCount" /> <result column="hits" jdbcType="VARCHAR" property="hits" /> <collection property="culTrainLessonPOs" ofType="com.thinkgem.jeesite.modules.train.entity.CulTrainLessonPO"> <id property="id" column="lesson_id"/> <result property="courseId" column="course_id"/> <result property="lessonBatchNum" column="lesson_batch_num"/> <result property="lessonDate" column="lesson_date"/> <result property="startTime" column="start_time"/> <result property="endTime" column="end_time"/> <result property="signNum" column="sign_num"/> <result property="createBy.id" column="l_create_by"/> <result property="createDate" column="l_create_date"/> <result property="updateBy.id" column="l_update_by"/> <result property="updateDate" column="l_update_date"/> <result property="remarks" column="l_remarks"/> <result property="delFlag" column="l_del_flag"/> </collection> </resultMap> <select id="selectCourseLessonById" parameterType="String" resultMap="culTrainCoursePO"> select c.*,l.id lesson_id,l.course_id,l.lesson_batch_num from cul_train_course c left join cul_train_lesson l on l.course_id = c.id where c.id = #{id} </select> <select id="selectCourseLesson" resultMap="culTrainCoursePO"> select c.*,l.id lesson_id,l.course_id,l.lesson_batch_num from cul_train_course c left join cul_train_lesson l on l.course_id = c.id </select>
参考来源:https://blog.csdn.net/qq_36791569/article/details/81517080