使用LIKE进行Android SQLiteDatabase查询

// 创建一个SQLiteOpenHelper对象
SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "database_name", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建数据库表
        db.execSQL("CREATE TABLE IF NOT EXISTS table_name (id INTEGER PRIMARY KEY, name TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库表
        db.execSQL("DROP TABLE IF EXISTS table_name");
        onCreate(db);
    }
};

// 获取可写的数据库对象
SQLiteDatabase db = dbHelper.getWritableDatabase();

// 使用LIKE进行查询
String query = "SELECT * FROM table_name WHERE name LIKE '%keyword%'";
Cursor cursor = db.rawQuery(query, null);

// 遍历查询结果
if (cursor.moveToFirst()) {
    do {
        int id = cursor.getInt(cursor.getColumnIndex("id"));
        String name = cursor.getString(cursor.getColumnIndex("name"));
        // 处理查询结果
    } while (cursor.moveToNext());
}

// 关闭游标和数据库连接
cursor.close();
db.close();