Untitled

package edu.cmich.cps396m.badger1;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

import android.content.res.AssetManager;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;

public class LectureListViewActivityExampleActivity extends BadgeR_Activity {
	
	private SQLiteDatabase database;
	private Cursor cursor;
	
	@Override
	public void onCreate(Bundle savedInstanceState){
		super.onCreate(savedInstanceState);
		setContentView(R.layout.main);
		
		File f = new File("/mnt/sdcard/demo.db3");
		if(!f.exists()){
			AssetManager am = this.getAssets();
			byte[] buff = new byte[1024];
			try{
				InputStream in = am.open("demo.db3");
				FileOutputStream fos = new FileOutputStream(f);
				int read=0;
				while((read = in.read(buff)) > 0)
				{
				fos.write(buff, 0, read);
				}
				in.close();
				fos.flush();
				fos.close();
			}
			catch (IOException e){
				e.printStackTrace();
			}
		}
		
		database = SQLiteDatabase.openDatabase("/mnt/sdcard/demo.db3", null, SQLiteDatabase.OPEN_READONLY);
		if(database != null){
			cursor = database.rawQuery("SELECT rowid _id,* FROM basdges", null);
			SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.list_item, cursor, new String[] {"name", "status", "image"}, new int[] {R.id.textView1, R.id.textView2});
			adapter.setViewBinder(new MyViewBinder());
			ListView lv = (ListView)findViewById(R.id.listView1);
			lv.setAdapter(adapter);
			/*
			lv.setOnItemClickListener(new OnItemClickListener(){
				
			})
			*/
		}
	}
	
	private class MyViewBinder implements SimpleCursorAdapter.ViewBinder{
		
		public boolean setViewValue(View view, Cursor crs, int columnIndex) {
			int viewID = view.getId();
			switch(viewID){
			case R.id.textView1:
				((TextView) view).setText(crs.getString(columnIndex));
				break;
			case R.id.textView2:
				((TextView) view).setText( crs.getString(columnIndex));
				break;
			case R.id.imageView1:
				byte[] imagedata = crs.getBlob(columnIndex);
				//((ImageView) view).setImageDrawable(drawable);
				break;
			}
			// TODO Auto-generated method stub
			return false;
		}
	}


}