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);
网友评论