MyBatis的一些快捷操作

1.批量插入

<insert id="plInsert" parameterType="java.util.List">
   insert into student(id,name,age,title,height)
   values
   <foreach collection="list" item="item" index="index" separator=",">
      (
        #{item.id},#{item.name},#{item.age},#{item.title},#{item.height}
      )
   </foreach>
<insert>

2.批量删除

<delete id="delStuById"  parameterType = "java.util.List">
        delete from student where id in
        <foreach collection="list"  item="item" open="(" separator="," close=")"  >
                 #{item.id}
        </foreach>
</delete>

3.批量查询-数组类型

<select id="getByIds" parameterType="java.util.Arrays" resultMap="studentMap">
        SELECT *
        FROM student
        WHERE id in
        <foreach collection="array" close=")" open="(" separator="," index="index" item="item">
             #{item}
        </foreach>
</select>

4.批量查询-集合类型

<select id="getByIds" parameterType="java.util.Arrays" resultMap="studentMap">
        SELECT *
        FROM student
        WHERE id in
        <foreach collection="list" close=")" open="(" separator="," index="index" item="item">
             #{item.id}
        </foreach>
</select>

5.生成自增id

<insert id="insert" parameterType="pojo" useGeneratedKeys="true" keyProperty="id" > 
    insert into student (id, namge, age, 
      height)
    values (#{id,jdbcType=INTEGER}, #{namg,jdbcType=VARCHAR}, # 
     {age,jdbcType=INTEGER},#  {height,jdbcType=INTEGER})
 </insert>