mybatis封装多个参数的方法总结

1 单个参数

<select id="get" parameterType="long" resultType="string"> 

select name from test

where id=#{id}

 </select>

2 多个参数之map

<select id="get" parameterType="java.util.Map" resultType="string"> 

select name from test

where id=#{id} and flag=#{flag}

 </select>

3 多个参数之bean

<select id="get" parameterType="Test" resultType="string"> 

select name from test

where id=#{id} and flag=#{flag}

 </select>

4 多个参数之list

<select id="get" parameterType="long" resultType="string">  

        select name from testwhere Id in  

        <foreach collection="list"   

            open="(" close=")" separator="," item="item" index="index">  

            #{item.id}  

        </foreach>  

  </select>  

批量插入

<insert id="add" useGeneratedKeys="true" parameterType="java.util.List">

<selectKey resultType="long" keyProperty="id" order="AFTER">

SELECT

LAST_INSERT_ID()

</selectKey>

insert into test (name,time,flag)

values

<foreach collection="list" item="item" index="index" separator="," >

(#{item.name},#{item.time},#{item.flag})

</foreach>

</insert>

5 多个参数之数组

<select id="get" parameterType="long" resultType="string">  

        select name from testwhere Id in  

        <foreach collection="array"   

            open="(" close=")" separator="," item="item" index="index">  

            #{item.id}  

        </foreach>  

  </select>