nextvalue.java

struts+spring+jdbc权限管理 菜单树实现

package com.hiiso.crm.common.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

/*************************************************************************
* SYSTEM:       基金CRM系统
* SUBSYS:       CRM权限管理模块
* DESCRIPTION:  CRM获取SEQUENSE
* AUTHOR:       yaoyi
* CREATE DATE:  2008/10/30
* COPYRIGHT:    (c)Copyright 2008 hisun Corporation. All rights reserved.
* VERSION:      V1.0G
* EDIT HISTORY:
*************************************************************************/

public class NextValue {
	
	private String seq = "";
	
	public String getNextValue(String previous,String seqName,Connection conn){
		String sql = "select "+seqName+".NEXTVAL from dual";
		JdbcTemplate tmp = new JdbcTemplate(conn);
		tmp.find(sql, new JdbcCallback(){
				public void doExecute(ResultSet rs) throws SQLException {
					if(rs.next()){
						seq = rs.getString(1);
					}
				}
		   	}
		);
		return seq;
	}

}