Android下使用最新FaceBook SDK 3.0(三)使用facebook中的FQL查询信息

FQL查询相当于SQL查询,利用FQL查询，我们可以得到更多关于自己或者朋友的信息

strings.xml 文件

<?xml version="1.0" encoding="utf-8"?>
<resources>

    <string name="app_name">FirstFacebook</string>
    <string name="hello_world">Hello world!</string>
    <string name="menu_settings">Settings</string>
	<string name="app_id">494262210644963</string>
	<string name="send_request">Send Request</string>
	<string name="query">Query</string>
	<string name="multiQuery">Multi-query</string>
</resources>

activity_main.xml  添加两个按钮控件

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context=".MainActivity" >

    <com.facebook.widget.LoginButton
        android:id="@+id/login_button"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="center_horizontal"
        android:layout_marginBottom="30dp"
        android:layout_marginTop="30dp" />

    <Button
        android:id="@+id/queryButton"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="30dp"
        android:gravity="center"
        android:text="@string/query"
        android:textStyle="bold"
        android:visibility="invisible" />

    <Button
        android:id="@+id/multiQueryButton"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:layout_marginTop="30dp"
        android:gravity="center"
        android:text="@string/multiQuery"
        android:textStyle="bold"
        android:visibility="invisible" />

</LinearLayout>

MainActivity.java 

package com.thirdfacebook;

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

import android.content.pm.PackageInfo;
import android.content.pm.PackageManager;
import android.content.pm.PackageManager.NameNotFoundException;
import android.content.pm.Signature;
import android.os.Bundle;
import android.support.v4.app.FragmentActivity;
import android.util.Base64;
import android.util.Log;
import android.view.Menu;

public class MainActivity extends FragmentActivity {

	private MainFragment mainFragment;
	
	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		if (savedInstanceState == null) {
	        // Add the fragment on initial activity setup
	        mainFragment = new MainFragment();
	        getSupportFragmentManager()
	        .beginTransaction()
	        .add(android.R.id.content, mainFragment)
	        .commit();
	   	 } else {
	      	  // Or set the fragment from restored state info
	      	  mainFragment = (MainFragment) getSupportFragmentManager()
	      	  .findFragmentById(android.R.id.content);
	   	 }
		
		/**
		 * 打印哈希值
		 */
		try {
	        PackageInfo info = getPackageManager().getPackageInfo(
	                "com.firstfacebook", 
	                PackageManager.GET_SIGNATURES);
	        for (Signature signature : info.signatures) {
	            MessageDigest md = MessageDigest.getInstance("SHA");
	            md.update(signature.toByteArray());
	            Log.i("KeyHash:", Base64.encodeToString(md.digest(), Base64.DEFAULT));
	            }
	    } catch (NameNotFoundException e) {

	    } catch (NoSuchAlgorithmException e) {

	    }
	}


	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.activity_main, menu);
		return true;
	}
}

MainFragment.java  给两个按钮添加点击事件  （更多FQL查询可以到  https://developers.facebook.com/tools/explorer 测试查询）

package com.thirdfacebook;

import java.util.Arrays;

import org.json.JSONArray;
import org.json.JSONObject;

import android.content.Intent;
import android.os.Bundle;
import android.support.v4.app.Fragment;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.Toast;

import com.facebook.FacebookException;
import com.facebook.FacebookOperationCanceledException;
import com.facebook.FacebookRequestError;
import com.facebook.HttpMethod;
import com.facebook.Request;
import com.facebook.Response;
import com.facebook.Session;
import com.facebook.SessionState;
import com.facebook.UiLifecycleHelper;
import com.facebook.model.GraphObject;
import com.facebook.model.GraphUser;
import com.facebook.widget.LoginButton;
import com.facebook.widget.WebDialog;
import com.facebook.widget.WebDialog.OnCompleteListener;

public class MainFragment extends Fragment {
	private static final String TAG = "MainFragment";
	private UiLifecycleHelper uiHelper;

	private Button queryButton;
	private Button multiQueryButton;

