import java.sql.*;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

public class DBConnection {

    // Info connessioni DB
    private static final String dbName = "MotoDB";
    private static final String url = "jdbc:mysql://motodb.c1s5lipxxzvy.eu-west-1.rds.amazonaws.com:3306";
    private static final String username = "Administrator";
    private static final String password = "cocomero";
    private Connection connection;
    private MysqlDataSource dataSource;

    public Connection getConnection()  {

        dataSource = new MysqlDataSource();
        dataSource.setUser(username);
        dataSource.setPassword(password);
        dataSource.setServerName(url);
        dataSource.setDatabaseName(dbName);

        ResultSet rs;
        try {
            connection = dataSource.getConnection();
            /*Statement stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM CAMPIONATO");
            while (rs.next()) {
                System.out.println(rs.getString("anno"));
            }
            rs.close();
            stmt.close();
            */
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }

}