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/
类似资料：