public static void main(String[] args) {
		// TODO Auto-generated method stub
		/*
		 * Connection execute return resultSet <--- griglia di dati Classe Connection
		 * Factory() Class Dao
		 */
		Main m = new Main();
		try {
			m.execute();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	private void execute() throws Exception {

		// Istanza Connessione
		Connection con = getConnection();
		Statement statment = con.createStatement();
		ResultSet rs = statment.executeQuery("select city from city");
		ResultSetMetaData rsmd = rs.getMetaData();
		int columnsNumber = rsmd.getColumnCount();
		while (rs.next()) {
			for (int i = 1; i <= columnsNumber; i++) {
				if (i > 1)
					System.out.print(",  ");
				String columnValue = rs.getString(i);
				System.out.print(columnValue + " " + rsmd.getColumnName(i));
			}
			System.out.println("");
		}
		con.close();
	}

	private Connection getConnection() throws Exception {
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = null;
		conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sakila", "root", "alternanza");
		return conn;
	}