import java.sql.*;
import java.util.*;
public class Driver {

    public static void main(String[] args) throws SQLException {
        Connection myConn = null;
        Statement myStmt = null;
        ResultSet myRs = null;
        Scanner in = new Scanner(System.in);
        System.out.println("Inserisci nome: ");
        String a = in.nextLine();
        System.out.println("Inserisci cognome : ");
        String b = in.nextLine();

        try {
            // 1. Creo una connessione al Database
            myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/prova?useSSL=false", "root" , "home");

            // 2. Creo uno Statement
            myStmt = myConn.createStatement();

            // 3. Eseguo le Query SQL
            myRs = myStmt.executeQuery("SELECT * FROM studenti WHERE Nome = "+ a +" AND Cognome = "+ b +" ");

            // 4. Elaboro il risultato
            while (myRs.next()) {
                System.out.println(myRs.getString("Nome") + ", " + myRs.getString("Cognome"));
            }
        }
        catch (Exception exc) {
            exc.printStackTrace();
        }
        finally {
            if (myRs != null) {
                myRs.close();
            }

            if (myStmt != null) {
                myStmt.close();
            }

            if (myConn != null) {
                myConn.close();
            }
            in.close();
        }

    }

}