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;Stri.
·
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;
}
汇聚全球AI编程工具，助力开发者即刻编程。
更多推荐
0
0- 0
已为社区贡献1条内容
所有评论(0)