SQLite 和共享首选项的优缺点[关闭]

SQLite 和共享首选项：选择合适的数据存储方式

java
// 创建SQLite数据库帮助类
public class DBHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "mydatabase.db";
    private static final int DATABASE_VERSION = 1;
    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表格的SQL语句
        String createTableSQL = "CREATE TABLE mytable (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)";
        // 执行SQL语句
        db.execSQL(createTableSQL);
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库时的操作
    }
}
// 在应用中使用SQLite数据库
DBHelper dbHelper = new DBHelper(context);
SQLiteDatabase db = dbHelper.getWritableDatabase();
// 插入数据
ContentValues values = new ContentValues();
values.put("name", "John Doe");
db.insert("mytable", null, values);
// 查询数据
Cursor cursor = db.query("mytable", null, null, null, null, null, null);
while (cursor.moveToNext()) {
    String name = cursor.getString(cursor.getColumnIndex("name"));
    // 处理查询结果
}
// 关闭数据库连接
dbHelper.close();

java
// 获取SharedPreferences对象
SharedPreferences preferences = PreferenceManager.getDefaultSharedPreferences(context);
// 写入数据
SharedPreferences.Editor editor = preferences.edit();
editor.putString("username", "JohnDoe");
editor.apply();
// 读取数据
String username = preferences.getString("username", "DefaultUsername");
// 使用数据
// ...