Android SQLite动态插入排序(ASD或DESC)，可能吗？

// 创建数据库和表
SQLiteDatabase db = openOrCreateDatabase("mydatabase.db", MODE_PRIVATE, null);
db.execSQL("CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY, name TEXT)");

// 查询已排序的数据集
Cursor cursor = db.rawQuery("SELECT * FROM mytable ORDER BY name ASC", null);

// 插入新数据
String newName = "John";
if (cursor.moveToFirst()) {
    do {
        String currentName = cursor.getString(cursor.getColumnIndex("name"));
        if (newName.compareTo(currentName) < 0) {
            ContentValues values = new ContentValues();
            values.put("name", newName);
            db.insert("mytable", null, values);
            break;
        }
    } while (cursor.moveToNext());
}
cursor.close();
db.close();