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