| | |
| | | </sql> |
| | | |
| | | <update id="deleteByCourseId"> |
| | | update ex_course set de_flag=1 where id=#{courseId} |
| | | update ex_course set del_flag=1 where id=#{courseId} |
| | | </update> |
| | | |
| | | <select id="selectCourseList" resultMap="ExCourseResult"> |
| | |
| | | </select> |
| | | |
| | | <select id="selectCountByCourseId" resultType="java.lang.Integer"> |
| | | select count(1) from ex_course_phase where del_flag=0 and courde_id=#{courseId} |
| | | select count(1) from ex_course_phase where del_flag=0 and course_id=#{courseId} |
| | | </select> |
| | | |
| | | <select id="getCoursePeriod" resultType="java.lang.Long"> |