Azure SQLのデータをListViewに表示させる

public class MainActivity extends Activity {

MobileServiceClient mClient;

MobileServiceTable<TokutenItem> mTokutenTable;

TokutenItemAdapter mAdapter;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.benefit_list);

// 1)ListViewとadapterを設定、rowのlayoutも紐づく

mAdapter = new TokutenItemAdapter(this, R.layout.benifit_cell);

ListView listViewBenefit = (ListView) findViewById(R.id.benefitList);

listViewBenefit.setAdapter(mAdapter);

try {

// 2)Create the Mobile Service Client instance, using the provided

// Mobile Service URL and key

mClient = new MobileServiceClient(

　　　　　　　 "https://xxxxxxx.azure-mobile.net/",

"keyforAzuraMobileService", 

this);

// 3)Get the Mobile Service Table instance to use

mTokutenTable = mClient.getTable(TokutenItem.class);

} catch (MalformedURLException e) {

createAndShowDialog(new Exception("There was an error creating the Mobile Service. Verify the URL"), "Error");

}

// 4)SQL実行

mTokutenTable.where().field("venusId").eq("4e25173e091a817e3dd67300")

.execute(new TableQueryCallback<TokutenItem>() {

　　　　　　　　　　　　　　　　　　　　　　　　　 // 5)SQL完了したあとのcallbackでadapterを更新

public void onCompleted(List<TokutenItem> result, 

        int count,

                Exception exception, 

                ServiceFilterResponse response) {   

   if (exception == null) {

mAdapter.clear();

        for (TokutenItem item : result) {

mAdapter.add(item);

}

   } else {

        createAndShowDialog(exception, "Error");

  }

        }

});

}

Adapterの設計

public class TokutenItemAdapter extends ArrayAdapter<TokutenItem>{

/**

* Adapter context

*/

Context mContext;

/**

* Adapter View layout

*/

int mLayoutResourceId;

public TokutenItemAdapter(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 TokutenItem currentItem = getItem(position);

if (row == null) {//再利用できるrowがあるかどうかをチェック、なければ新規作成
LayoutInflater inflater = ((Activity) mContext).getLayoutInflater();
row = inflater.inflate(mLayoutResourceId, parent, false);
}

//rowのlayoutになにを表示させるかを設定

TextView pointTv = (TextView) row.findViewById(R.id.point);
TextView priceDownTv = (TextView) row.findViewById(R.id.priceDown);
pointTv.setText(Float.toString(currentItem.getPointUp()));
priceDownTv.setText(Integer.toString(currentItem.getPriceDown()));

return row;
}

}