String sql = "select * from user;"
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.rawQuery(sql, null);
while(cursor.moveToNext()){
User user = new User();
user.setName(cursor.getString(cursor.getColumnIndex("name")));
user.setPassword(cursor.getString(cursor.getColumnIndex("password")));
list.add(user);
}
4.2.条件查询
String sql = "select * from user where _ID=?";
String[] selectionArgs = {String.valueOf(id)};
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.rawQuery(sql,selectionArgs);
User user = new User();
while(cursor.moveToNext()){
user.setName(cursor.getString(cursor.getColumnIndex("name")));
user.setPassword(cursor.getString(cursor.getColumnIndex("password")));
}