MyBatis----通用xml语句

2019-03-20  本文已影响0人  DataSource

xml:

    <insert id="setMatching" statementType="PREPARED" >
            insert  into   ${tablename}
        <foreach collection="params.keys" item="key" open="(" close=")" separator="," >
            ${key}
        </foreach>
        values
        <foreach collection="params.keys"  item="key" open="(" close=")" separator=",">
            #{params[${key}]}
        </foreach>
    </insert>

dao接口:

 void setMatching(@Param(value = "params") Map<String,Object> params,@Param(value = "tablename")String tablename);
上一篇 下一篇

猜你喜欢

热点阅读