android 数据库

/*

* 数据库

* 

*/

 

//***数据库 - 创建/打开

 

SQLiteDatabase db =openOrCreateDatabase("MyDatabaseName", MODE_PRIVATE, null);

 

//***数据库 - 删除

 

boolean success = deleteDatabase("MyDatabaseName");

 

//***表 - 创建

 

db.execSQL("CREATE TABLE MyTableName (_id INTEGER PRIMARY KEY AUTOINCREMENT, YourColumnName TEXT);");

 

//***soAP表 - 删除

 

db.execSQL("DROP TABLE IF EXISTS MyTableName");

 

//***条目 - 插入

 

// Since SQL doesn't allow inserting a completely empty row, the second parameter of db.insert defines the column that will receive NULL if cv is empty

ContentValues cv=new ContentValues();

cv.put("YourColumnName", "YourColumnValue");

db.insert("MyTableName", "YourColumnName", cv);

 

//***条目 - 更新

 

ContentValues cv=new ContentValues();

cv.put("YourColumnName", "YourColumnValue");

db.update("MyTableName", cv, "_id=?", new String[]{"1"});

 

//***条目 - 删除

 

db.delete("MyTableName","_id=?", new String[]{"1"});

 

//***运行 SQL 查询

 

Cursor c=db.rawQuery(SQL_COMMAND, null);