这是创建了一个sequence create sequence S_S_DEPART minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 nocache; SQL> create sequence S_S_DEPART 2 minvalue 1 3 maxvalue 999999999999999999999999999 4 start with 1 5 increment by 1 6 nocache; Sequence created SQL> select S_S_DEPART.nextval from dual; NEXTVAL ---------- 1 SQL> SQL> select S_S_DEPART.nextval from dual; NEXTVAL ---------- 2 以上是测试代码: 在java中的应用如下: /** * 获取项目的序列号 * @author 刘威 * @return 项目序列号str */ public String getProjectSn(){ String snNum = "P20"; Session session = this.getSession(); String sql="select PROJECT_SEQ.nextval from dual"; Query query = session.createSQLQuery(sql); snNum = snNum + query.uniqueResult().toString(); return snNum; } |
|
来自: 走墨 > 《hibernate》