-
存在则更新,不存在则insert
<selectKey resultType="Long" keyProperty="xxPo.orderWhId" keyColumn="主键名" order="BEFORE">
select SEQ_索引名.nextval as 主键对应实体类字段名 from dual
</selectKey> oracle通过索引的方式 给表的主键赋值。
IF
(SELECT COUNT(1)
FROM orderWarehouse
WHERE orderId = #{orderId}
) > 0
THEN
UPDATE orderWarehouse
SET
updateDate = #{updateDate},
updateBy = #{updateBy}
WHERE orderId = #{orderId}
ELSE
INSERT
INTO orderWarehouse
(
orderWhId,
orderId
)
VALUES
(
#{orderWhId},
#{orderId}
)
2. mybatis mapping List<String>:
<collection property="propertyName" javaType="java.util.ArrayList" ofType="java.lang.String"> <result column="COLUMNNAME"></result> </collection>