package fr.nytsa.NBC;

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

public class SqlConnection {

	private Connection connection;

	private String urlbase, host, database, user, pass;

	public SqlConnection(String urlbase, String host, String database, String user, String pass) {
		this.urlbase = urlbase;
		this.host = host;
		this.database = database;
		this.user = user;
		this.pass = pass;
	}

    public void connection() {
        if(!isConnected()){
            try {
                try {
                    Class.forName("com.mysql.jdbc.Driver");
                    System.out.println("Driver ok");
                } catch (ClassNotFoundException e) {
                    e.printStackTrace();
                }
                connection = DriverManager.getConnection(urlbase + host + "/" + database, user, pass);
                System.out.println("Connected ok");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

	public void disconnect() {
		if(isConnected()){
			try {
				connection.close();
				System.out.println("Connected off");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public boolean isConnected(){
		return connection != null;
	}

}