package task.dto;

import org.apache.commons.dbcp2.BasicDataSource;

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

public class ConnectionDB {
    private final String url = "jdbc:mysql://localhost:3306/UsersDB" +
            "?verifyServerCertificate=false&useSSL=true&serverTimezone=UTC"; //URL for DB
    private final String userDB = "root"; //Name for DB
    private final String pasDB = "qWaszx@1"; //Pas for DB
    private BasicDataSource dataSource;

    //----------------------------CONNSTRUCTOR-----------------------------------
    public ConnectionDB() {
        dataSource = new BasicDataSource();                         //inizialize data source
        dataSource.setUrl(url);
        dataSource.setUsername(userDB);
        dataSource.setPassword(pasDB);
        dataSource.setMaxTotal(10);
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
    }

    //----------------------------GETTER-------------------------------------------
    public Connection getConnnection() {
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
}