<insert id=" insert " useGeneratedKeys="true" keyProperty="s_id" parameterType="xxxx" > 
<selectKey resultType="int" order="BEFORE" keyProperty="s_id"> 
SELECT SEQ_TABLE.NEXTVAL FROM dual 
</selectKey> 
INSERT INTO <span style="font-family: Arial, Helvetica, sans-serif;">s_id</span><span style="font-family: Arial, Helvetica, sans-serif;">,name,age</span> 
VALUES 
(#{s_id} #{name}, #{age} ) 
</insert> 

useGeneratedKeys="true" keyProperty="s_id"

insert into s_user_auth (id,user_id, user_name) values(#{id},#{userid},#{username})

select yoursequence.nextval as id from dual
insert into s_user_auth (id,user_id, user_name) values(#{id},#{userid},#{username})

insert into s_user_auth (id,user_id, user_name) values(yoursequence.nextval,#{userid},#{username})