android操作sqlite3的blob字段,显示数据中的图片
SQLiteDatabase database = SQLiteDatabase
.openOrCreateDatabase(getFileStreamPath(fileName)
.getAbsolutePath(), null);
Cursor cursor = database.rawQuery(
"select name,image from users", new String[] {});
if (cursor.moveToFirst()) {
userName = cursor.getString(0);
ByteArrayInputStream stream = new ByteArrayInputStream(
cursor.getBlob(1));
image = Drawable.createFromStream(stream, "image");
Log.i(TAG, "user name: " + userName);
}
database.close();
声明的成员变量,供上面代码使用的:
private String userName;
private Drawable image;
在对话框里面显示:
AlertDialog.Builder builder = new Builder(
WelComeMainActivity.this);
builder.setMessage("数据更新完毕。用户名:" + userName);
builder.setTitle("提示");
builder.setIcon(image);
builder.setPositiveButton("确认", new OnClickListener() {
@Override
public void onClick(DialogInterface dialog,
int which) {
dialog.dismiss();
}
});
builder.create().show();
更多相关文章
- 一个日期选择对话框
- android 普通对话框
- Android中共享全局变量
- android各种对话框总结笔记
- React-Native 调用原生方法,弹出自定义对话框
- Android studio安装之前配置环境变量
- Android SDK的安装与环境变量配置
- Android建立对话框基本的几种方法