开发者博客:www.developsearch.com
-- Create sequence
create sequence SEQ_CDH_NEWRBT_SET
minvalue 100000
maxvalue 999999999
start with 100000
increment by 1
cache 20;
// jdbc调用sequence
public long getNextSequenceValue(String sequenceName){
return getJdbcTemplate().queryForLong("select " + sequenceName + ".NEXTVAL from dual");
}
开发者博客:www.developsearch.com