ตอนที่ 8 : อ่านข้อมูล Mobile Services แบบมีเงื่อนไข Where และแสดงผลบน Android

package com.example.thaicreate;

public class MyMember {
	
	@com.google.gson.annotations.SerializedName("id")
	private int mId;
	
	@com.google.gson.annotations.SerializedName("name")
	private String mName;
	
	@com.google.gson.annotations.SerializedName("email")
	private String mEmail;	
	
	@com.google.gson.annotations.SerializedName("status")
	private String mStatus;	
	
	public MyMember() {
		// empty
	}
	
	public MyMember(String name, String email) {
		this.setName(name);
		this.setEmail(email);
	}
	
	public int getId() {
		return mId;
	}	
	
	public final void setName(String name) {
		mName = name;
	}
	public String getName() {
		return mName;
	}
	
	public final void setEmail(String email) {
		mEmail = email;
	}
	public String getEmail() {
		return mEmail;
	}
	
	public final void setStatus(String status) {
		mStatus = status;
	}
	public String getStatus() {
		return mStatus;
	}	
	
}

package com.example.thaicreate;

import java.net.MalformedURLException;
import java.util.List;

import android.app.Activity;
import android.content.Context;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.TextView;

import com.microsoft.windowsazure.mobileservices.MobileServiceClient;
import com.microsoft.windowsazure.mobileservices.MobileServiceTable;
import com.microsoft.windowsazure.mobileservices.ServiceFilterResponse;
import com.microsoft.windowsazure.mobileservices.TableQueryCallback;

public class MainActivity extends Activity {
	
	private MobileServiceClient mClient;
	private MobileServiceTable<MyMember> mMyMember;
	private MyMemberAdapter mAdapter;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        
        /*** Create to Mobile Services ***/
        try {
			mClient = new MobileServiceClient(
				      "https://thaicreate.azure-mobile.net/",
				      "QUjngFknhHZjdaGgYAAzdoXkOzKoxi24",
				      this);
			
		} catch (MalformedURLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
        
        /*** Create getTable ***/
        mMyMember = mClient.getTable(MyMember.class);
        
        // listView1
        final ListView lstView1 = (ListView)findViewById(R.id.listView1); 
        mAdapter = new MyMemberAdapter(this,R.layout.activity_column);
        lstView1.setAdapter(mAdapter);
        
        refreshItemsFromTable();
        
    }
    
	private void refreshItemsFromTable() {

		mMyMember.where().field("status").eq("1").execute(new TableQueryCallback<MyMember>() {
			public void onCompleted(List<MyMember> result, int count, Exception exception, ServiceFilterResponse response) {
				
				if (exception == null) {
					mAdapter.clear();
					for (MyMember item : result) {
						mAdapter.add(item);
					}
				} else {
					Log.d("Error","Error Load Data from Mobile Service");
				}
			}
		});
	}


	public class MyMemberAdapter extends ArrayAdapter<MyMember> {
		Context mContext;
		int mLayoutResourceId;

		public MyMemberAdapter(Context context, int layoutResourceId) {
			super(context, layoutResourceId);

			mContext = context;
			mLayoutResourceId = layoutResourceId;
		}

		@Override
		public View getView(int position, View convertView, ViewGroup parent) {
			View row = convertView;

			final MyMember currentItem = getItem(position);

			if (row == null) {
				LayoutInflater inflater = ((Activity) mContext).getLayoutInflater();
				row = inflater.inflate(mLayoutResourceId, parent, false);
			}

			row.setTag(currentItem);
			
			// Column id
			final TextView txt_id = (TextView) row.findViewById(R.id.col_id);
			txt_id.setText(String.valueOf(currentItem.getId()));
			
			// Column name
			final TextView txt_name = (TextView) row.findViewById(R.id.col_name);
			txt_name.setText(currentItem.getName());
			
			// Column email
			final TextView txt_email = (TextView) row.findViewById(R.id.col_email);
			txt_email.setText(currentItem.getEmail());
			
			// Column status
			final TextView txt_status = (TextView) row.findViewById(R.id.col_status);
			txt_status.setText(currentItem.getStatus());	
			
			return row;
		}
	}
    

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;
    }

}

mMyMember.where().field("status").eq("1").and
.field("id").eq(3)
.orderByDescending('id');
.execute(new TableQueryCallback<MyMember>() {
	public void onCompleted(List<MyMember> result, int count, Exception exception, ServiceFilterResponse response) {
		
		if (exception == null) {
			mAdapter.clear();
			for (MyMember item : result) {
				mAdapter.add(item);
			}
		} else {
			Log.d("Error","Error Load Data from Mobile Service");
		}
	}
});