1 内存数据库存储
String createTableSQL = "CREATE TABLE [t_test] (" + "[id] INTEGER,"
+ "[name] VARCHAR(20),[memo] TEXT,"
+ "CONSTRAINT [sqlite_autoindex_t_test_1] PRIMARY KEY ([id]))";
SQLiteDatabase sqLiteDatabase = SQLiteDatabase.create(null);
sqLiteDatabase.execSQL(createTableSQL);
String insertSQL = "insert into t_test(id, name) values(?,?)";
sqLiteDatabase.execSQL(insertSQL, new Object[]
{ 1, "老毕" });
String selectSQL = "select name from t_test";
Cursor cursor = sqLiteDatabase.rawQuery(selectSQL, null);
cursor.moveToFirst();
Toast.makeText(this, cursor.getString(0) ,
Toast.LENGTH_LONG).show();
sqLiteDatabase.close();
2 物理文件数据库存储
String filename = android.os.Environment.getExternalStorageDirectory()
+ "/sdcard_test.db";
String createTableSQL = "CREATE TABLE [t_test] (" + "[id] INTEGER,"
+ "[name] VARCHAR(20),[memo] TEXT,"
+ "CONSTRAINT [sqlite_autoindex_t_test_1] PRIMARY KEY ([id]))";
File file = new File(filename);
if (file.exists())
{
file.delete();
}
SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(filename,
null);
database.execSQL(createTableSQL);
ContentValues contentValues = new ContentValues();
contentValues.put("id", 1);
contentValues.put("name", "Mike");
contentValues.put("memo", "Student");
database.insert("t_test", null, contentValues);
String insertSQL = "insert into t_test(id, name, memo) values(?,?,?)";
database.execSQL(insertSQL, new Object[]{2, "John", "��ʦ"});
String selectSQL = "select name, memo from t_test where name=?";
Cursor cursor = database.rawQuery(selectSQL, new String[]
{ "John" });
cursor.moveToFirst();
Toast.makeText(this, cursor.getString(0) + " " + cursor.getString(1),
Toast.LENGTH_LONG).show();
database.close();