首先在orcale创建序列,序列名称为PK_HS_ACCESS_TIME(这是随便命名的)
CREATE SEQUENCE PK_HS_ACCESS_TIME
INCREMENT BY 1 -- 每次加1个START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 100;
在ibatis调用方法为
<selectKey keyProperty="mainTainId" resultClass="long">
select PK_HS_BASIC_SITE_SIGNTIME.NEXTVAL as maintain_id from dual
</selectKey>
--mainTainId为实体类id,maintain_id 为数据库id,PK_HS_BASIC_SITE_SIGNTIME.NEXTVAL调用序列并且自增长,dual为数据库默认表不用改变
事例:
<insert id="doCreateDateMainTain" parameterClass="DateMainTainVO">
<selectKey keyProperty="mainTainId" resultClass="long">
select PK_HS_BASIC_SITE_SIGNTIME.NEXTVAL as maintain_id from dual
</selectKey>
INSERT INTO HS_FeeReform_Time (
maintain_id ,
maintain_date ,
rate_week_day,
whether_calculate,
created_by ,
created_time
) VALUES (
#mainTainId# ,
#mainTainDate#,
#week# ,
#whether# ,
#addPerson# ,
#addDate#
)
</insert>