Shulou(Shulou.com)06/01 Report--

Create a sequence statement in oracle and execute:

Createsequence user_seq start with 1 increment by 1

Create a trigger statement in oracle and execute: create or replace trigger user_triggerbefore insert on tb_userfor each rowbegin select user_seq.nextval into: new.id from dual; end

two。 Then you don't have to specify id when you insert a record into the mapper configuration file of mybatis

INSERT INTO TB_USER (name,sex,age) VALUES (# {name}, # {sex}, ${age})

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.