mybatis使用Map传多个参数的使用

public List<DYRKBUser> getUserPaging(DYRKBUser user, int page, int pageSize){
        int from = (page-1) * pageSize;
        Map<String,Object> queryMap = new HashMap();
        queryMap.put("userName","%"+user.getUserName()+"%");
        queryMap.put("privilege",user.getPrivilege());
        queryMap.put("from",from);
        queryMap.put("pageSize",pageSize);
//        user.setUserName("%"+user.getUserName()+"%");//mybatis的模糊查询
        return userMapper.selectUserPaging(queryMap);
    }

 

List<DYRKBUser> selectUserPaging(@Param("hashMapQuery") Map<String,Object> hashmap);

<select id="selectUserPaging" resultMap="BaseResultMap" parameterType="map">
        select
        <include refid="Base_Column_List"/>
        from DYRKB_USER
        where ACCOUNT_STATE != 8
        <if test=" hashMapQuery.privilege != null" >
            and PRIVILEGE = #{ hashMapQuery.privilege}
        </if>
        <if test=" hashMapQuery.userName != null">
            and USER_NAME like #{ hashMapQuery.userName}
        </if>
        limit #{ hashMapQuery.pageSize} offset #{ hashMapQuery.from}
  </select>