一个基本的触发器

一个基本触发器：TRG_PERSON_INFO

create or replace trigger TRG_PERSON_INFO
  before  insert on   SRITLMD_PERSONINFO
  for each row
declare
  -- local variables here
begin
  select SEQU_PERSON_INFO.nextval into :new.ID from dual;
end TRG_PERSON_INFO;

其中SEQU_PERSON_INFO为Sequences。

在类中处理：

public String getPersonNumber() {
      int next = jdbcTemplate.queryForInt("select SEQU_PERSON_NUM.nextval as id from dual");
      return "P" + next;
}