Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

How MyBatis gets the auto-generated primary key id


May 16, 2021 MyBatis



MySQL: Mapper file insert statement settings

useGeneratedKeys="true" keyProperty="id"

Oracle: Mapper file insert statement increased

  1. <selectKey keyProperty="id" order="BEFORE" resultType="Integer">
  2.     select xxx_SEQ.nextval from dual
  3. </selectKey>