Mybatis使用实例

增

 <insert id="addStudent" parameterType="java.util.Map">
 insert into student
    (id,name,age)
    values
    (
      #{item.id},
      #{item.name},
      #{item.age}
    )
 </insert>

批量

 <insert id="addStudent" parameterType="java.util.Map">
 insert into student
    (id,name,age,start_time)
    values
     <foreach collection="list" item="item" index="index" separator=","> 
    (
      #{item.id},
      #{item.name},
      #{item.age},
      now()
    )
    </foreach>
  </insert>

删

这里写代码片

批量

改

 <update id="updateStudent" parameterType="java.util.Map">
   update stu