一、假设有实体phone:
@Data
public class Phone implements Serializable {
private Integer id;
private String name;
private String type;
private Date time;
private static final long serialVersionUID = 1L;
}
二、Dao接口(PhoneDao)
@Mapper
@Component
public interface PhoneDao {
int insertBatch(List<Phone> phoneList);
}
三、xml文件
<insert id="insertBatch">
insert into phone(name,type ,time) values
<foreach collection="phoneList" item="phone" separator=",">
(#{phone.name},#{phone.type},#{phone.time})
</foreach>
</insert>
四、service层调用
@Service
public class PhoneService {
@Resource
private PhoneDao phoneDao;
public int insertBatch(List<Phone> phoneList){
return phoneDao.insertBatch(phoneList);
}
}