import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

public class DBcontext {

    private final String serverName = "localhost";
    private final String portNumber = "1433";
    private final String dbName = "Trading2019";
    private final String userId = "sa";
    private final String password = "123";

    public Connection getConnection() throws SQLException, ClassNotFoundException {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        return DriverManager.getConnection(
                "jdbc:sqlserver://" + serverName + ":" + portNumber
                        + ";databaseName=" + dbName,
                userId,
                password);
    }

}