package com.example.listviewbatchloading;  import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteDatabase.CursorFactory; import android.database.sqlite.SQLiteOpenHelper;  public class PersonDb extends SQLiteOpenHelper {    public PersonDb(Context context) {     super(context, "creature", null, 1);     // TODO Auto-generated constructor stub   }    @Override   public void onCreate(SQLiteDatabase db) {     // TODO Auto-generated method stub     db.execSQL("create table people(_id integer primary key autoincrement,name char,number char)");   }    @Override   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {     // TODO Auto-generated method stub     db.execSQL("drop table people");     onCreate(db);   }  } 

package com.example.listviewbatchloading;  /**  * 數(shù)據(jù)庫(kù)的業(yè)務(wù)封裝類  */  import java.util.ArrayList; import java.util.List;  import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase;  public class PersonList {      PersonDb personDb;      public PersonList(Context context){     this.personDb = new PersonDb(context);   }      /**    *   獲取一定條目的數(shù)據(jù)    * @param startIndex    *   開(kāi)始取數(shù)據(jù)的位置    * @param num    *   取多少條數(shù)據(jù)    */   public List<Person> getMoreDatas(int startIndex,int num){          List<Person> list = new ArrayList<Person>();     SQLiteDatabase db = personDb.getWritableDatabase();     Cursor cursor = db.rawQuery("select name,number from people order by _id desc limit ?,?",         new String[]{startIndex + "",num + ""});          while(cursor.moveToNext()){       Person person = new Person();       person.setName(cursor.getString(cursor.getColumnIndex("name")));       person.setNumber(cursor.getString(cursor.getColumnIndex("number")));       list.add(person);     }          cursor.close();     db.close();               return list;        }      /**    *   添加數(shù)據(jù)庫(kù)條目    * @param name    * @param number    */   public void add(String name,String number){          SQLiteDatabase db = personDb.getWritableDatabase();          ContentValues cv = new ContentValues();     cv.put("name", name);     cv.put("number", number);          db.insert("people", null, cv);     db.close();   }    } 

package com.example.listviewbatchloading;  import java.util.ArrayList; import java.util.List;  import android.app.Activity; import android.os.Bundle; import android.os.Handler; import android.os.Message; import android.view.View; import android.view.ViewGroup; import android.widget.AbsListView; import android.widget.AbsListView.OnScrollListener; import android.widget.BaseAdapter; import android.widget.ListView; import android.widget.TextView; import android.widget.Toast;  public class MainActivity extends Activity {      private ListView lv ;   private List<Person> datas = new ArrayList<Person>();   private static int PERPAGE = 10; //每頁(yè)加載數(shù)目   private static final int FINISH = 0;//數(shù)據(jù)加載完成   private List<Person> moreDatas;//每次加載的數(shù)據(jù)   private MyAdapter adapter;   private PersonList personList ;      //若數(shù)據(jù)較多，耗時(shí)較長(zhǎng)，數(shù)據(jù)加載完成時(shí)，發(fā)送FINISH至handler，并通知ListView更新數(shù)據(jù)   private Handler handler = new Handler(){     public void handleMessage(android.os.Message msg) {              switch (msg.what) {       case FINISH:         if (moreDatas.size() != 0) {           System.out.println(moreDatas.toString());           adapter.notifyDataSetChanged();         }else {           Toast.makeText(MainActivity.this, "沒(méi)有更多數(shù)據(jù)", Toast.LENGTH_SHORT).show();         }         break;        default:         break;       }                   };   };      @Override   protected void onCreate(Bundle savedInstanceState) {     super.onCreate(savedInstanceState);     setContentView(R.layout.activity_main);     initView();     initData();     initEvent();   }   /**    *   為L(zhǎng)istView添加滾動(dòng)監(jiān)聽(tīng)事件，但滾動(dòng)至最后一行時(shí)，加載更多數(shù)據(jù)    */   private void initEvent() {     lv.setOnScrollListener(new OnScrollListener() {              @Override       public void onScrollStateChanged(AbsListView view, int scrollState) {         // TODO Auto-generated method stub         if (scrollState == OnScrollListener.SCROLL_STATE_IDLE) {           int lastVisiblePosition = lv.getLastVisiblePosition();           if (lastVisiblePosition == datas.size() - 1) {             initData();             System.out.println("加載更多數(shù)據(jù)");           }         }       }              @Override       public void onScroll(AbsListView view, int firstVisibleItem, int visibleItemCount, int totalItemCount) {         // TODO Auto-generated method stub                }     });   }    private void initView() {          setContentView(R.layout.activity_main);          lv = (ListView) findViewById(R.id.lv);     personList = new PersonList(getApplicationContext());     adapter = new MyAdapter();     lv.setAdapter(adapter);   }      /**    * 在子線程中加載數(shù)據(jù)，避免主線程阻塞    */   private void initData() {     new Thread() {        public void run() {          // 加載更多數(shù)據(jù)         moreDatas = personList.getMoreDatas(datas.size(), PERPAGE);          datas.addAll(moreDatas);// 把一個(gè)容器的所有數(shù)據(jù)加進(jìn)來(lái)         // 取數(shù)據(jù)完成，發(fā)消息通知取數(shù)據(jù)完成         handler.obtainMessage(FINISH).sendToTarget();        };     }.start();   }      private class ItemView{     private TextView tv_name;     private TextView tv_num;   }      /**    *   ListView的適配器    * @author lian    *    */   private class MyAdapter extends BaseAdapter{      @Override     public int getCount() {       // TODO Auto-generated method stub       return datas.size();     }      @Override     public Object getItem(int position) {       // TODO Auto-generated method stub       return null;     }      @Override     public long getItemId(int position) {       // TODO Auto-generated method stub       return 0;     }      @Override     public View getView(int position, View convertView, ViewGroup parent) {              ItemView itemView = null;       if (convertView == null) {         itemView = new ItemView();         convertView = View.inflate(getApplicationContext(), R.layout.item_lv, null);         itemView.tv_name = (TextView) convertView.findViewById(R.id.tv_name);         itemView.tv_num = (TextView) convertView.findViewById(R.id.tv_num);         convertView.setTag(itemView);       }else {         itemView = (ItemView) convertView.getTag();       }              Person person = datas.get(position);       itemView.tv_name.setText(person.getName());       itemView.tv_num.setText(person.getNumber());              return convertView;     }        }    }