- 添加单个实体回填主键
<insert id="save" parameterType="java.util.List" useGeneratedKeys="true" keyProperty="id">
insert into t_user_study_plan (user_id, menu_code, menu_id, status, do_day, create_time,recommend_es_id)
VALUES
(
#{userStudyPlan.userId},
#{userStudyPlan.menuCode},
#{userStudyPlan.menuId},
#{userStudyPlan.status},
#{userStudyPlan.doDay},
#{userStudyPlan.createTime},
#{userStudyPlan.recommendEsId}
)
</insert>
- 批量添加
<insert id="saveBatch" parameterType="java.util.List">
insert into t_user_study_plan (user_id, menu_code, menu_id, status, do_day, create_time,recommend_es_id)
VALUES
<foreach collection="userStudyPlanList" item="userStudyPlan" separator=",">
(
#{userStudyPlan.userId},
#{userStudyPlan.menuCode},
#{userStudyPlan.menuId},
#{userStudyPlan.status},
#{userStudyPlan.doDay},
#{userStudyPlan.createTime},
#{userStudyPlan.recommendEsId}
)
</foreach>
</insert>