mybatis入参为map集合时操作
mybatis入参为map类型时,例如
{
“campaignId”: 12183,
“name”: “测试”,
“page”: 1,
“pageSize”: 20,
“sortIds”: “”
}
此时等价于:
@RequestParam(value = “campaignId”) int campaignId,
@RequestParam(value = “name”) String name,
@RequestParam(value = “page”) Integer type,
@RequestParam(value = “pageSize”) Integer trafficSource,
@RequestParam(value = “sortIds”) Integer sortIds
在mapper.xml文件中相应的判断条件直接就按照map中的key进行填写。
如下:
FIND_IN_SET( o.id,#{sortIds,jdbcType=VARCHAR}) AS sortNumiii,