mybatis 接收map参数的处理方法（注解开发）

本文主要讲解通过mybatis注解开发 处理map数据

第一种

传参的实体类

package com.carbon.common;

import io.swagger.annotations.ApiModel;
import lombok.Data;

import java.util.HashMap;
@Data
@ApiModel
public class QueryParam {
    public static final int PAGE_SIZE=10;
    public static final int PAGE_NUM=1;
    private int pageSize = PAGE_SIZE;
    private int pageNum = PAGE_NUM;
    private HashMap param = new HashMap<>();
}

返回值：

package com.carbon.pojo;

import lombok.Data;

@Data
public class Sale {
    private String orderNum;
    private String delGood;
    private String receipt;
    private String contactMan;
    private String contactType;
    private String sigDate;
    private String note;
}

mapper层：

    @Select("select * from sale where delgood =#{param.delgood} ")
    List<Sale> sel(QueryParam queryParam);

Test测试：

@SpringBootTest
public class SpringCarbon5Test {

    @Autowired
    SaleContMapper saleContMapper;

    @Test
    public void testMysql() throws SQLException {

        QueryParam queryParam = new QueryParam();
        HashMap map = new HashMap<>();
        map.put("delgood","快递");
        queryParam.setParam(map);
        System.out.println(queryParam.getParam().get("delgood"));
        System.out.println(saleContMapper.sel(queryParam));

    }
}

测试结果：

第二种：

测试方法同上 不变 只需要改写mapper层即可