[android-developers] display db columns into a listview
Hi,
I'm newbie on android developi have a question about how i implement my
db columns into a listview...
I do this code below but I display wich column in one row..how I display one
or more columns in one row.has anyone had an reference to send me.
public class Restaurants extends ListActivity {
private ArrayListRestaurantsInfo mListRestaurants;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
try {
setContentView(R.layout.restaurants);
mListRestaurants = getRestaurants();
ListString items = new ArrayListString();
for(RestaurantsInfo restaurant:mListRestaurants){
items.add(restaurant.res_name);
items.add(restaurant.res_city);
}
//display into a restaurant_row.xml
ArrayAdapterString adapter = new
ArrayAdapterString(this, R.layout.restaurant_row,items);
setListAdapter(adapter);
} catch (Exception e) {
// TODO: handle exception
Log.e(oncreate resta,e.getMessage());
}
}
public ArrayListRestaurantsInfo getRestaurants(){
String query = Select * from restaurants;
ArrayListRestaurantsInfo lstRestaurants = new
ArrayListRestaurantsInfo();
DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(this);
try {
dbAdapter.createDataBase();
} catch (IOException e) {
// TODO: handle exception
Log.e(*** select ,e.getMessage());
}
dbAdapter.openDataBase();
ArrayListArrayListString stringList =
dbAdapter.selectRecordsFromDBList(query, null);
dbAdapter.close();
for (int i = 0; i stringList.size(); i++) {
ArrayListString list = stringList.get(i);
RestaurantsInfo restaurant = new RestaurantsInfo();
try {
restaurant.res_id = Integer.parseInt(list.get(0));
restaurant.res_name = list.get(1);
restaurant.res_address = list.get(2);
restaurant.res_number = list.get(3);
restaurant.res_neiborhood = list.get(4);
restaurant.res_image = list.get(5);
restaurant.res_lat = list.get(6);
restaurant.res_long = list.get(7);
restaurant.res_city = list.get(8);
} catch (Exception e) {
Log.i(*** + Restaurants.class.toString(),
e.getMessage());
}
lstRestaurants.add(restaurant);
}
return lstRestaurants;
}
}
// restaurant_row.xml
?xml version=1.0 encoding=utf-8?
TextView android:id=@+id/text1 xmlns:android=http://
schemas.android.com/apk/res/android
android:layout_width=wrap_content
android:layout_height=wrap_content/
Thanks very much !
Igor Nesralla Ribeiro
--
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
[android-developers] display db columns into a listview
Hi,
I'm newbie on android developi have a question about how i implement my
db columns into a listview...
I do this code below but I display wich column in one row..how I display one
or more columns in one row.has anyone had an reference to send me.
public class Restaurants extends ListActivity {
private ArrayListRestaurantsInfo mListRestaurants;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
try {
setContentView(R.layout.restaurants);
mListRestaurants = getRestaurants();
ListString items = new ArrayListString();
for(RestaurantsInfo restaurant:mListRestaurants){
items.add(restaurant.res_name);
items.add(restaurant.res_city);
}
//display into a restaurant_row.xml
ArrayAdapterString adapter = new
ArrayAdapterString(this, R.layout.restaurant_row,items);
setListAdapter(adapter);
} catch (Exception e) {
// TODO: handle exception
Log.e(oncreate resta,e.getMessage());
}
}
public ArrayListRestaurantsInfo getRestaurants(){
String query = Select * from restaurants;
ArrayListRestaurantsInfo lstRestaurants = new
ArrayListRestaurantsInfo();
DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(this);
try {
dbAdapter.createDataBase();
} catch (IOException e) {
// TODO: handle exception
Log.e(*** select ,e.getMessage());
}
dbAdapter.openDataBase();
ArrayListArrayListString stringList =
dbAdapter.selectRecordsFromDBList(query, null);
dbAdapter.close();
for (int i = 0; i stringList.size(); i++) {
ArrayListString list = stringList.get(i);
RestaurantsInfo restaurant = new RestaurantsInfo();
try {
restaurant.res_id = Integer.parseInt(list.get(0));
restaurant.res_name = list.get(1);
restaurant.res_address = list.get(2);
restaurant.res_number = list.get(3);
restaurant.res_neiborhood = list.get(4);
restaurant.res_image = list.get(5);
restaurant.res_lat = list.get(6);
restaurant.res_long = list.get(7);
restaurant.res_city = list.get(8);
} catch (Exception e) {
Log.i(*** + Restaurants.class.toString(),
e.getMessage());
}
lstRestaurants.add(restaurant);
}
return lstRestaurants;
}
}
// restaurant_row.xml
?xml version=1.0 encoding=utf-8?
TextView android:id=@+id/text1 xmlns:android=http://
schemas.android.com/apk/res/android
android:layout_width=wrap_content
android:layout_height=wrap_content/
Thanks very much !
Igor Nesralla Ribeiro
--
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
