创建自动增长ID以及查询当前ID和下一个ID
DROP SEQUENCE PLAN.PLAN_MAINTAIN_LOG_S;CREATE SEQUENCE PLAN.PLAN_MAINTAIN_LOG_S START WITH 1 MAXVALUE 999999999 MINVALUE 1 NOCYCLE NOCACHE NOORDER;<insert id="save" parameterMap="deptMap"> <![CDATA[ INSERT INTO TIME_DEPT(id,deptName,deptAddress,deptCenter,deptManager,remark,state) VALUES(TIME_DEPT_LOG_S.nextval,?,?,?,?,?,?) ]]> <selectKey resultClass="int"> <![CDATA[ SELECT TIME_DEPT_LOG_S.currval as id FROM dual ]]> </selectKey> </insert>
