package com.sqlite;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;
public class DBActivity extends Activity {
/** Called when the activity is first created. */
private ListView listView;
private PersonService personService;
private List<Person> persons;
private List<HashMap<String, Object>> data;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
personService = new PersonService(this);
listView = (ListView)findViewById(R.id.listView);
listView.setOnItemClickListener(new ItemClickListener());
show();
}
private class ItemClickListener implements OnItemClickListener{
public void onItemClick(AdapterView<?> parent, View view, int position,
long id) {
// TODO Auto-generated method stub
String name = (String)data.get(position).get("name");
Toast.makeText(DBActivity.this, name, 1).show();
}
}
private void show() {
//从数据库获得前10条数据
data = new ArrayList<HashMap<String,Object>>();
persons = personService.getScrollData(0, 10);
for(Person person : persons){
HashMap<String, Object> item= new HashMap<String, Object>();
item.put("name", person.getName());
item.put("phone", person.getPhone());
item.put("amount", person.getAmount());
item.put("id", person.getId());
data.add(item);
}
//创建适配器对象
SimpleAdapter adapter = new SimpleAdapter(this, data, R.layout.item,
new String[]{"name","phone","amount"}, new int[]{R.id.name,R.id.phone,R.id.amount});
listView.setAdapter(adapter);
}
}
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<ListView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:id="@+id/listView"
/>
</LinearLayout>
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="horizontal" >
<TextView
android:layout_width="100dp"
android:layout_height="100dp"
android:id="@+id/name"/>
<TextView
android:layout_width="150dp"
android:layout_height="100dp"
android:id="@+id/phone"/>
<TextView
android:layout_width="fill_parent"
android:layout_height="100dp"
android:id="@+id/amount"/>
</LinearLayout>