1. Set the ID as a self-increment sequence
CREATE OR REPLACE TRIGGER "Datalib". " Trig_user_add "
Before INSERT on ' Sys_user ' for each row
Begin
Select Seq_user.nextval into:new. " USER_ID "from dual;
End
ALTER TRIGGER "Datalib". " Trig_user_add "ENABLE;
XML configuration file about the database in 2.mybatis
<insert id= "Save" parametertype= "Io.renren.entity.SysUserEntity" keyproperty= "userId" databaseid= "Oracle" >
<selectkey keyproperty= "UserId" resulttype= "Long" order= "before" >
Select Seq_user. Nextval from dual
</selectKey>
INSERT INTO "Sys_user"
(
"Username",
"Password",
"Email",
"Mobile",
"Status",
"Create_time"
)
Values
(
#{username, Jdbctype=varchar},
#{password, Jdbctype=varchar},
#{email, Jdbctype=varchar},
#{mobile, Jdbctype=varchar},
#{status, Jdbctype=numeric},
#{createtime, Jdbctype=date}
)
</insert>
3. Test code
Sysuserentity user=new sysuserentity ();
User.setusername (username);
User.setpassword (passwd);
User.setemail (email);
User.setmobile (mobile);
User.setstatus (status);
System.out.println (User.getuserid () + "888888888888888888888888");
Sysuserservice.save (user);
System.out.println (User.getuserid () + "=========================");
MyBatis returns the self-increment ID after inserting data into the Oracle database