mybatis-xml常用写法

<insert >
  insert into table_name (name,age,high,status,create_time,update_time)
  values
     <foreach collection="list" item="e" index="index" separator=",">
       (
        #{e.name},
        #{e.age},
        #{e.high},
        #{e.status},       
        #{e.createTime},
        #{e.updateTime}
       )
    </foreach>
</insert>

<if test="name != null and name != ''">
     AND name LIKE CONCAT('%',#{name},'%')
</if>

<if test="port != null">
   AND port = #{port}
</if>

<select >
    select * from table_name where id in
    <foreach collection="ids" item="id" open="(" close=")" separator=",">
       #{id}
    </foreach>
</select>

<insert >
     insert into table_name(a,b,c,d)
     values(#{a},#{b},#{c},#{d},)
</insert>