Android ListView就是可以显示一行行Item的控件,有时候数据非常多,通常需要分页显示,但为了减少用户的输入,我们可以动态更新ListView,把下一页要显示的数据的添加到当前ListView中。
先看看效果:
需要注意的是程序在什么时候去更新数据,listVIew的setOnScrollListener监听是否滚到了最后一条记录。
取到的数据加到list中,最后记得调用adapter的notifyDataSetChanged,通知listview改变。
主文件:
import java.util.ArrayList;
import java.util.List;
import android.app.Activity;
import android.os.AsyncTask;
import android.os.Bundle;
import android.widget.AbsListView;
import android.widget.AbsListView.OnScrollListener;
import android.widget.ListView;
import android.widget.Toast;
public class ListViewActivity extends Activity {
private ListView listView;
// 定义适配器
private ListItemAdapter listadpter;
// 定义每一页显示行数
private int VIEW_COUNT = 20;
// 定义的页数
private int index = 0;
// 当前页
private int currentPage = 1;
// 所以数据的条数
private int totalCount;
// 每次取的数据,只要最后一次可能不一样。
private int maxResult;
// 泛型集合ArrayList
private ArrayList arrayList = new ArrayList();
// 数据操作的dao类
StudentsDAO dao = new StudentsDAO(ListViewActivity.this);
// 实体bean
Students students = new Students();
// 标记:上次的ID
private boolean isUpdating = false;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
// 初始化界面
initView();
// 插入100条记录。
dao.insert();
totalCount = dao.getCount();
maxResult = getMaxResult();
// 调用dao里面的selectAll()方法
arrayList = dao.getAllItems(index, maxResult);
// 实例化适配器
System.out.println("arrlist-->" + arrayList.size());
listadpter = new ListItemAdapter(ListViewActivity.this, arrayList);
// 填充适配器
listView.setAdapter(listadpter);
listView.setOnScrollListener(new OnScrollListener() {
@Override
public void onScrollStateChanged(AbsListView view, int scrollState) {
}
@Override
public void onScroll(AbsListView view, int firstVisibleItem,
int visibleItemCount, int totalItemCount) {
if (firstVisibleItem + visibleItemCount == totalItemCount
&& !isUpdating) {
if (totalItemCount < totalcount)="" {="" 防止最后一次取数据进入死循环。="" toast.maketext(listviewactivity.this,="" "正在取第"="" +="" (++currentpage)="" +="" "的数据",="" toast.length_long).show();="" asyncupdatedatastask="" asyncupdateweibodatastask="new" asyncupdatedatastask();="" asyncupdateweibodatastask.execute();="" }="" system.out.println("begin="" update-------------");="" }="" }="" });="" }="" 初始化界面方法="" private="" void="" initview()="" {="" todo="" auto-generated="" method="" stub="" listview="(ListView)" findviewbyid(r.id.list);="" }="" class="" asyncupdatedatastask="" extends="">> {
@Override
protected List doInBackground(Void... params) {
// TODO Auto-generated method stub
isUpdating = true;
index += VIEW_COUNT;
List list = new ArrayList();
list = dao.getAllItems(index, maxResult);
return list;
}
@Override
protected void onPostExecute(List result) {
// TODO Auto-generated method stub
super.onPostExecute(result);
arrayList.addAll(result);
listadpter.notifyDataSetChanged();
isUpdating = false;
System.out.println("end update--------------");
}
}
private int getMaxResult() {
int totalPage = (totalCount + VIEW_COUNT - 1) / VIEW_COUNT;
return totalCount - (totalPage - 1) * VIEW_COUNT;
}
}
数据库Dao文件:
package com.shao.list;
import java.util.ArrayList;
import java.util.Random;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class StudentsDAO extends SQLiteOpenHelper {
private final static String AUDIODATABASE_NAME = "student.db";
private final static String TABLE = "student";
private final static String COLUM_ID = "id";
private final static String COLUM_NAME = "name";
private final static String COLUM_AGE = "age";
private final static int DATABASE_VERSION = 1;
private long row;
private ArrayList arrayList;
public StudentsDAO(Context context) {
super(context, AUDIODATABASE_NAME, null, DATABASE_VERSION);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "CREATE TABLE " + TABLE + " (" + COLUM_ID
+ " INTEGER primary key autoincrement, " + " " + COLUM_NAME
+ " text, " + " " + COLUM_AGE + " int)";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
String sql = "DROP TABLE IF EXISTS " + TABLE;
db.execSQL(sql);
}
public long insert() {
SQLiteDatabase db = getWritableDatabase();
ContentValues cv = new ContentValues();
Random random = new Random();
for (int i = 1; i <= 100;="" i++)="" {="" cv.put(colum_id,="" i);="" cv.put(colum_name,="" "name"="" +="" string.valueof(i));="" cv.put(colum_age,="" random.nextint(100));="" row="db.insert(TABLE," null,="" cv);="" }="" db.close();="" return="" row;="" }="" 查询记录的总数="" public="" int="" getcount()="" {="" sqlitedatabase="" db="getWritableDatabase();" string="" sql="select count(*) from +=" table=" +=" ";="" cursor="" c="db.rawQuery(sql," null);="" c.movetofirst();="" int="" length="c.getInt(0);" c.close();="" db.close();="" system.out.println("length--="">"+length);
return length;
}
public ArrayList getAllItems(int firstResult, int maxResult) {
arrayList = new ArrayList();
SQLiteDatabase db = getWritableDatabase();
String sql = "select * from + TABLE + limit ?,?";
Cursor cursor = db.rawQuery(
sql,
new String[] { String.valueOf(firstResult),
String.valueOf(maxResult) });
if (cursor != null && cursor.getCount() > 0) {
cursor.moveToFirst();
}
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
Students students = new Students();
students.setId(cursor.getInt(0));
students.setName(cursor.getString(1));
students.setAge(cursor.getInt(2));
arrayList.add(students);
}
cursor.close();
db.close();
return arrayList;
}
public ArrayList selectAll() {
arrayList = new ArrayList();
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.query(TABLE, null, null, null, null, null, null);
if (cursor != null && cursor.getCount() > 0) {
cursor.moveToFirst();
}
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
Students students = new Students();
students.setId(cursor.getInt(0));
students.setName(cursor.getString(1));
students.setAge(cursor.getInt(2));
arrayList.add(students);
}
cursor.close();
db.close();
return arrayList;
}
}