查询用户信息

lxw

2022-07-18 7f1f3aee9459d87ea330fdc86a7f9e44760ae307

查询用户信息

 src/main/resources/mapper/DocUserMapper.xml

@@ -39,19 +39,19 @@
        <where>
            u.name!="sys_admin"
        <if test="name!=null&amp;&amp;name!=''">
            and u.name=${name}
            and u.name like '%${name}%'
        </if>
        <if test="tel!=null&amp;&amp;tel!=''">
            and u.tel=${tel}
            and u.tel  like '%${tel}%'
        </if>
        <if test="phone!=null&amp;&amp;phone!=''">
            u.phone=${phone}
            u.phone like '%${phone}%'
        </if>
        <if test="departId!=null&amp;&amp;departId!=''">
            u.departId=${departId}
            u.departId like '%${departId}%'
        </if>
        <if test="roleId!=null&amp;&amp;roleId!=''">
            u.roleId=${roleId}
            u.roleId like '%${roleId}%'
        </if>
        </where>
        order by id asc