1.每条数据都是一个POJO简单类,把POJO列表嵌入到一个类DTO里面传入到Mybatis
DTO类的例子,嵌入一个POJO的类的List
public class TargetDTO implements Serializable {
private static final long serialVersionUID = -************;
private List<Target> targetList;
public List<Target> getTargetList() {
return targetList;
}
public void setTargetList(List<Target> targetList) {
this.targetList = targetList;
}
}
MyBatis的Sql配置文件
<insert id="insertTarget" parameterType="com.finway.boss.admin.basicfunction.dto.TargetDTO" >
insert into boss_target_setup
(agency_id,
belong_year,
cycle_type,
cycle_value,
start_date,
end_date
)
VALUES
<foreach collection="targetList" item="item" index="index" separator=",">
(#{item.agency_id},
#{item.belong_year},
#{item.cycle_type},
#{item.cycle_value},
#{item.start_date},
#{item.end_date}
)
</foreach>
</insert>