如何創(chuàng)建數(shù)據(jù)庫

    1. 定義一個數(shù)據(jù)庫創(chuàng)建的幫助類 MyDataBaseOpenHelper extends SQLiteOpenHelper 
    2. 指定數(shù)據(jù)庫文件的名稱,數(shù)據(jù)庫的版本號.默認(rèn)的游標(biāo)工廠
    3. 通過helper得到一個可寫或者是可讀的數(shù)據(jù)庫,數(shù)據(jù)庫才會被創(chuàng)建
       helper.getWritableDatabase();

數(shù)據(jù)庫的增刪改查

• 增
  insert into student (name,phone) values ('張三','110')
• 刪
  delete from student where name='張三'
• 改
  update student set phone ='119' where name='張三'
• 查
  select * from student where name=?

數(shù)據(jù)庫事務(wù)

    beginTransaction();//開啟事務(wù)
    try{
        setTransactionSuccessful();//設(shè)置事務(wù)執(zhí)行成功
    }finally{
        endTransaction();//結(jié)束事務(wù)
    }