	private Session.StatusCallback callback = new Session.StatusCallback() {
		@Override
		public void call(Session session, SessionState state,
				Exception exception) {
			onSessionStateChange(session, state, exception);
		}
	};

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		uiHelper = new UiLifecycleHelper(getActivity(), callback);
		uiHelper.onCreate(savedInstanceState);
	}

	@Override
	public View onCreateView(LayoutInflater inflater, ViewGroup container,
			Bundle savedInstanceState) {
		View view = inflater.inflate(R.layout.activity_main, container, false);

		LoginButton authButton = (LoginButton) view
				.findViewById(R.id.login_button);
		authButton.setFragment(this);
		authButton.setReadPermissions(Arrays
				.asList("email","user_likes", "user_status"));
		
		queryButton = (Button) view.findViewById(R.id.queryButton);
		multiQueryButton = (Button) view.findViewById(R.id.multiQueryButton);

		/*
		 * {
			    data: [
			        {
			            pic_square: "https://fbcdn-profile-a.akamaihd.net/hprofile-ak-prn1/41666_1424840234_9458_q.jpg",
			            uid: 1424840234,
			            name: "Christine Abernathy"
			        },
			        {
			            pic_square: "https://fbcdn-profile-a.akamaihd.net/hprofile-ak-ash4/211464_100002650977863_2642718_q.jpg",
			            uid: 100002650977863,
			            name: "James Forton"
			        }
			    ]
			}
		 */
		queryButton.setOnClickListener(new View.OnClickListener() {
		    @Override
		    public void onClick(View v) {
		        String fqlQuery = "SELECT uid, name, pic_square FROM user WHERE uid IN " +
		              "(SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 25)";
		        Bundle params = new Bundle();
		        params.putString("q", fqlQuery);
		        Session session = Session.getActiveSession();
		        Request request = new Request(session,
		            "/fql",                         
		            params,                         
		            HttpMethod.GET,                 
		            new Request.Callback(){         
		                public void onCompleted(Response response) {
		                	try {
			                	GraphObject graphObject = response.getGraphObject();
			                    FacebookRequestError error = response.getError();
			                    if (graphObject != null) {
			                        // Check if there is extra data
			                		if (graphObject.getProperty("data") != null) {
			                			JSONArray dataArray = new JSONArray(graphObject.getProperty("data").toString());
			                			for(int i=0;i<=dataArray.length();i++){
			                				JSONObject dataObject = (JSONObject)dataArray.get(i);
			                				
			                				String pic = dataObject.getString("pic_square");//头像
			                				String uid = dataObject.getString("uid");//id
			                				String name = dataObject.getString("name");//名字
			                				Toast.makeText(MainFragment.this.getActivity(), pic+"\n"+uid+"\n"+name, Toast.LENGTH_SHORT).show();
			                			}
			                	    }else if (error != null) {
			                            
			                	    }
			                    }
			                    Log.i(TAG, "Result: " + response.toString());
		                	} catch (Exception e) {
								e.printStackTrace();
							}
		                }                  
		        }); 
		        Request.executeBatchAsync(request);                 
		    }
		});
		
		
		/*
		 * 数据模版
		 * {
			    data: [
			        {
			        fql_result_set: [
			            {
			                uid2: "1424840234"
			            },
			            {
			                uid2: "100002650977863"
			            }
			        ],
			        name: "friends"
			    },
			    {
			        fql_result_set: [
			            {
			                pic_square: "https://fbcdn-profile-a.akamaihd.net/hprofile-ak-prn1/41666_1424840234_9458_q.jpg",
			                uid: 1424840234,
			                name: "Christine Abernathy"
			            },
			            {
			                pic_square: "https://fbcdn-profile-a.akamaihd.net/hprofile-ak-ash4/211464_100002650977863_2642718_q.jpg",
			                uid: 100002650977863,
			                name: "James Forton"
			            }
			        ],
			        name: "friendinfo"
			    }
			    ]
			}
		 */
		multiQueryButton.setOnClickListener(new View.OnClickListener() {
		    @Override
		    public void onClick(View v) {

		       /* String fqlQuery = "{" +
		              "'friends':'SELECT uid2 FROM friend WHERE uid1 = me() LIMIT 25'," +
		              "'friendinfo':'SELECT uid, name, pic_square FROM user WHERE uid IN " +
		              "(SELECT uid2 FROM #friends)'," +
		              "}";*/
		    	String fqlQuery = "SELECT uid,name,email FROM user WHERE uid = me()";
		        Bundle params = new Bundle();
		        params.putString("q", fqlQuery);
		        Session session = Session.getActiveSession();
		        Request request = new Request(session,
		            "/fql",                         
		            params,                         
		            HttpMethod.GET,                 
		            new Request.Callback(){         
		                public void onCompleted(Response response) {
		                	Toast.makeText(MainFragment.this.getActivity(), response.toString(), Toast.LENGTH_SHORT).show();
		                    Log.i(TAG, "Result: " + response.toString());
		                }                  
		        }); 
		        Request.executeBatchAsync(request);                 
		    }
		});

		return view;
	}

	private void onSessionStateChange(Session session, SessionState state,
			Exception exception) {
		if (state.isOpened()) {
			sendRequestButton.setVisibility(View.VISIBLE);
			queryButton.setVisibility(View.VISIBLE);
	        multiQueryButton.setVisibility(View.VISIBLE);
			makeMeRequest(session);
			Log.i(TAG, "Logged in...");
		} else if (state.isClosed()) {
			sendRequestButton.setVisibility(View.INVISIBLE);
			queryButton.setVisibility(View.INVISIBLE);
	        multiQueryButton.setVisibility(View.INVISIBLE);
			Log.i(TAG, "Logged out...");
		}
	}
	
	/**
	 * 获取登录信息
	 * @param session
	 */
	private void makeMeRequest(final Session session) {
		
//		Bundle params1 = new Bundle();
//		params1.putString("fields","picture");
//		Log.v("sss", authenticatedFacebook.request("me"));
//		JSONObject jObject = new JSONObject(authenticatedFacebook.request("me"));
//		String id=jObject.getString("id");
//		String name=jObject.getString("name");
//		String email=jObject.getString("email");
//		try {
//		   URL img_value = new URL("http://graph.facebook.com/"+id+"/picture?type=large");
//		   Bitmap mIcon1 =     BitmapFactory.decodeStream(img_value.openConnection().getInputStream());
//		} catch (Exception e) {
//			e.printStackTrace();
//		}
		
		
		// Make an API call to get user data and define a
		// new callback to handle the response.
		Request request = Request.newMeRequest(session,
				new Request.GraphUserCallback() {
					@Override
					public void onCompleted(GraphUser user, Response response) {
						// If the response is successful
						if (session == Session.getActiveSession()) {
							if (user != null) {
								
								try {
									Toast.makeText(MainFragment.this.getActivity(),user.getProperty("email")+"", Toast.LENGTH_LONG).show();
								} catch (Exception e) {
									e.printStackTrace();
								}
								 
							}
						}
						if (response.getError() != null) {
							// Handle errors, will do so later.
						}
					}
				});
		request.executeAsync();
	}

	@Override
	public void onResume() {
		super.onResume();

		// For scenarios where the main activity is launched and user
		// session is not null, the session state change notification
		// may not be triggered. Trigger it if it's open/closed.
		Session session = Session.getActiveSession();
		if (session != null && (session.isOpened() || session.isClosed())) {
			onSessionStateChange(session, session.getState(), null);
		}

		uiHelper.onResume();
	}

	@Override
	public void onActivityResult(int requestCode, int resultCode, Intent data) {
		super.onActivityResult(requestCode, resultCode, data);
		uiHelper.onActivityResult(requestCode, resultCode, data);
	}

	@Override
	public void onPause() {
		super.onPause();
		uiHelper.onPause();
	}

	@Override
	public void onDestroy() {
		super.onDestroy();
		uiHelper.onDestroy();
	}

	@Override
	public void onSaveInstanceState(Bundle outState) {
		super.onSaveInstanceState(outState);
		uiHelper.onSaveInstanceState(outState);
	}
}

AndroidMainfest.xml  

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.thirdfacebook"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk
        android:minSdkVersion="8"
        android:targetSdkVersion="16" />
    <uses-permission android:name="android.permission.INTERNET"/>

    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.thirdfacebook.MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <activity android:name="com.facebook.LoginActivity"/>
        <meta-data android:name="com.facebook.sdk.ApplicationId" android:value="@string/app_id"/>
    </application>

</manifest>

参考自： http://developers.facebook.com/docs/howtos/androidsdk/3.0/run-fql-queries/