mybatis批量新增

mybatis批量新增:

public interface InfoMapper {

int insertServiceInfo(@Param("records") List<ServiceInfo> records);
}

InfoMapper.xml
  <insert id="insertServiceInfo" keyColumn="id" keyProperty="id" parameterType="com.xxx.pojo.ServiceInfo"
useGeneratedKeys="true">
insert into e_service_info (`name`, `ip`, last_connection_time)
values
<foreach collection="records" item="param" separator=",">
(#{param.name}, #{param.ip}, #{param.lastConnectionTime})
</foreach>
</insert>

posted on 2020-09-18 15:09  彡木虫  阅读(150)  评论(0)    收藏  举报

导航