<insert id="intsertAllUserIdsAndMsg" parameterType="java.util.List"> insert into User_Msg( user_id, msg_id, `read`, `type`, crt_time ) values <foreach collection="list" item="item" index= "index" separator =","> ( #{item.userId}, #{item.smsId}, #{item.read}, #{item.type}, NOW() ) </foreach> </insert>
需要注意read和type关键字用`符号,Tab键上面那个,不是单引号