mybatis在oracle数据库中获取主键

原理

1. 用employ_seq.nextval,自动获得下一次的id值并插入
2. 然后用内置select语句，加employ_seq.currval获取当前id值放入对象中。

 <insert id="insertEmp" databaseId="oracle>
        <selectKey keyProperty="id" resultType="int" databaseId="oracle" order="AFTER">
        select  employee_seq.currval from dual
        </selectKey>
        insert into employee (id,last_Name,email,gender)Values(employee_seq.nextval,#{lastName},#{email},#{gender})
    </insert>

1. 在插入之前先利用employee_seq.nextval获取下一次的id值，放入对象中
2. 然后将对象直接插入数据库中

  <insert id="insertEmp" databaseId="oracle>
        <selectKey keyProperty="id" resultType="int" " order="BEFORE">
        select  employee_seq.nextval from dual
        </selectKey>
        insert into employee (id,last_Name,email,gender)Values(id,#{lastName},#{email},#{gender})
    </insert>