先建立序列 seq_car
create sequence seq_car start with 1 increment by 1;
编写sql语句
<insert id="addcar" parameterType="car">
<!-- 在执行插入操作之前查询到下一个序列值并放入id -->
<selectKey resultType="int" keyProperty="id" order="BEFORE">
select seq_car.nextval id from dual
</selectKey>
insert into CAR (ID, CARID, CARNAME)
values (#{id,jdbcType=INTEGER}, #{carid,jdbcType=INTEGER}, #{carname,jdbcType=VARCHAR})
</insert>