sqlite3: 查询事例

sqlite3: 查询例子

public Person Find(Integer i) {SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cs =db.rawQuery("select * from person where Id=?", new String[]{i.toString()});int personId;String personName;int personAge;while(cs.moveToFirst()){personId =cs.getInt(cs.getColumnIndex("Id"));personName = cs.getString(cs.getColumnIndex("Name"));personAge = cs.getInt(cs.getColumnIndex("Age"));return new Person(personId,personName,personAge);}return null;}