先进行简单的数据操作.然后在数据库上面做分页查询的操作,也就是listview分页.看代码
MySQLiteOpenHelper类,继承SQLiteOpenHelper类,是android中操作数据库的辅助类
package zuoyeSQLlite.hall;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class MySQLiteOpenHelper extends SQLiteOpenHelper {
private static final int dataversion=1;
private String TableName="";
/**
* context当前的上下问,DataName数据库名称
*factory游标工厂,version数据库版本,TableName 要创建的表名
*/
public MySQLiteOpenHelper(Context context, String DataName,
CursorFactory factory, int version,String TableName)
{
super(context, DataName, factory, version);
this.TableName=TableName;
}
public MySQLiteOpenHelper(Context context,String DataName,int version,String TableName)
{
this(context, DataName, null, version,TableName);
// TODO Auto-generated constructor stub
}
public MySQLiteOpenHelper(Context context,String DataName,String TableName)
{
this(context, DataName, dataversion,TableName);
// TODO Auto-generated constructor stub
}
//onCreate方法只有在数据库被创建的时候触发
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql="create table "+TableName+"(_id integer primary key,id text,name text,age text);";
db.execSQL(sql);
System.out.println("数据库被创建");
}
//数据库被打开的时候触发
@Override
public void onOpen(SQLiteDatabase db) {
// TODO Auto-generated method stub
super.onOpen(db);
System.out.println("数据库被打开");
}
//数据库本版更新的时候触发
@Override
publ