安卓 Error:(65, 17) 错误: 不兼容的类型: void无法转换为Thread

Question

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    SQLiteDatabase db = openOrCreateDatabase("test.db", Context.MODE_PRIVATE, null);
    db.execSQL("DROP TABLE IF EXISTS person");

    db.execSQL("CREATE TABLE person (_id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR, age SMALLINT)");

    Person person = new Person();
    person.name = "john";
    person.age = 30;;
    db.execSQL("INSERT INTO person VALUES (NULL, ?, ?)", new Object[]{person.name, person.age});

    person.name = "david";
    person.age = 33;

    ContentValues cv = new ContentValues();
    cv.put("name", person.name);
    cv.put("age", person.age);

    person.name = "dasdd";
    person.age = 33;

    ContentValues cv1 = new ContentValues();
    cv1.put("name", person.name);
    cv1.put("age", person.age);
    person.name = "dasdd";
    person.age = 88;
    ContentValues cv2 = new ContentValues();
    cv2.put("name", person.name);
    cv2.put("age", person.age);
    db.insert("person", null, cv);
    db.insert("person", null, cv1);
    db.insert("person", null, cv2);
    Thread thread = new Thread(new Runnable() {
        @Override
        public void run() {
            Cursor c = db.rawQuery("SELECT * FROM person WHERE age >= ?", new String[]{"33"});
            while (c.moveToNext()) {
                int _id = c.getInt(c.getColumnIndex("_id"));
                String name = c.getString(c.getColumnIndex("name"));
                int age = c.getInt(c.getColumnIndex("age"));
                Log.i("db", "_id=>" + _id + ", name=>" + name + ", age=>" + age);
            }
        }
    }).start();

要我把db 转为final类型，之后出现这个错误 怎么解决

Answer 1

 要么你写

Thread thread = new Thread(new Runnable() {
        @Override
        public void run() {
            Cursor c = db.rawQuery("SELECT * FROM person WHERE age >= ?", new String[]{"33"});
            while (c.moveToNext()) {
                int _id = c.getInt(c.getColumnIndex("_id"));
                String name = c.getString(c.getColumnIndex("name"));
                int age = c.getInt(c.getColumnIndex("age"));
                Log.i("db", "_id=>" + _id + ", name=>" + name + ", age=>" + age);
            }
        }
    });
        thread.start();

        要么你写
        new Thread(new Runnable() {
        @Override
        public void run() {
            Cursor c = db.rawQuery("SELECT * FROM person WHERE age >= ?", new String[]{"33"});
            while (c.moveToNext()) {
                int _id = c.getInt(c.getColumnIndex("_id"));
                String name = c.getString(c.getColumnIndex("name"));
                int age = c.getInt(c.getColumnIndex("age"));
                Log.i("db", "_id=>" + _id + ", name=>" + name + ", age=>" + age);
            }
        }
    }).start();