package dellwon.ch6.data;

import java.util.ArrayList;
import java.util.HashMap;

import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.widget.ListView;
import android.widget.SimpleAdapter;

public class MemberList extends Activity {

	/** Called when the activity is first created. */
	@Override
	public void onCreate(Bundle savedInstanceState) {
	    super.onCreate(savedInstanceState);
	
	    setContentView(R.layout.memberlist);
	    ListView lv=(ListView)findViewById(R.id.list_list);
	    
	    DBAdapter adb=new DBAdapter(this, 
				DBAdapter.SQL_CREATE_MEMBER,"member");
		
	    adb.open();
		
		String columns[]={"name", "addr"};		
		Cursor c =
			adb.selectTable(columns, null, null, null, null, null);
		
		ArrayList<HashMap<String, String>> list=
			new ArrayList<HashMap<String,String>>();
		
		if(c.moveToFirst()){
			do{
				HashMap<String, String> map=
					new HashMap<String, String>();
				map.put("name", c.getString(0));
				map.put("addr", c.getString(1));
				list.add(map);				
			}while(c.moveToNext());
		}

		SimpleAdapter ap=
			new SimpleAdapter(this, list, 
					android.R.layout.simple_list_item_2,
					new String[]{"name", "addr"},
					new int[]{android.R.id.text1, android.R.id.text2});
		
		lv.setAdapter(ap);

		adb.close();
	}

}