Welcome 微信登录

首页 / 移动开发 / Android / Android实现简单的分批加载ListView

每次滑动至底端,从数据库中获取10条数据,并加载于ListView中
数据库

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;/*** 数据库的业务封装类*/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); }/*** 获取一定条目的数据* @param startIndex* 开始取数据的位置* @param num* 取多少条数据*/ 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;}/*** 添加数据库条目* @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; //每页加载数目 private static final int FINISH = 0;//数据加载完成 private List<Person> moreDatas;//每次加载的数据 private MyAdapter adapter; private PersonList personList ;//若数据较多,耗时较长,数据加载完成时,发送FINISH至handler,并通知ListView更新数据 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, "没有更多数据", Toast.LENGTH_SHORT).show(); } break;default: break; } }; };@Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); initView(); initData(); initEvent(); } /*** 为ListView添加滚动监听事件,但滚动至最后一行时,加载更多数据*/ 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("加载更多数据"); } } }@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); }/*** 在子线程中加载数据,避免主线程阻塞*/ private void initData() { new Thread() {public void run() {// 加载更多数据 moreDatas = personList.getMoreDatas(datas.size(), PERPAGE);datas.addAll(moreDatas);// 把一个容器的所有数据加进来 // 取数据完成,发消息通知取数据完成 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; }}} 
其他Person的JavaBean,以及布局文件,不在赘述
以上就是本文的全部内容,希望对大家的学习有所帮助。