mybatis 传入id_Mybatis 传入List参数

//dao 代码 如果传入的参数是数组，也一样

void insertDefaultMsg(@Param("idsList") ArrayList idsList);

//xml文件

UPDATE

plf_pur_delivery_plan p

SET

p.promise_delivery_amount = p.quantity_req,

p.promise_delivery_time = p.quantity_time

WHERE p.id IN

#{item, jdbcType=VARCHAR}

//如果传入字符串

//service 代码

Map map = bean.getDatas().get(0);

String ids = map.get("ids");

String[] idsArr = ids.split(",");

String inId = "";

for (int i = 0; i < idsArr.length; i++) {

if (i != idsArr.length - 1) {

inId += "'" + idsArr[i] + "',";

} else {

inId += "'" + idsArr[i] + "'";

}

}

List> list = purDeliveryPlanDao

.getPlanListManual(inId);

//dao层代码

List> getPlanListManual(@Param("inId") String inId);

//xml 文件

SELECT

p.supplier_code,

p.pur_order_no,

IF(

p.update_times > 0,

'修改订单',

'新订单'

) AS order_type

FROM

plf_pur_delivery_plan p

WHERE p.is_notice = '0'

AND p.is_delete = '1'

AND p.id in()

GROUP BY p.supplier_code,

p.pur_order_no

ORDER BY p.supplier_code

分享到：

2016-04-13 13:51

浏览 24044

分类:数据库

评论