SELECT a.*,b.course,b.total_nodes,d.teacher_name FROM tp_student_course a JOIN tp_..._mybatisplus if标签">
当前位置:   article > 正文

Mybatis puls 中if标签中 进行传值整型数据判断_mybatisplus if标签

mybatisplus if标签
  1. <select id="findStudentCoursePageBy" resultType="org.jeecg.modules.course.vo.TpStudentCoursePageVO" >
  2. SELECT a.*,b.course,b.total_nodes,d.teacher_name
  3. FROM tp_student_course a JOIN tp_course_info b ON a.course_id=b.id
  4. JOIN tp_teacher_info d ON b.lecturer_id=d.id
  5. WHERE a.create_by = #{queryName}
  6. <if test="map.isOver!= null and map.isOver!='' or map.isOver==0">
  7. and a.is_over = #{map.isOver}
  8. <if test="map.isOver != 1 and map.learnType != null and map.learnType!=''">
  9. <choose>
  10. <when test="map.learnType =='1' ">
  11. and a.course_id in( SELECT c.course_id
  12. from tp_course_record c
  13. WHERE c.create_by = #{queryName}
  14. group by c.course_id
  15. HAVING max(c.learn_time)!=0 )
  16. </
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/盐析白兔/article/detail/255685
推荐阅读
相关标签
  

闽ICP备14008679号