package DBFOschemafy_V_3_001;

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

/**
 *  Design:
 *  https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-connect-drivermanager.html
 * 
 *  <b>Environment:</b> 
 *  <ul>
 *  <li>    IDE:              Eclipse IDE for Java Developers
 *  <li>    Version:          2021-12 (4.22.0)
 *  <li>    Build id:         20211202-1639
 *  <li>    HW Model Name:    iMac, MacOS Monterey, 12.5.1
 *  <li>    Processor Name:   Quad-Core Intel Core i5
 *  <li>    Processor Speed:  3.2 GHz
 *  <li>    Memory:           32 GB 1867 MHz DDR3
 *  <li>    Disk:             APPLE SSD SM0256G    
 *  <li>    Serial:           DGKRC080GG7V
 *  <li>    RDB:              MySQL Server (Version 8.0.30), 
 *  <li>    Workbench:        MySQL Workbench (Version 8.0.31 build 2235049 CE (64 bits) Community)
 *  <li>    JDBC connector:   mysql-connector-j-9.1.0.jar
 *  </ul>
 *  @version 1-001
 *  @since   2024/11/27
 *  @author  Edit Hlaszny PhD (https://www.edithlaszny.eu/) 
 */

public class DBserverConnection
{
    private Connection conn = null ;
    
    public void connectDB(String url  ,
                          String user ,
                          String password) 
    {
        try 
        {
            this.conn = DriverManager.getConnection(url, user, password) ;
        } 
        catch (SQLException ex) 
        {
            System.out.println("Cannot connect the database") ;
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: "     + ex.getSQLState());
            System.out.println("VendorError: "  + ex.getErrorCode());
            
            ex.printStackTrace();
        }              
        
    }  //  end of method connectDB()

    
    public  Connection getDBconnector()
    {
        return this.conn ;
        
    }   //  end of method getDBconnector()

}   //  end of class DBserverConnection