我们项目组正好用到了这个,SEQ_ZONE为sequence,则mybatis配置文件如下:
SELECT SEQ_ZONE.CURRVAL AS id from dual insert into TBL_ZONE (ID, NAME ) values (SEQ_ZONE.NEXTVAL, #{name,jdbcType=VARCHAR} )