@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类型，之后出现这个错误 怎么解决
要么你写
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();
start()方法返回void，不能传给作为Thread型变量thread。
好比
void foo() { }
Object o = foo(); //当然错了。