Android使用SQLite數(shù)據(jù)庫(kù)的示例

SQLiteDatabase db=
SQLiteDatabase.openOrCreateDatabase(
"/data/data/" + getPackageName() + "/test.db",
 null);

public class MySQLiteHelper extends SQLiteOpenHelper{

public MySqliteHelper(Context context) {
  super(context, "mysqlite.db", null, 1);
  //傳入四個(gè)參數(shù)
  //第一個(gè)參數(shù)context 上下文對(duì)象
  //第二個(gè)參數(shù)mysqlite.db 數(shù)據(jù)庫(kù)名稱(文件名)
  //第三個(gè)參數(shù)一般為null
  //第四個(gè)參數(shù)數(shù)據(jù)庫(kù)版本號(hào)，這里寫1
}

@Override
public void onCreate(SQLiteDatabase db) {
  /* 數(shù)據(jù)庫(kù)創(chuàng)建的時(shí)候會(huì)回調(diào)此方法，可以用db對(duì)象執(zhí)行SQL語(yǔ)
   * 句，創(chuàng)建所需要的表
   */
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
//當(dāng)數(shù)據(jù)庫(kù)升級(jí)時(shí)調(diào)用此方法
}
}

SQLiteOpenHelper dbHelper = new MySqliteHelper(this);
SQLiteDatabase db = dbHelper.getWritableDatabase();

  private void createTable(SQLiteDatabase db){
    //SQL語(yǔ)句
    String sql = 
    "create table stutable(_id integer primary key autoincrement,name text,age integer)";
    db.execSQL(sql);
  }

  //SQLiteDatabase類中提供的方法
  public long insert(
     String table,//要操作表名 
     String nullColumnHack,//空列的默認(rèn)值 
     ContentValues values
//ContentValues封裝了列名稱和列值的Map
     ); 

  private void insertToTable(SQLiteDatabase db){
    ContentValues cv = new ContentValues();
    cv.put("name","wxq");
    cv.put("age",11);
    db.insert("stutable",null,cv); 
  }

  //SQLiteDatabase類中提供的方法
  public int delete(
      String table,//表名稱
      String whereClause,//刪除條件
      String[] whereArgs); //刪除條件值數(shù)組

  private void deleteToTable(SQLiteDatabase db){
    //刪除條件,這里以name為條件，也可以是age = ?
    String whereClasuse = "name = ?";
    //刪除條件參數(shù),
    String[] whereArgs = new String[]{"wxq"};
    //執(zhí)行刪除
    db.delete("stutable",whereClasuse,whereArgs);
  }

  //SQLiteDatabase類中提供的方法
  public int update(
  //表名稱
  String table,
  //和行列ContentValues鍵值對(duì)應(yīng)的key-value
  ContentValues values,
  //更新條件
  String whereClause,
  //更新條件數(shù)組
  String[] whereArgs
  );

  private void updateToTable(SQLiteDatabase db){
    //實(shí)例化ContentValues
    ContentValues cv= new ContentValues();
    cv.put("age",23);
    //更新條件
    String whereClause = "name = ?";
    //更新條件數(shù)組
    String[] whereArgs = new String[]{"wxq"};
    db.update("stutable",cv,whereClause,whereArgs);
  }

  public Cursor rawQuery(
  String sql,//查詢的SQL語(yǔ)句
  String[] selectionArgs//當(dāng)SQL語(yǔ)句中含有?,這里代表值
  );

  public void queryToTable(SQLiteDatabase db){
    String sql = "select * from stutable";//全查
    Cursor c = db.rawQuery(sql,null);//這里會(huì)返回一個(gè)Cursor(游標(biāo))對(duì)象
  }

public class HeroSqliteManager {
  private SQLiteOpenHelper dbHelper;
  private SQLiteDatabase db;
  private static HeroSqliteManager instance;

  private static final String TABLE_NAME = "hero";
  private static final String NAME_FIELD = "name";
  private static final String ICOID_FIELD = "icoId";
  private static final String ATTACK_FIELD = "attack";
  private static final String DEFENSE_FIELD = "defense";

  public static HeroSqliteManager getInstance() {
    if (instance == null) {
      synchronized (HeroSqliteManager.class) {
        if (instance == null) {
          instance = new HeroSqliteManager();
        }
      }
    }
    return instance;
  }

  private HeroSqliteManager() {
    dbHelper = new HeroSqliteHelper(HeroApplication.getContext());
    db = dbHelper.getWritableDatabase();
  }

  /**
   * 插入記錄
   * @param hero
   */
  public void insertData(Hero hero) {
    ContentValues cv = new ContentValues();
    cv.put(NAME_FIELD, hero.name);
    cv.put(ICOID_FIELD, hero.icoId);
    cv.put(ATTACK_FIELD, hero.attack);
    cv.put(DEFENSE_FIELD, hero.defense);
    db.insert(TABLE_NAME, null, cv);
  }

  /**
   * 刪除記錄
   * @param
   */
  public void deleteData(int id) {
    String whereClasuse = "_id = ?";
    String[] whereArgs = new String[]{String.valueOf(id)};
    db.delete(TABLE_NAME, whereClasuse, whereArgs);
  }

  /**
   * 修改記錄
   * @param hero
   */
  public void updateData(Hero hero) {
    ContentValues cv = new ContentValues();
    cv.put(NAME_FIELD, hero.name);
    cv.put(ICOID_FIELD, hero.icoId);
    cv.put(ATTACK_FIELD, hero.attack);
    cv.put(DEFENSE_FIELD, hero.defense);
    String whereClasuse = "_id = ?";
    String[] whereArgs = new String[]{String.valueOf(hero.id)};
    db.update(TABLE_NAME, cv, whereClasuse, whereArgs);
  }


  /**
   * 查詢所有的英雄
   * @return
   */
  public List<Hero> selectData() {
    List<Hero> heroList = new ArrayList<>();
    Cursor c = db.rawQuery("select * from " + TABLE_NAME, null);
    while (c.moveToNext()) {
      Hero hero = new Hero();
      hero.id = c.getInt(c.getColumnIndex("_id"));
      hero.name = c.getString(c.getColumnIndex(NAME_FIELD));
      hero.icoId = c.getInt(c.getColumnIndex(ICOID_FIELD));
      hero.attack = c.getInt(c.getColumnIndex(ATTACK_FIELD));
      hero.defense = c.getInt(c.getColumnIndex(DEFENSE_FIELD));
      heroList.add(hero);
    }
    c.close();
    return heroList;
  }

  /**
   * 按name查詢
   * @param name
   * @return
   */
  public Hero selectForName(String name) {
    Cursor c = db.rawQuery("select * from " + TABLE_NAME + " where name = ?", new String[]{name});
    Hero hero = null;
    if (c.moveToNext()) {
      hero = new Hero();
      hero.id = c.getInt(c.getColumnIndex("_id"));
      hero.name = c.getString(c.getColumnIndex(NAME_FIELD));
      hero.icoId = c.getInt(c.getColumnIndex(ICOID_FIELD));
      hero.attack = c.getInt(c.getColumnIndex(ATTACK_FIELD));
      hero.defense = c.getInt(c.getColumnIndex(DEFENSE_FIELD));
    }
    c.close();
    return hero;
  }

  public void destroy() {
//    if (db != null) {
//      db.close();
//    }
//    db = null;
  }
}