Metacat

/**

 *  '$RCSfile$'

 *    Purpose: A Class that manages database access

 *             information.

 *  Copyright: 2009 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Michael Daigle

 *

 *   '$Author: daigle $'

 *     '$Date: 2009-03-23 13:56:56 -0800 (Mon, 23 Mar 2009) $'

 * '$Revision: 4854 $'

 *

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

 */

package edu.ucsb.nceas.shared;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import edu.ucsb.nceas.metacat.DBConnection;

import edu.ucsb.nceas.metacat.DBConnectionPool;

public class BaseAccess {

	protected DBConnection conn = null;

    protected int serialNumber = -1;

    protected PreparedStatement pstmt = null;

    protected ResultSet rs = null;

    protected BaseAccess(String methodName) throws AccessException {

        //check out DBConnection

    	try {

    		conn = DBConnectionPool.

                	getDBConnection("methodName");

    		serialNumber = conn.getCheckOutSerialNumber();

    	} catch (SQLException sqle) {

    		throw new AccessException("Could not get connection from DB connection pool: "

    				+ sqle.getMessage());

    	}

    }

    protected ResultSet select(PreparedStatement pstmt) throws AccessException {

    	try {

    		pstmt.execute();

        	rs = pstmt.getResultSet();

    	} catch (SQLException sqle) {

    		throw new AccessException("Could not perform select: " + pstmt.toString()

    				+ sqle.getMessage());

    	}

    	return rs;

    }

}