Android Sqlite3数据库操作

android Sqlite adb 简单操作

# adb shell 

# cd /data/data/com.android.provider.settings/databases/

# sqlite3 settings.db //进入settings数据库

#  .table //显示settings数据库所有的表

# .schema //查看表结构

#  select * from global //查找global所有字段

#  select  * from global where name='bluetooth_on'; //查找blue_tooth_on字段值

# create table if not exists global(_id integer primary key autoincrement,name text,value text); //如果global表不存在，就创建

# insert into global(name,value) values('test','0'); //插入字段值test 为 0

# update global set value=1 where name='test; //更新字段值test为1

# drop table global //删除test表

# delete from  global where name='bluetooth_on'; //删除bluetooth_on字段

# .q //退出

 

 //1.创建或打开数据库

public SQLiteDatabase createDBorOpen(String DBname){

 

    SQLiteDatabase db;
    db = SQLiteDatabase.openOrCreateDatabase(DBname, null);
    return db;
  }

  //2.建表SQL语句 
  private void createTable(SQLiteDatabase db, String table){//表名:global
      
    String tab = String.format("create table if not exists %s(_id integer primary key autoincrement,name text,value text)",table);    
    db.execSQL(tab);   
  }  

  //3.插入一条字段
  private void insert(SQLiteDatabase db)
    String sql="insert into global(name,value) values('test','0');";
    db.execSQL(sql);   
  } 

  //4.更新字段中的值
  private void update(SQLiteDatabase db){   
     String sql = "update global set value=1 where name='test'";
    db.execSQL(sql);   
  } 

  //5、在数据库中查询某个字段的值
  private String query(SQLiteDatabase db,String table, String r_name){
    String name = null;
    String value = null;
    String search = String.format("select * from %s",table);
    Cursor cursor = db.rawQuery(search, null);
    while (cursor.moveToNext()) {
      int id = cursor.getInt(cursor.getColumnIndex("_id")); 
      name = cursor.getString(cursor.getColumnIndex("name"));
      value = cursor.getString(cursor.getColumnIndex("value"));
      Log.e("xxx-","id  " + id + "  name = " + name + "  value = "+ value + "\n");
      if(r_name.equals(name)){
return value;
      }
    }

    //cursor.close();
    //db.close();
    return null;
  }

 

   //6.删除global表

 

  private void drop(SQLiteDatabase db){ //删除表
      //删除表的SQL语句   
      String sql ="DROP TABLE global";   
      //执行SQL   
      db.execSQL(sql);   

 

    }