views:

29

answers:

0

This is the code that I use for my Listview which I got reference for some website. It shows a whole list of image. Which area do I have to place in my database to set the text for toptext and bottom text?

public class List_View extends ListActivity {

private DBAdapter db;

private TextView toptext; private TextView bottomtext; private ListView lv;

public void onCreate(Bundle savedInstanceState) { try{

super.onCreate(savedInstanceState); 
setContentView(R.layout.list); 
db = new DBAdapter(this); 

toptext = (TextView) findViewById (R.id.toptext); 
bottomtext = (TextView) findViewById (R.id.bottomtext); 

ArrayList<HashMap<String, String>> list = new ArrayList<HashMap<String, String>>();

HashMap<String, String> item;
for (int i = 0; i < 31; i++) {

        item = new HashMap<String, String>();
        item.put("Date:", "Saved Date" );
        item.put("Title:", "Saved Title" );
        list.add(item);
}

SimpleAdapter notes = new SimpleAdapter(this, list, R.layout.view_list,
                        new String[] { "date", "title" }, 
                        new int[] {R.id.toptext, R.id.bottomtext });
setListAdapter(notes);

} catch(Throwable e){

        Log.e("DBAdapter",e.toString()); 

} }

and this is the database part.

public Cursor getAllEntry() 
{
    return db.query(DATABASE_TABLE_2, new String[] {
            KEY_ROWID2,
            KEY_TITLE,
            KEY_ENTRY,
            KEY_MOOD,
            KEY_DATE,
            KEY_TIME},
            null, 
            null, 
            null, 
            null, 
            null, 
            null);
}