Android使用SQLite數(shù)據(jù)庫的簡單實(shí)例

1、Android使用SQLite數(shù)據(jù)庫的簡單實(shí)例先畫個(gè)圖，了解下 Android下數(shù)據(jù)庫操作的簡單流程:1.首先，寫一個(gè)自己的數(shù)據(jù)庫操作幫助類，這個(gè)類繼承自 Android自帶的SQLiteOpenHelpe r.卜面例子是:package ;import ;import ;import ;import ;public class DBHelper extends SQLiteOpenHelper private final static String DB_NAME =;/數(shù)據(jù)庫名private final static int VERSION = 1;版本號(hào)/自帶的構(gòu)造方法public DB

2、Helper(Context context, String name, CursorFactory factory,int version) super(context, name, factory, version);/為了每次構(gòu)造時(shí)不用傳入dbNamem版本號(hào)，自己得新定義一個(gè)構(gòu)造方法public DBHelper(Context cxt)this(cxt, DB_NAME, null, VERSION);/調(diào)用上面的構(gòu)造方法/版本變更時(shí)public DBHelper(Context cxt,int version) this(cxt,DB_NAME,null,version);/當(dāng)數(shù)據(jù)

3、庫創(chuàng)立的時(shí)候調(diào)用public void onCreate(SQLiteDatabase db) String sql = create table student( +id integer primary key autoincrement, +name varchar(20), + age int)”;(sql);/版本更新時(shí)調(diào)用public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) String sql = update student .;/自己的 Update 操作(sql); package ;

4、import ;import ;import ;import ;public class StudentDao DBHelper helper = null;public StudentDao(Context cxt) helper = new DBHelper(cxt);/*當(dāng)Activity中調(diào)用此構(gòu)造方法，傳入一個(gè)版本號(hào)時(shí)，系統(tǒng)會(huì)在下一次調(diào)用數(shù)據(jù)庫時(shí)調(diào)用Helper中的onUpgrade()方法進(jìn)展更新param cxtparam version/public StudentDao(Context cxt, int version) helper = new DBHelper(cxt, version);/插入操作public void insertData(Student stu) String sql = insert into student (name,age)values(,);SQLiteDatabase db =();(sql, new Object , );/其它操作完成這些，其它操作就簡單了.&昵川田ffiffi國另外，數(shù)據(jù)庫文件放在這個(gè)