src/main/resources/mapper/UserMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/resources/mapper/UserMapper.xml
@@ -346,8 +346,8 @@ <if test="userName != null and userName != ''"> AND real_name LIKE concat('%',#{userName},'%') </if> <if test="role != null and role.size() > 0"> AND role IN <foreach collection="role" item="item" open="(" separator="," close=")"> #{item} </foreach> <if test="roles != null and roles.size() > 0"> AND role IN <foreach collection="roles" item="item" open="(" separator="," close=")"> #{item} </foreach> </if> GROUP BY a.id </select>