getseqsnumber.java.svn-base

一个timesheet程序,用来统计开发人员的度量衡web在线程序.用于软件行业

package com.nsi.util;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Map;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.nsi.persistence.DataSrcUtil;
import com.nsi.persistence.IsqlDataSource;

public final class GetSeqsNumber
{
	private static Log log = LogFactory.getLog(GetSeqsNumber.class);
	/**
	 * private constructor of GetSeqsNumber, prevent instantiation
	 */
	private GetSeqsNumber()
	{
	}
	private static class GetSeqsNumberHolder
	{
		static final GetSeqsNumber seqsNumberUtil = new GetSeqsNumber();
	}
	/**
	 * @return an instance of GetSeqsNumber
	 */
	public static GetSeqsNumber getInstance()
	{
		return GetSeqsNumberHolder.seqsNumberUtil;
	}
	public String getSeqsNumber( String seqsName ) throws Exception
	{
		String seqsNumber = "" ;		
		String sql = "select nextval ('" + seqsName + "') as seqnum";
		try
		{
			IsqlDataSource src = DataSrcUtil.getInstance().getDataSource();
			Connection conn = src.getConnection();
			Map<String,String> result = src.retrieveSingleRow(conn, sql);
			src.closeConn(conn);
			seqsNumber = result.get("seqnum" );
		}
		catch( SQLException se )
		{
			log.error( "getSeqsNumber for " + seqsName  + " caught SQLException: " + se );
			throw new Exception( "getSeqsNumber for " + seqsName  + " caught SQLException: " + se );
		}
		catch( Exception ex )
		{
			log.error( "getSeqsNumber for " + seqsName  + " caught Exception: " + ex );
			throw ex;
		}
		return seqsNumber ;
	}
}