参数是list,一个插入语句,如何写才是正确的,编译工具是vs
<insert id="InsertForeach" parameterClass="list" >
INSERT INTO t_sub_monitor(
"uid",
"mainid",
"type",
"value",
"normalflag",
"pointsetnum",
"devicenum",
"enterdate"
)
VALUES
<foreach collection="smList" item="item" separator=",">
(#{item.Uid},
#{item.MainId},
#{item.Type},
#{item.Value},
#{item.NormalFlag},
#{item.PointsetNum},
#{item.DeviceNum},
#{item.EnterDate})
</foreach>
</insert>
```第一次用vs,只能知道是sql出错了,求大佬指教是哪里出错了,是<>里的配置问题还是sql有问题