xml配置文件里的sql语句:
<insert id="insertData" parameterType="java.util.Map">
insert into ${dataMap.table_name}
<foreach collection="dataMap.keys" separator="," item="key" open="(" close=")">
${key}
</foreach>
values
<foreach collection="dataMap.keys" item="key" separator="," open="(" close=")">
#{dataMap[${key}]}
</foreach>
</insert>
相应的map接口:
@Mapper
@Repository
public interface DataMapper {
/**
* 插入数据到mysql相应的表中
* @param dataMap
*/
void insertData(@Param("dataMap") Map<String, String> dataMap);
}