protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
SQLiteDatabase db = openOrCreateDatabase("test.db", Context.MODE_PRIVATE, null);
/*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 thread1 = 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();
这是我写的代码，请问一下线程中要使用onCreate里面的 SQLiteDatabase db 这个参数要怎么传 我现在的写法是错误的 让我把线程里面的db定义成final但是之后还是错的，请问这个要怎么传进去