Mybatis批量插入
话不多说,直接上代码
mapper.java
vioid insertZoneAndRuleRela (@Param("ruleId") Long ruleId,@Param("zoneIdList")List<IssueZoneIdReqDto> zoneIdList);
mapper.xml
<insert id ="insertZoneAndRuleRela ">
insert into t_dispatche_rule_rela( rule_id,zone_id,is_del,gmt_create)
values
<trim prefix="(" suffix=")" >
<foreach collection="zoneIdList" item="zoneId" index ="index" open="(" close=")" separator="),(">
#{ruleId},#{zoneId},0,currenttimestamp
</foreach>
</trim >
</insert>
Mybatis批量修改
类似
Mybatis批量查询
mapper.java
vioid getZoneNameList (@Param("zoneId")List<IssueZoneIdReqDto> zoneIdList);
mapper.xml
<select id ="getZoneNameList ">
select zone_name from t_dispatche_rule where id in
<trim prefix="(" suffix=")" >
<foreach collection="zoneIdList" item="id" index ="index" open="(" close=")" separator="),(">
#{id}
</foreach>
<trim prefix="(" suffix=")" >
</select>