mybatis一对多

扫码查看

一.课程包含课时

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

02-12 04:58
查看更多