Android實(shí)現(xiàn)基于滑動(dòng)的SQLite數(shù)據(jù)分頁加載技術(shù)(附demo源碼下載)

更新時(shí)間：2016年07月05日 15:33:12 作者：水寒劍

這篇文章主要介紹了Android實(shí)現(xiàn)基于滑動(dòng)的SQLite數(shù)據(jù)分頁加載技術(shù),涉及Android針對SQLite數(shù)據(jù)的讀取及查詢結(jié)果的分頁顯示功能相關(guān)實(shí)現(xiàn)技巧,末尾還附帶demo源碼供讀者下載參考,需要的朋友可以參考下

本文實(shí)例講述了Android實(shí)現(xiàn)基于滑動(dòng)的SQLite數(shù)據(jù)分頁加載技術(shù)。分享給大家供大家參考，具體如下：

main.xml如下：

<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>

MainActivity.java如下：

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; //默認(rèn)在第一頁
 private static final int lineSize = 7; //每次顯示數(shù) 
 private int allRecorders = 0; //全部記錄數(shù)
 private int pageSize = 1; //默認(rèn)共一頁
 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);
  //創(chuàng)建一個(gè)角標(biāo)線性布局用來顯示"正在加載"
  loadLayout = new LinearLayout(this);
  loadLayout.setGravity(Gravity.CENTER);
  //定義一個(gè)文本顯示“正在加載”
  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();
 }
 /**
  * 讀取全部數(shù)據(jù)
  */
 public void showAllData(){
  service = new DatabaseService(this);
  allRecorders = service.getCount();
  //計(jì)算總頁數(shù)
  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; //統(tǒng)計(jì)是否到最后
 }
 @Override
 public void onScrollStateChanged(AbsListView view, int scorllState) {
  System.out.println("進(jìn)入滾動(dòng)界面了");
  //是否到最底部并且數(shù)據(jù)沒讀完
  if(lastItem == baseAdapter.getCount() 
    && currentPage < pageSize //不再滾動(dòng)
    && scorllState == OnScrollListener.SCROLL_STATE_IDLE){
   currentPage ++;
   //設(shè)置顯示位置
   listView.setSelection(lastItem);
   //增加數(shù)據(jù)
   appendDate(); 
  }
 }
 /**
  * 增加數(shù)據(jù)
  */
 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;
  }
 }
}

完整實(shí)例代碼點(diǎn)擊此處本站下載。