Android sqlite 操作
今天开始写博客，写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);
}
}
页:
[1]