English 中文(简体)
Android: SQLite and ListViews
原标题:

Firstly, I have found many examples of how to grab data from a db and place it into a list, however this seems to be all for ListActivites.

My list is part of the UI and therefore I can t use a ListActivity because it does not consume the whole screen (or can I?).

This is the UI:

<SlidingDrawer android:layout_width="wrap_content" 
 android:layout_height="wrap_content" 
   android:id="@+id/Drawer"
  android:orientation="vertical"
  android:handle="@+id/handle" 
   android:content="@+id/content">

<ImageView
android:id="@id/handle"
android:src="@drawable/tray_handle_normal"
android:layout_height="wrap_content" android:layout_width="wrap_content"/>

<RelativeLayout 
android:layout_width="wrap_content" 
android:layout_height="wrap_content" 
android:id="@id/content" android:background="@color/black">


<ListView 
android:layout_width="wrap_content" 
android:layout_height="wrap_content" 
android:id="@+id/List">
</ListView>

</RelativeLayout>

So, from what ive read I need to grab the data from the db, then place it into some sort of array then use an array adapter to fill the list view. Is that correct? If so, is there some sample code because all I can find is code releated to ListActivites.

最佳回答

You can still use a ListActivity. The magic is to set the id of your ListView to "@android:id/list". However, ListActivity is just a convenience. You can get the same result by creating an adapter (look at ArrayAdapter or SimpleCursorAdapter) and connecting it to the ListView by hand.

问题回答

I think you can use a SimpleCursorAdapter for this.

I think the Notepad tutorial uses it. If you need more complicated things, it s just a matter of you implementing your own view adapter. Here s sample code that shows you how to do it.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签