MyBatis loop to get key and value in a map

Sometimes it is necessary to simply get all the keys and value from a map and spell it in the SQL statement. MyBatis provides a way to traverse the entryset in the map and then throw the key into the index, and the value is thrown into the item. An example of a specific use is as follows:

	<insert id= "OperationName" parametertype= "map" >
		INSERT INTO table_name (Hot_word, CNT)
		VALUES
		< foreach item= "value" index= "key" collection= "Mapdata.entryset ()" Open= "(" separator= "), (" close= ")" >
			#{key}, # {Value}
		</foreach> on
		DUPLICATE KEY UPDATE
		cnt=values (CNT)
	</insert>