以前用的是MySQL,现在公司用orcale,差别在于orcale表id 不是主键自增的,而是用序列,网上搜到的几种xml写法都用不了,后来copy朋友写的xml改了下就能使用了,现分享如下,希望能帮助到大家
<insert id="insertRoleFunction" parameterType="java.util.List"> insert into CAF_ROLEFUNCTION ( ID, FUNCTION_ID, ROLE_ID) select SEQ_CAF_ROLE_FUNCTION.Nextval, A.* FROM ( <foreach collection="list" item="item" index="index" separator="UNION ALL"> <![CDATA[ SELECT #{item.functionId,jdbcType=DECIMAL}, #{item.roleId,jdbcType=DECIMAL} FROM dual ]]> </foreach> ) A </insert>
记得要加上 <![CDATA[]]>
传入的是list,list中有多个RoleFunctionEo对象
Mapper.java代码如下
void insertRoleFunction(List<RoleFunctionEo> list);
RoleFunctionEo代码如下
import java.io.Serializable; import java.math.BigDecimal; public class RoleFunctionEo implements Serializable{ private static final long serialVersionUID = -3200452780614325739L; private BigDecimal functionId; private BigDecimal roleId; public BigDecimal getFunctionId() { return functionId; } public void setFunctionId(BigDecimal functionId) { this.functionId = functionId; } public BigDecimal getRoleId() { return roleId; } public void setRoleId(BigDecimal roleId) { this.roleId = roleId; } }
亲测xml代码可用,欢迎反馈!如需转载请标注原文地址