/**
* @Title: getSequence
* @Description: 传入序列名称,获取下一个值
*/
public static String getSequence(String name) {
String retstr = "";
String sql = "select " + name + ".nextval as nextval from dual";
Map<String, Object> map = (Map<String, Object>)JQuery.query(sql, new MapHandler());
if(map!=null&&!map.isEmpty()){
if(map.get("nextval")!=null&&map.get("nextval")!=""){
retstr = map.get("nextval").toString();
}
}
return retstr;
}
/**
* @Title: getSysGuid
* @Description: 获取下一个uuid
*/
public static String getSysGuid() {
String retstr = "";
String sql = "select rawtohex(sys_guid()) as sysguid from dual";
Map<String, Object> map = (Map<String, Object>)JQuery.query(sql, new MapHandler());
if(map!=null&&!map.isEmpty()){
if(map.get("sysguid")!=null&&map.get("sysguid")!=""){
retstr = map.get("sysguid").toString();
}
}
return retstr;
}
获取Oracle产生的Sequence和Uuid方法
最新推荐文章于 2023-05-23 15:25:33 发布