package school;

import com.sun.xml.internal.ws.api.model.CheckedException;

import java.sql.*;

/**
 * Created by ns on 25.12.17.
 */
public class ConnectionManager
{
    private String url;

    public ConnectionManager (String serverName, String myDatabase)
    {
       String driverName = "com.mysql.jdbc.Driver";
       url = "jdbc:mysql://" + serverName + "/" + myDatabase;
       try
       {
           Class.forName(driverName).newInstance();
       }
       catch (InstantiationException e)
       {
           e.printStackTrace();
       }
       catch (IllegalAccessException e)
       {
           e.printStackTrace();
       }
       catch (ClassNotFoundException e)
       {
           e.printStackTrace();
       }
    }
    public Connection connect(String username, String password) throws SQLException
    {

        Connection con;
        con = DriverManager.getConnection(url, username, password);
        return con;
    }
}