2,209
社区成员
发帖
与我相关
我的任务
分享
SQLiteDatabase db = null;
Cursor cursor = null;
try {
db = patrolDBHelper.getReadableDatabase();
// 获取当前taskcode的base64编码的图片
// cursor = db.rawQuery("select photoBase64Code from patrolphotos where taskCode=?", new String[]{taskCode});
cursor = db.query(patrolDBHelper.TABLE_NAME_PHOTO, TABLE_NAME_PHOTO, "taskCode=?", new String[]{taskCode}, null, null, null);
if (cursor.getCount() > 0) {
ArrayList<String> images = new ArrayList<>(cursor.getCount());
Log.e("图片的hang数222222222222222", cursor.getCount() + "");
while (cursor.moveToNext()) {
images.add(cursor.getString(cursor.getColumnIndex("photoBase64Code")));
}
return images;
}
} catch (Exception e) {
Log.e(TAG, "", e);
} finally {
if (cursor != null) {
cursor.close();
}
if (db != null) {
db.close();
}
}
return null;