mybatis-xml常用写法

<insert id="batchInsert" parameterType="java.util.List">
  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 id="findByIds" resultMap="xxxResultMap">
    select * from table_name where id in
    <foreach collection="ids" item="id" open="(" close=")" separator=",">
       #{id}
    </foreach>
</select>