腾龙娱乐游戏网址【xs10159.com】

xs10111

// 首先，你要写一条动态 SQL<select id="searchUsers" resultType="UserVO">  SELECT u.*, d.name as deptName  FROM user u LEFT JOIN dept d ON u.dept_id = d.id  <where>    <if test="name != null and name != ''">      AND u.name LIKE CONCAT('%', #{name}, '%')    </if>    <if test="ageMin != null">      AND u.age >= #{ageMin}    </if>    <if test="ageMax != null">      AND u.age &lt;= #{ageMax}    </if>    <if test="dept != null and dept != ''">      AND d.name = #{dept}    </if>    <if test="entryDateStart != null">      AND u.entry_date >= #{entryDateStart}    </if>    <if test="entryDateEnd != null">      AND u.entry_date &lt;= #{entryDateEnd}    </if>  </where>  <if test="sortField != null and sortOrder != null">    ORDER BY ${sortField} ${sortOrder}  </if>  LIMIT #{offset}, #{size}</select>