Android：ListView

首先定义条目界面

<?xml version="1.0"encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" 

android:orientation="horizontal" 

android:layout_width="fill_parent" 

android:layout_height="fill_parent">  

 <TextView 

android:layout_width="120dp" 

android:textSize="22sp" 

android:layout_height="wrap_content" 

android:id="@+id/name" />    

<TextView android:layout_width="150dp" 

 android:textSize="22sp" 

android:layout_height="wrap_content" 

android:id="@+id/phone" />  

 <TextView 

android:layout_width="fill_parent"  

android:textSize="22sp" 

android:layout_height="wrap_content" 

android:id="@+id/amount" /></LinearLayout>

public class MainActivity extends Activity {
    private ListView listView;
    private PersonService personService;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        personService = new PersonService(this);
        

        listView = (ListView) this.findViewById(R.id.listView);
        listView.setOnItemClickListener(new ItemClickListener());
        show2();
    }
    
    private final class ItemClickListener implements OnItemClickListener{
        public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
            ListView lView = (ListView)parent;
            /* 自定义适配器
            Person person = (Person) lView.getItemAtPosition(position);
            Toast.makeText(getApplicationContext(), person.getId().toString(), 1).show();*/
            
            Cursor cursor = (Cursor) lView.getItemAtPosition(position);
            int personid = cursor.getInt(cursor.getColumnIndex("_id"));
            Toast.makeText(getApplicationContext(), personid+ "", 1).show();
        }
    }
    
    
    //自定义适配器
    private void show3() {
        List<Person> persons = personService.getScrollData(0, 20);
        PersonAdapter adapter = new PersonAdapter(this, persons, R.layout.item);
        listView.setAdapter(adapter);
    }

    private void show2() {
        Cursor cursor = personService.getCursorScrollData(0, 20);
        //这个适配器的父类中说明了结果集必须含有_id字段：可以把表的主键改为_id，或者修改结果集使用别名的方式
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.item, cursor,
                new String[]{"name", "phone", "amount"}, new int[]{R.id.name, R.id.phone, R.id.amount});
        listView.setAdapter(adapter);
    }

    private void show() {
        List<Person> persons = personService.getScrollData(0, 20);
        List<HashMap<String, Object>> data = new ArrayList<HashMap<String,Object>>();
        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);
        
    }

}

public class PersonService {
    private DBOpenHelper dbOpenHelper;

    public PersonService(Context context) {
        this.dbOpenHelper = new DBOpenHelper(context);
    }
    
    public void payment(){
        SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
        db.beginTransaction();//开启事务
        try{
            db.execSQL("update person set amount=amount-10 where personid=1");
            db.execSQL("update person set amount=amount+10 where personid=2");
            db.setTransactionSuccessful();//设置事务的标志为True
        }finally{
            db.endTransaction();//结束事务,有两种情况：commit,rollback,
        //事务的提交或回滚是由事务的标志决定的,如果事务的标志为True，事务就会提交，否侧回滚,默认情况下事务的标志为False
        }
    }
    /**
     * 添加记录
     * @param person
     */
    public void save(Person person){
        SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
        db.execSQL("insert into person(name, phone, amount) values(?,?,?)",
                new Object[]{person.getName(), person.getPhone(), person.getAmount()});
    }
    /**
     * 删除记录
     * @param id 记录ID
     */
    public void delete(Integer id){
        SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
        db.execSQL("delete from person where personid=?", new Object[]{id});
    }
    /**
     * 更新记录
     * @param person
     */
    public void update(Person person){
        SQLiteDatabase db = dbOpenHelper.getWritableDatabase();
        db.execSQL("update person set name=?,phone=?,amount=? where personid=?",
                new Object[]{person.getName(), person.getPhone(),  person.getAmount(), person.getId()});
    }
    /**
     * 查询记录
     * @param id 记录ID
     * @return
     */
    public Person find(Integer id){
        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select * from person where personid=?", new String[]{id.toString()});
        if(cursor.moveToFirst()){
            int personid = cursor.getInt(cursor.getColumnIndex("personid"));
            int amount = cursor.getInt(cursor.getColumnIndex("amount"));
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String phone = cursor.getString(cursor.getColumnIndex("phone"));
            return new Person(personid, name, phone, amount);
        }
        cursor.close();
        return null;
    }

