package Controller;

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

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.DatabaseMetaData;
public class DBConnect {
    public  Connection getConnect() throws Exception{
        
        
        
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/dbname?useSSL=false";
			String user="root";
			String password="password";
			Connection connection=(Connection) DriverManager.getConnection(url, user, password);
                        
        if (connection != null) {
            System.out.println("Connected");
            DatabaseMetaData dm = (DatabaseMetaData) connection.getMetaData();
            System.out.println("Driver name: " + dm.getDriverName());
            System.out.println("Driver version: " + dm.getDriverVersion());
            System.out.println("Product name: " + dm.getDatabaseProductName());
            System.out.println("Product version: " + dm.getDatabaseProductVersion());
        }
        return connection;
    }
    

}