操作：查询列表

主要看DAO层和XML映射

1.controller层

    @PostMapping
    @ApiOperation("用户列表")
    @ApiImplicitParams({@ApiImplicitParam(name = "userName", value = "用户名称", required = false, paramType = "query", dataType = "String")})
    public ResponseResult listUser(QueryUser user) {
        return UserService.listUser(user);
    }

2.Service层

 public ResponseResult listUser(QueryUser user) {
        PageHelper.startPage(user.getPageNum(), user.getPageSize());
        String userName = ParamUtil.like(user.getUserName());
        List<HashMap<String, Object>> list = UserDao.listUser(userName);
        ParamUtil.addr("userAddressId", list, addressDao);
        return new ResponseResult(new PageInfo<HashMap<String, Object>>(list));
    }

3.Dao层

 List<HashMap<String, Object>> listUser(@Param("userName") String userName);

4. xml映射

 <select id="listUser" parameterType="String" resultType="HashMap">
        select
            <include refid="Base_Column_List1"/>
        from User where 1=1 and user_delete_flag = 0
            <if test="@com.ly.user.common.util.StringUtil@isEmptySql(userName)">
            and user_name like #{userName}
        </if>
        order by 
            user_creat_time desc
    </select>