1、在ListView里显示数据

//自定义适配器
    private void show2() {
        List<Person> persons=service.getScrollData(0, 20);//需要绑定的数据,getScrollData代码在下方
PersonAdapter adapter=new PersonAdapter(getApplicationContext(), persons, R.layout.item); listView.setAdapter(adapter); }

2、getScrollData()代码

/**
     * 分页获取记录
     * @param offset 跳过前面多少条记录
     * @param maxResult 每页显示多少条记录
     * @return
     */
    public List<Person> getScrollData(int offset,int maxResult){
        SQLiteDatabase db=dbOpenHelper.getReadableDatabase();
        List<Person> persons=new ArrayList<Person>();
        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"));
            String name=cursor.getString(cursor.getColumnIndex("name"));
            String phone=cursor.getString(cursor.getColumnIndex("phone"));
            int amount=cursor.getInt(cursor.getColumnIndex("amount"));
            persons.add(new Person(personid, name, phone,amount));
        }
        cursor.close();
        return persons;
    }

3、一条数据单击事件

protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        service=new PersonService(this);
        listView=(ListView)this.findViewById(R.id.listview);
        show();
        listView.setOnItemClickListener(new ItemClickListener());
        
    }
    
    private final class ItemClickListener implements OnItemClickListener{

        @Override
        public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
                long arg3) {
            ListView listView=(ListView)arg0;
            //自定义适配器
            Person person=(Person)listView.getItemAtPosition(arg2);
            Toast.makeText(getApplicationContext(), person.getName(), 2).show();
                    
        }
        
    }