package bge_java;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectToMySQL {

    public static void main(String[] args) throws SQLException {
        Connection connect = null;
        String url;
        String myDataBase = "mysql";
        String myHost = "localhost";
        String myPort = "3306";
        String mySID = "basetest2";
        String myUser = "root";
        String myPassword = "";
        url = "jdbc:"+myDataBase+"://"+myHost+":"+myPort+"/"+mySID+"?user="+myUser+"&password="+myPassword;

        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (ClassNotFoundException ex) {
            System.out.println("ClassNotFoundException: " + ex);
        } catch (InstantiationException ex) {
            System.out.println("InstantiationException: " + ex);
        } catch (IllegalAccessException ex) {
            System.out.println("IllegalAccessException: " + ex);
        }
        try {
            connect = DriverManager.getConnection(url);
            Statement maRequete = null;
            maRequete = connect.createStatement();
            ResultSet mesDonnees;
            mesDonnees = maRequete.executeQuery("SELECT * FROM tabletest2");
            PreparedStatement requetePreparee = connect.prepareStatement("SELECT * FROM tabletest2");
            ResultSet rs = requetePreparee.executeQuery();


            while (mesDonnees.next()) {
                String col1 = mesDonnees.getString(1);
                String col2 = mesDonnees.getString(2);
                System.out.println(col1 + ", " + col2);
            }

            maRequete.executeUpdate("INSERT INTO tabletest2 VALUES('Salut','Hey')");
//            maRequete.executeUpdate("COMMIT");
//            a faire si le set autocommit est false qui signifie que les données sont sauvegardees en zone tampon
        } catch (SQLException ex) {
            System.out.println("SQLException: " + ex);
        }
        System.out.println("Connexion à la base de données MySQL établie ");
    }
}