package com.llgc.dao;

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

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource;

public class DAOConnection {
  private volatile static DAOConnection instance = null;
  private BasicDataSource bds = null;
  private Connection cn = null;

  private DAOConnection() throws SQLException {
    super();

    bds = new BasicDataSource();
    bds.setDriverClassName("com.mysql.jdbc.Driver");
    String url;
    url = "jdbc:mysql://localhost/voiture";
    bds.setUrl(url);
    bds.setUsername("root");
    bds.setPassword("aui");
    cn = bds.getConnection();
  }

  public static DAOConnection getInstance() throws SQLException {
    DAOConnection result = instance;
    if (result == null) {
      synchronized (DAOConnection.class) {
        result = instance;
        if (result == null) {
          instance = result = new DAOConnection();
        }
      }
    }
    return result;
  }

  public Connection getConnexion() throws ClassNotFoundException, SQLException {
    return cn;
  }

  @Override
  protected void finalize() throws Throwable {
    cn.close();
    super.finalize();
  }
}