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;
}