<insert id="batchInsertRoleResource"> insert all <foreach collection="list" index="index" item="roleRes" separator="" > into PLATFORM_SYS_ROLE_RESOURCE (ROLE_CODE,RES_CODE,CREATE_USER,CREATE_TIME,MODIFY_USER,MODIFY_TIME) values ( #{roleRes.roleCode,jdbcType=VARCHAR}, #{roleRes.resCode,jdbcType=VARCHAR}, #{roleRes.createUser,jdbcType=VARCHAR}, #{roleRes.createTime,jdbcType=TIMESTAMP}, #{roleRes.modifyUser,jdbcType=VARCHAR}, #{roleRes.modifyTime,jdbcType=TIMESTAMP} ) </foreach> SELECT 1 FROM DUAL </insert>
oracle批量插入语句
最新推荐文章于 2023-05-30 16:55:59 发布