    /**
     * 分页获取记录
     * @param offset 跳过前面多少条记录
     * @param maxResult 每页获取多少条记录
     * @return
     */
    public List<Person> getScrollData(int offset, int maxResult){
        List<Person> persons = new ArrayList<Person>();
        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select * from person order by personid asc limit ?,?",
                new String[]{String.valueOf(offset), String.valueOf(maxResult)});
        while(cursor.moveToNext()){
            int personid = cursor.getInt(cursor.getColumnIndex("personid"));
            int amount = cursor.getInt(cursor.getColumnIndex("amount"));
            String name = cursor.getString(cursor.getColumnIndex("name"));
            String phone = cursor.getString(cursor.getColumnIndex("phone"));
            persons.add(new Person(personid, name, phone, amount));
        }
        cursor.close();
        return persons;
    }
    /**
     * 分页获取记录
     * @param offset 跳过前面多少条记录
     * @param maxResult 每页获取多少条记录
     * @return
     */
    public Cursor getCursorScrollData(int offset, int maxResult){
        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select personid as _id,name,phone,amount from person order by personid asc limit ?,?",
                new String[]{String.valueOf(offset), String.valueOf(maxResult)});
        return cursor;
    }

    
    /**
     * 获取记录总数
     * @return
     */
    public long getCount(){
        SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
        Cursor cursor = db.rawQuery("select count(*) from person", null);
        cursor.moveToFirst();
        long result = cursor.getLong(0);
        cursor.close();
        return result;
    }
}

public class PersonAdapter extends BaseAdapter {
	private List<Person> persons;//在绑定的数据
	private int resource;//绑定的条目界面
	private LayoutInflater inflater;
	
	public PersonAdapter(Context context, List<Person> persons, int resource) {
		this.persons = persons;
		this.resource = resource;
		inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
	}

	@Override
	public int getCount() {
		return persons.size();//数据总数
	}

	@Override
	public Object getItem(int position) {
		return persons.get(position);
	}

	@Override
	public long getItemId(int position) {
		return position;
	}

	@Override
	public View getView(int position, View convertView, ViewGroup parent) {
		TextView nameView = null;
		TextView phoneView = null;
		TextView amountView = null;
		if(convertView==null){
			convertView = inflater.inflate(resource, null);//生成条目界面对象
			nameView = (TextView) convertView.findViewById(R.id.name);
			phoneView = (TextView) convertView.findViewById(R.id.phone);
			amountView = (TextView) convertView.findViewById(R.id.amount);
			
			ViewCache cache = new ViewCache();
			cache.nameView = nameView;
			cache.phoneView = phoneView;
			cache.amountView = amountView;			
			convertView.setTag(cache);
		}else{
			ViewCache cache = (ViewCache) convertView.getTag();
			nameView = cache.nameView;
			phoneView = cache.phoneView;
			amountView = cache.amountView;
		}
		Person person = persons.get(position);
		//下面代码实现数据绑定
		nameView.setText(person.getName());
		phoneView.setText(person.getPhone());
		amountView.setText(person.getAmount().toString());
		
		return convertView;
	}
	
	private final class ViewCache{
		public TextView nameView;
		public TextView phoneView;
		public TextView amountView;
	}

}

ListView和Adapter adapter实现将不同类型的数据进行转换，那个接口就被listview调用

1、View，用于展示列表，通常是一个xml所指定的。大家都知道Android的界面基本上是由xml文件负责完成的，所以ListView的界面也理所应当的使用了xml定义。例如在ListView中经常用到的“android.R.layout.simple_list_item”等， 就是Android系统内部定义好的一个xml文件。

2、适配器，用来将不同的数据映射到View上。不同的数据对应不同的适配器，如BaseAdapter、ArrayAdapter、CursorAdapter、SimpleAdapter等， 他们能够将数组、指针指向的数据、Map等数据映射到View上。也正是由于适配器的存在，使得ListView的使用相当灵活，经过适配的处理后，在view看来所有的数据映射过来都是一样的。

3、数据，具体的来映射数据和资源，可以是字符串，图片等。通过适配器，这些数据将会被实现到ListView上。所有的数据和资源要显示到ListView上都通过适配器来完成。