批量删除:
<delete id="deleteByIds" parameterType="java.lang.Long" >
delete from student where id in
<foreach collection="idList" index="index" item="item"
open="(" separator="," close=")">
#{item}
</foreach>
</delete>
批量插入:
<insert id="insertBatch">
insert into student (name, img, sex, create_time)
values
<foreach collection="studentList" item="student" separator=",">
(
#{student.name,jdbcType=VARCHAR},
#{student.img,jdbcType=VARCHAR},
#{student.sex,jdbcType=INTEGER},
#{student.createTime,jdbcType=TIMESTAMP}
)
</foreach>
</insert>
更新:
<update id="updateStuddent" >
update student
<set>
<if test="student.name != null">
name = #{student.name,jdbcType=VARCHAR},
</if>
<if test="student.img != null">
img = #{student.img,jdbcType=VARCHAR},
</if>
<if test="student.sex != null">
sex = #{student.sex,jdbcType=INTEGER},
</if>
<if test="student.createTime != null">
create_time = #{student.createTime,jdbcType=TIMESTAMP},
</if>
</set>
where id = #{student.id,jdbcType=BIGINT}
</update>