package com.test.storage;

import java.util.ArrayList;

import android.app.ListActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;

public class DataListView extends ListActivity {

	ArrayList<String> results = new ArrayList<String>();
	private static String itemId;
	private Cursor cursor;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		// TODO Auto-generated method stub
		super.onCreate(savedInstanceState);

		openAndQueryDatabase();

		displayResultList();

		onClickItem();
	}

	private void openAndQueryDatabase() {
		try {
			SQLiteDatabase db = openOrCreateDatabase("TestDB",
					MODE_PRIVATE, null);
			Cursor c = db.rawQuery("select * from Student", null);

			if (c != null) {
				if (c.moveToFirst()) {
					do {

						results.add(c.getString(1));

					} while (c.moveToNext());
				}
			}
		} catch (Exception e) {
			Log.d("Exception", e.getMessage());
		}

	}

	private void displayResultList() {

		setListAdapter(new ArrayAdapter<String>(this,
				android.R.layout.simple_list_item_1, results));
		getListView().setTextFilterEnabled(true);

	}

	private void onClickItem() {

		OnItemClickListener clickListener = new OnItemClickListener() {

			@Override
			public void onItemClick(AdapterView<?> parent, View v,
					int position, long l) {

				cursor = (Cursor) parent.getItemAtPosition(position);
				itemId = cursor.getString(0);

				// Bundle bundle = new Bundle();
				// bundle.putString("cName", cursor.getString(1));
				// bundle.putString("cAge", cursor.getString(2));

				Intent intent = new Intent(DataListView.this, ResultView.class);
				intent.putExtra("cName", cursor.getString(1));
				startActivity(intent);

			}
		};

		getListView().setOnItemClickListener(clickListener);

	}

}