使用ViewFlipper在滑动视图中显示数据库中的图像

// 创建数据库表
public class DatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "image.db";
    private static final int DATABASE_VERSION = 1;
    private static final String TABLE_NAME = "image";
    private static final String COLUMN_ID = "id";
    private static final String COLUMN_NAME = "name";
    private static final String COLUMN_PATH = "path";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String createTableQuery = "CREATE TABLE " + TABLE_NAME + " (" +
                COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_NAME + " TEXT, " +
                COLUMN_PATH + " TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
        onCreate(db);
    }
}

// 在Activity中加载图像数据并显示
public class MainActivity extends AppCompatActivity {
    private ViewFlipper viewFlipper;
    private DatabaseHelper databaseHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        viewFlipper = findViewById(R.id.view_flipper);
        databaseHelper = new DatabaseHelper(this);

        // 获取数据库中的图像数据
        SQLiteDatabase db = databaseHelper.getReadableDatabase();
        Cursor cursor = db.query(DatabaseHelper.TABLE_NAME, null, null, null, null, null, null);

        // 遍历图像数据并加载到ImageView中
        while (cursor.moveToNext()) {
            String imagePath = cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_PATH));
            ImageView imageView = new ImageView(this);
            imageView.setImageURI(Uri.parse(imagePath));
            viewFlipper.addView(imageView);
        }

        cursor.close();
        db.close();

        // 设置切换时间间隔并开始自动切换
        viewFlipper.setFlipInterval(3000);
        viewFlipper.startFlipping();
    }
}