package model;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashSet;
import java.util.Set;

public class DriverManagerConnection implements BuildConnection {
	
	private static Set<String> set = new HashSet<String>();
	
	private String driver;
	
	private String url;
	
	private String userId;
	
	private String password;

	public DriverManagerConnection(String driver, String url, String userId, String password) throws ClassNotFoundException {
		this.driver = driver;
		this.url = url;
		this.userId = userId;
		this.password = password;
		loadDriver();
	}

	private void loadDriver() throws ClassNotFoundException {
		if (!set.contains(driver)) {
			Class.forName(driver); 
			set.add(driver);	   
		}
	}

	public Connection getConnection() throws SQLException {
		return DriverManager.getConnection(url, userId, password);
	}

}