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>
浙公网安备 33010602011771号