android Sqlite 分页 示例源码(入门级)

【实例截图】

【核心代码】

package com.android.service;

import java.util.ArrayList;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.android.database.DBHelper;
/**
 * 
 * @author shangzhenxiang
 *
 */
public class DatabaseService {

	private Context mContext;
	private DBHelper dbHelper;
	
	public DatabaseService(Context context) {
		// TODO Auto-generated constructor stub
		mContext = context;
		dbHelper = new DBHelper(mContext);
	}
	
	//添加
	public void insert(String title) {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "insert into database(title) values(?)";
		db.execSQL(sql, new String[]{title});
	}
	
	//删除
	public void delete(String title) {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "delete from database where title = ?";
		db.execSQL(sql, new String[]{title});
	}
	
	//查找
	public ArrayList<String> find(int id) {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "select * from database where _id = ? ";
		Cursor c = db.rawQuery(sql, new String[]{String.valueOf(id)});
		ArrayList<String> titles = new ArrayList<String>();
		if(c.moveToNext()) {
			String title =c.getString(c.getColumnIndexOrThrow(DBHelper.FIELD_TITLE));
			titles.add(title);
			return titles;
		}
		//不用忘记关闭Cursor。
		c.close();
		return null;
	}
	
	//更新
	public void upDate(int id, String title) {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "update database set title =? where _id = ?";
		db.execSQL(sql, new String[]{String.valueOf(title), String.valueOf(id)});
	}
	
	//查询记录的总数
	public long getCount() {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "select count(*) from database";
		Cursor c = db.rawQuery(sql, null);
		c.moveToFirst();
		long length = c.getLong(0);
		c.close();
		return length;
	}
	
	/**
	 * 拿到所有的记录条数
	 * @param firstResult 从第几条数据开始查询。
	 * @param maxResult   每页显示多少条记录。
	 * @return   当前页的记录
	 */
	public Cursor getAllItems(int firstResult, int maxResult) {
		SQLiteDatabase db = dbHelper.getWritableDatabase();
		String sql = "select * from database limit ?,?";
		Cursor mCursor = db.rawQuery(sql, new String[]{String.valueOf(firstResult), String.valueOf(maxResult)});
		return mCursor;
	}
}