package org.medias.eccad.persistance.jdbc;

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


import org.medias.eccad.helpers.LoggerPerso;
import org.medias.eccad.persistance.exception.PersistanceException;

public class GeneriqueDAOjdbc {
	private SGBD_jdbc sgbd;

	protected GeneriqueDAOjdbc(SGBD_jdbc sgbd) {
		this.sgbd = sgbd;
	}

	protected GeneriqueDAOjdbc() {
		this.sgbd = null;
	}
	
	public SGBD_jdbc getSgbd() {
		return sgbd;
	}

	public void setSgbd(SGBD_jdbc sgbd) {
		this.sgbd = sgbd;
	}
	
	/**
	 * Permet d'obtenir une connexion à la base de donnée
	 * @return la connexion à la base :)
	 * @throws PersistanceException 
	 */
	protected Connection getConnection() throws PersistanceException {
		Connection conn;
		try { 
			conn = sgbd.connexion(); 
			} 
		catch (SQLException sqle) {
			throw new PersistanceException(sqle, "impossible de se connecter au sgbd :: ParametreDAOjdbc.getListParametre");
		}
		LoggerPerso.log(GeneriqueDAOjdbc.class, LoggerPerso.DEBUG, "-- jdbc connexion -- ");
		return conn;
	}
	
	protected void closeConnection() {
		LoggerPerso.log(GeneriqueDAOjdbc.class, LoggerPerso.DEBUG, "-- jdbc deconnexion -- ");
		sgbd.deconnexion();
	}
}