mybatis传入数组怎么写_Mybatis传入参数字符串分割成数组作为条件遍历

1. 先获取LayUI复选框的值并以逗号拼接在一起

form.on('submit(storeOrdersQuerySubmit)', function (data) {

var datas = data.field;

var groupCheckbox = $("input[name='payMethods']");

var payMethods = "";

for (var i = 0; i < groupCheckbox.length; i++) {

if (groupCheckbox[i].checked) {

var val = groupCheckbox[i].value;

if (payMethods.length > 0) {

payMethods += "," + val;

} else {

payMethods += val;

}

}

}

tableIns.reload({

where: {

'payMethods': payMethods

}

});

return false;

});

选择结果

得到的字符串就是2,5

2. Mybatis将传入参数字符串分割成数组作为条件遍历

SELECT

ORDERS.ORDER_ID

FROM

ORDERS

where ORDERS.MER_ID = #{merId,jdbcType=VARCHAR}

AND ORDERS.PAY_METHOD IN

index="index" open="(" close=")" separator=",">

#{payMethod}

order by ORDERS.CREATE_DATE