Mybaist foreach 嵌套循环实现批量插入

@Insert("<script>"
				+ " insert into ${tb}  "
				+" <foreach collection=\"fields\" item=\"field\"   separator = \",\" open=‘(‘ close=‘)‘> "
				+ "`${field}`"
				+"</foreach>"
				+ "values"
				+" <foreach collection=\"list\" item=‘mvo‘ index=\"list_index\"  separator = \",\" > "
				+" <foreach collection=\"mvo.keys\" item=\"key\" open=‘(‘ close=‘)‘ separator = \",\">"
				+"  #{list[${list_index}].[${key}]} " 
				+"</foreach>  "
				+"</foreach>"
				+ "</script>")
		int insertBatch(@Param("list")List<Map<String,Object>> housingList,@Param("fields") Set<String> keys,@Param("tb") String table) throws Exception;