如下是 MyBatis 的映射文件。
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zm.dao.CourseMapper">
<!--
多条件课程列表查询
-->
<select id="findCourseByCondition" parameterType="courseVo" resultType="course">
select * from course
<where>
<if test="courseName != null and courseName != ''">
and course_name like concat('%', #{courseName}, '%')
</if>
<if test="`status` != null and `status` != ''">
and `status` = #{status}
</if>
<if test="true">