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

<menu xmlns:android="http://scheR_664_11845@as.android.com/apk/res/android" >
 <item
 android:id="@+id/action_setTings"
 android:orderInCategory="100"
 android:showAsAction="never"
 android@R_715_6964@="@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 @R_653_10586@lCount) {
  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;
  }
 }
}