67,549
社区成员




DELETE FROM VOTE
WHERE VOTE_ID IN
<foreach item="item" index="index" collection="array"
open="(" separator="," close=")">
#{item}
</foreach>
<insert id="addAccessRoute" parameterClass="AccessRouteInfo">
<![CDATA[
INSERT INTO T_OSS_LOCATIONIDROUTE
(ID,
ACCESS_NODE,
BEGIN_NUM,
END_NUM,
LOCATION_ID)
VALUES
(SYS_GUID(),
#accessNode#,
#beginNum#,
#lastNum#,
#locationId#)
]]>
</insert>
这个是oracle的,你可以试一试,其中#号中的是变量,对应着parameterClass="AccessRouteInfo"中AccessRouteInfo类的属性