美文网首页
MyBatis----通用xml语句

MyBatis----通用xml语句

作者: DataSource | 来源:发表于2019-03-20 15:51 被阅读0次

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);

相关文章

网友评论

      本文标题:MyBatis----通用xml语句

      本文链接:https://www.haomeiwen.com/subject/koaamqtx.html