mybatis+oracle 生成自动增长主键?
在mybaits的实体配置文件中,要怎么配置oracle中的sequence啊
<insert id="addStudent" keyProperty="s_id" useGeneratedKeys="true" parameterType="com.xiaoxiao.entity.StudentEntity">
<selectKey keyProperty="s_id" resultType="int">
select s_seq.nextVal as s_id
</selectKey>
insert into student(s_id,s_name,s_age) values (#{s_id},#{s_name},#{s_age})
</insert>
这样写不行啊
<insert id="addStudent" keyProperty="s_id" useGeneratedKeys="true" parameterType="com.xiaoxiao.entity.StudentEntity">
<selectKey keyProperty="s_id" resultType="int">
select s_seq.nextVal as s_id
</selectKey>
insert into student(s_name,s_age) values (#{s_name},#{s_age})
</insert>
这样写也不行啊