Android实现基于滑动的SQLite数据分页加载技术(附demo源码下载)
作者:水寒剑 时间:2022-04-21 03:42:02
本文实例讲述了Android实现基于滑动的SQLite数据分页加载技术。分享给大家供大家参考,具体如下:
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; //默认在第一页
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;
}
}
}
完整实例代码点击此处本站下载。
希望本文所述对大家Android程序设计有所帮助。
标签:Android,SQLite,分页
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
C#模拟实现QQ窗体功能
2021-07-17 02:49:11
![](https://img.aspxhome.com/file/2023/6/77236_0s.png)
springboot自定义Starter过程解析
2023-07-24 22:24:55
java实现简单银行家算法
2022-01-31 23:33:19
![](https://img.aspxhome.com/file/2023/7/63167_0s.jpg)
java基础之数组常用操作总结(必看篇)
2022-12-09 03:32:17
![](https://img.aspxhome.com/file/2023/0/88160_0s.png)
Android Beam 文件传输失败分析与解决方法
2023-03-16 18:15:27
![](https://img.aspxhome.com/file/2023/4/113294_0s.png)
Spring整合Quartz开发代码实例
2022-03-12 16:37:26
![](https://img.aspxhome.com/file/2023/1/80861_0s.png)
Android实现九宫格拼图游戏
2021-06-11 09:41:13
![](https://img.aspxhome.com/file/2023/4/95964_0s.png)
解决Android平台中应用程序OOM异常的方法
2023-07-29 09:45:17
Android使用多线程进行网络聊天室通信
2022-05-11 18:56:36
![](https://img.aspxhome.com/file/2023/2/123262_0s.png)
MyBatis-Plus代码生成器的使用详解
2022-09-04 23:14:40
![](https://img.aspxhome.com/file/2023/4/85824_0s.png)
Android超清晰6.0权限申请AndPermission
2023-08-05 10:52:26
Java 数组交集的实现代码
2022-01-19 09:09:38
Java详细讲解堆排序与时间复杂度的概念
2023-10-20 02:00:11
![](https://img.aspxhome.com/file/2023/7/58597_0s.png)
Java集合类的组织结构和继承、实现关系详解
2023-03-09 10:48:50
java与c#的语法区别详细介绍
2022-05-02 14:01:10
两路归并的数组与链表的实现方法
2021-10-28 04:32:15
java中javamail收发邮件实现方法
2022-12-15 02:03:03
![](https://img.aspxhome.com/file/2023/4/68714_0s.png)
Android实现美团外卖底部导航栏动画
2022-09-21 20:09:13
![](https://img.aspxhome.com/file/2023/9/98679_0s.gif)
SpringBoot MongoDB与MongoDB GridFS基本使用
2023-07-31 06:26:47
![](https://img.aspxhome.com/file/2023/7/77997_0s.png)
C#使用Matrix执行缩放的方法
2022-05-03 15:46:58