腾龙娱乐游戏网址【xs10159.com】
// 首先，你要写一条动态 SQL<select id="searchUsers" resultType="UserVO">SELECT u.*, d.name as deptNameFROM 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 <= #{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 <= #{entryDateEnd} </if></where><if test="sortField != null and sortOrder != null"> ORDER BY ${sortField} ${sortOrder}</if>LIMIT #{offset}, #{size}</select>
页:
[1]