Android实现基于滑动的SQLite数据分页加载技术(附demo源码下载)

<menu xmlns:android="http://schemas.android.com/apk/res/android" >
 <item
 android:id="@+id/action_settings"
 android:orderInCategory="100"
 android:showAsAction="never"
 android:title="@string/action_settings"/>
</menu>

package com.example.testscrollsqlite;
import java.util.ArrayList;
import android.app.ActionBar.LayoutParams;
import android.app.Activity;
import android.os.Bundle;
import android.view.Gravity;
import android.view.Menu;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AbsListView;
import android.widget.AbsListView.OnScrollListener;
import android.widget.Adapter;
import android.widget.BaseAdapter;
import android.widget.LinearLayout;
import android.widget.ListView;
import android.widget.TextView;
public class MainActivity extends Activity implements OnScrollListener{
 private TextView loadInfo;
 private ListView listView;
 private LinearLayout loadLayout;
 private ArrayList<String> items;
 private DatabaseService service;
 private int currentPage = 1; //默认在第一页
 private static final int lineSize = 7; //每次显示数 
 private int allRecorders = 0; //全部记录数
 private int pageSize = 1; //默认共一页
 private int lastItem;
 private Aleph0 baseAdapter;
 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  listView = (ListView) findViewById(R.id.listview);
  //创建一个角标线性布局用来显示"正在加载"
  loadLayout = new LinearLayout(this);
  loadLayout.setGravity(Gravity.CENTER);
  //定义一个文本显示“正在加载”
  loadInfo = new TextView(this); 
  loadInfo.setText("正在加载...");
  loadInfo.setGravity(Gravity.CENTER);
  //增加组件 
  loadLayout.addView(loadInfo, new LayoutParams(
    LinearLayout.LayoutParams.MATCH_PARENT, LinearLayout.LayoutParams.WRAP_CONTENT));
  //增加到listView底部
  listView.addFooterView(loadLayout);
  listView.setOnScrollListener(this);
  showAllData();
 }
 /**
  * 读取全部数据
  */
 public void showAllData(){
  service = new DatabaseService(this);
  allRecorders = service.getCount();
  //计算总页数
  pageSize = (allRecorders + lineSize -1) / lineSize; 
  System.out.println("allRecorders = " + allRecorders);
  System.out.println("pageSize = " + pageSize);
  items = service.getAllItems(currentPage, lineSize);
  for(int i=0; i<items.size(); i++){
   System.out.println(items.get(i));
  }
  baseAdapter = new Aleph0();
  listView.setAdapter(baseAdapter);
 }
 @Override
 public void onScroll(AbsListView view, int firstVisible, int visibleCount,
   int totalCount) {
  lastItem = firstVisible + visibleCount - 1; //统计是否到最后
 }
 @Override
 public void onScrollStateChanged(AbsListView view, int scorllState) {
  System.out.println("进入滚动界面了");
  //是否到最底部并且数据没读完
  if(lastItem == baseAdapter.getCount() 
    && currentPage < pageSize //不再滚动
    && scorllState == OnScrollListener.SCROLL_STATE_IDLE){
   currentPage ++;
   //设置显示位置
   listView.setSelection(lastItem);
   //增加数据
   appendDate(); 
  }
 }
 /**
  * 增加数据
  */
 private void appendDate(){
  ArrayList<String> additems = service.getAllItems(currentPage, lineSize);
  baseAdapter.setCount(baseAdapter.getCount() + additems.size());
  //判断，如果到了最末尾则去掉“正在加载”
  if(allRecorders == baseAdapter.getCount()){
   listView.removeFooterView(loadLayout);
  }
  items.addAll(additems);
  //通知记录改变
  baseAdapter.notifyDataSetChanged();
 }
 class Aleph0 extends BaseAdapter {
  int count = lineSize; /* starting amount */
  public int getCount() {
   return count;
  } 
  public void setCount(int count){
   this.count = count;
  }
  public Object getItem(int pos) {
   return pos;
  }
  public long getItemId(int pos) {
   return pos;
  }
  public View getView(int pos, View v, ViewGroup p) {
   TextView view = new TextView(MainActivity.this);
   view.setTextSize(60);
   if(items != null){
    view.setText(items.get(pos));
   }else{
    view.setText(pos);
   }
   return view;
  }
 }
}