Android sqlite 操作

shining2015

今天开始写博客，写sqlite的基本应用的两个类，包含了基本的CRUD和分页操作。废话不说，代码能直接拷用。参照黎活明老师的讲解
 
 
public class dataBaseHelper extends SQLiteOpenHelper {
 private static final String DBNAME = "shining"; //数据库名称
  private static final int VERSION = 1; //数据库版本
public dataBaseHelper(Context context) {
super(context, DBNAME, null, VERSION);
// TODO Auto-generated constructor stub
}
 
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
//好友:id,name,age,phone
db.execSQL("CREATE TABLE IF NOT EXISTS friends(id integer primary key autoincrement, name varchar(20), age INTEGER,phone varchar(20))");
}
 
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
   db.execSQL("DROP TABLE IF EXISTS friends");
        onCreate(db);
}
 
}