public static void main(String[] args) {

		final String DRIVER = "com.mysql.cj.jdbc.Driver";

		final String DB_URL_COMPLETA = "jdbc:mysql://localhost:3306/AgenziaImmobiliare?user=root&password=corso&serverTimezone=UTC";
		final String DB_URL = "jdbc:mysql://localhost:3306/AgenziaImmobiliare?serverTimezone=UTC";
		final String DB_USER = "root";
		final String DB_PASSWORD = "corso";

		// 1. Verificare il name del driver
		try {
			Class.forName(DRIVER).newInstance();
		} catch (Exception e) {
			System.out.println("Errore con Class.forName()");
		}

		// 2. Stabilire la connessione al database MySQL
		Connection con = null;
		try {
			con = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
			// Connection con2 = DriverManager.getConnection(DB_URL_COMPLETA);
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("Errore con la connessione al DB");
		}

		// 3. Query
		try {
			if (con != null) {
				Statement statement = con.createStatement();
				String query = "SELECT * FROM immobile";
				ResultSet res = statement.executeQuery(query);
				while (res.next()) {
					System.out.print(res.getString("id") + " ");
					System.out.println(res.getString(2) + "");
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}