<insert id="insertSelective"parameterType="com.chalco.zlzn.AluminumLiquidProduce"> <!--@mbg.generated--> <selectKey keyProperty="id" resultType="Long"order="BEFORE"> select Z_PLAN_ALUMINUM_LIQUID_PRODUCE_SEQ.nextval as id from dual </selectKey> insert into Z_PLAN_ALUMINUM_LIQUID_PRODUCE <trim prefix="(" suffix=")" suffixOverrides=","> ID </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> #{id,jdbcType=DECIMAL} </trim> </insert>
这id名称需一致,包括实体类id名称
resultType="Long"需和实体类id类型对应
orcale数据库id自增需要创建序列和触发器,如果想要返回当前插入id,则需要删除触发器,不然会触发两次序列,用上面SQL查出来的ID,作为这次插入SQL的id
返回的主键id,直接get实体类就能取出