如何使用SQLite在安卓中获取表格中的联系人？

// 创建SQLite数据库
SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "contacts.db", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建联系人表格
        String createTableQuery = "CREATE TABLE contacts (id INTEGER PRIMARY KEY, name TEXT, phone TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 数据库升级时的操作
    }
};

// 获取可读的数据库实例
SQLiteDatabase db = dbHelper.getReadableDatabase();

// 查询联系人数据
String[] projection = {"name", "phone"};
Cursor cursor = db.query("contacts", projection, null, null, null, null, null);

// 遍历查询结果
while (cursor.moveToNext()) {
    String name = cursor.getString(cursor.getColumnIndexOrThrow("name"));
    String phone = cursor.getString(cursor.getColumnIndexOrThrow("phone"));
    // 处理联系人数据
}

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