java 数据库序列_Java获取Oracle数据库序列值

import javax.sql.DataSource;

import org.springframework.jdbc.support.incrementer.OracleSequenceMaxValueIncrementer;

import com.sinotrans.framework.core.util.ContextUtils;

public class OracleSequence {

private static DataSource ds = null;

//静态初始化一个数据源

static {

if (ds == null)

ds = (DataSource) ContextUtils.getBean("dataSource");

}

//定义静态方法

public static String getNextVal(String seqName) {

OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(ds, seqName);

return incr.nextStringValue();

}

//定义静态方法

public static Long getNextValLong(String seqName) {

OracleSequenceMaxValueIncrementer incr = new OracleSequenceMaxValueIncrementer(ds, seqName);

return incr.nextLongValue();

}

}