User.xml中怎样实现多条件动态查询

UserMapper.java

//分页查询，返回User对象
List<User> selectPage(Integer pageNum, Integer pageSize, String username, String email, String address);
//分页查询求总数
Integer selectTotal(String username, String email, String address);

User.xml

<select id="selectPage" resultType="com.chunyu.demo.entity.User">
    SELECT * FROM sys_user
    <where>
        <if test="username != ''">
            username LIKE CONCAT('%',#{username},'%')
        </if>
        <if test="email != ''">
            AND email LIKE CONCAT('%',#{email},'%')
        </if>
        <if test="address != ''">
            AND address LIKE CONCAT('%',#{address},'%')
        </if>
    </where>
    LIMIT #{pageNum}, #{pageSize}
</select>

注：

1. id和resultType应与前面Mapper.java中的方法名一致
2. 用if进行条件多少的筛选
3. 用‘'表示null，而不用null
4. AND要在if里面，且第一个if里面不能有AND