在insert语句中,select max(id)+1 from 表
spring mvc的mapperiong中使用sql插入语句,插入时以自增的顺序,sysdate是获取的系统时间
例:
INSERT INTO OA_PM_PERSON_INPUT (input_id,project_id ,user_id,input_ym,LAST_MODIFY,CREATE_TIME)
VALUES
( (SELECT TO_CHAR(max(input_id) + 1) FROM OA_PM_PERSON_INPUT),
#{project_name},
#{user_name},
SYSDATE,
SYSDATE,
SYSDATE)