mybatis批量插入返回自增主键
dao层 (千万不要加注解@Param)
/**
* 添加多个
* @param skills
*/
void insertList(List<Skill> skills);
xml useGeneratedKeys=“true” keyProperty="id"
<!--动态添加-->
<insert id="insertList" parameterType="skill" useGeneratedKeys="true" keyProperty="id">
insert into t_skill (emp_id, skill_name,
proficiency, create_time,
create_user, state)
values
<foreach collection="list" separator="," item="item">
(#{item.empId,jdbcType=INTEGER}, #{item.skillName,jdbcType=VARCHAR},
#{item.proficiency,jdbcType=VARCHAR}, #{item.createTime,jdbcType=TIMESTAMP},
#{item.createUser,jdbcType=VARCHAR}, #{item.state,jdbcType=INTEGER})
</foreach>
</insert>
结束