问题描述
我对如何做到这一点感到困惑..
I am confused about how to do this..
对于我使用的数据库:
public void insertImage(byte[] bytes) {
ContentValues cv = new ContentValues();
cv.put("imageblob", bytes);
Log.e("inserted", "inserted");
dbHelper.getWritableDatabase().insert("Image", "imageblob", cv);
}
public byte[] getImage(Cursor c) {
return (c.getBlob(1));
}
数据库助手:
...
public static final String KEY_COMMENTS = "comments";
public static final String KEY_IMAGE = "imageblob";
private static final String SCRIPT_CREATE_DATABASE = "create table "
+ DATABASE_TABLE + " (" + KEY_ROWID
+ " integer primary key autoincrement, " + KEY_TITLE
+ " text not null, ......+KEY_COMMENTS+" text not null,"+KEY_IMAGE+" imageblob BLOB);";
我的物品:
public class myItems {
....
String comments;
byte[] imageblob;
public byte[] getImage() {
return imageblob;
}
public void setImage(byte[] imageblob) {
this.imageblob = imageblob;
}
现在，我在 MainActivity 中有了列表视图.从另一个活动 ShowList 中，我有一个用于拍照的按钮:
Now, I have the listview in MainActivity.From another activity,ShowList, I have a button with which to take the photo:
case R.id.photobtn:
Intent cameraIntent = new Intent(android.provider.MediaStore.ACTION_IMAGE_CAPTURE);
startActivityForResult(cameraIntent, CAMERA_REQUEST);
break;
在 onActivityResult 中:
In onActivityResult :
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
if(resultCode == CAMERA_REQUEST){
Bitmap photo = (Bitmap) data.getExtras().get("data");
imageView.setImageBitmap(photo);
ByteArrayOutputStream stream = new ByteArrayOutputStream();
photo.compress(Bitmap.CompressFormat.PNG, 100, stream);
byte[] byteArray = stream.toByteArray();
sqlHandler.insertImage(byteArray);
}
我的适配器:
公共类 myAdapter 扩展 BaseAdapter{
public class myAdapter extends BaseAdapter{
...
public myAdapter(Context context, ArrayList<myItems> list) {
this.context = context;
this.setItems(list);
}
@Override
public View getView(int position, View convertView, ViewGroup arg2) {
myItems theItems = getItems().get(position);
if (convertView == null) {
LayoutInflater inflater = (LayoutInflater) context
.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
convertView = inflater.inflate(R.layout.showadapterlist, null);
}
...
TextView Comments = (TextView) convertView.findViewById(R.id.text_comments);
Comments.setText(theItems.getComments());
ImageView myImage=(ImageView) convertView.findViewById(R.id.myimage);
myImage.setImageBitmap(getImageFromBLOB(theItems.getImage()));
return convertView;
}
public static Bitmap getImageFromBLOB(byte[] mBlob)
{
byte[] bb = mBlob;
return BitmapFactory.decodeByteArray(bb, 0, bb.length);
}
public ArrayList<myItems> getItems() {
return items;
}
public void setItems(ArrayList<myItems> items) {
this.items = items;
}
我的问题:
1) 列表视图位于 MainActivity 中.照片取自 ShowList 活动.在 ShowList 活动中，我有:
1) The listview lies in MainActivity.The photo is taken from ShowList activity.In ShowList activity I have:
case R.id.OKbtn:
String mycomments = comments.getText().toString();
byte[] myimageblob=null;
String query = "INSERT INTO MEMOR(title,...comments,imageblob)" +
" values (..+ mytitle + "....+mycomments + "','" +myimageblob+ "')" sqlHandler.executeQuery(query);
Intent k=new Intent(this,MainActivity.class);
setResult(RESULT_OK,k);
finish();
我应该如何处理imageblob"值?
How should I handle the "imageblob" value?
2) 在 MainActivity(列表视图所在的位置)我有:
2) In MainActivity (where the list view is) I have:
...
myItems theItems = new myItems();
theItems.setID(c1.getString(c1.getColumnIndex("_id")));
theItems.setTitle(c1.getString(c1.getColumnIndex("title")));
...
theItems.setComments(c1.getString(c1.getColumnIndex("comments")));
byte[] blob=c1.getBlob(c1.getColumnIndex("imageblob"));
ByteArrayInputStream inputStream = new ByteArrayInputStream(blob);
Bitmap bitmap = BitmapFactory.decodeStream(inputStream);
myList.add(theItems);
我应该如何处理 imageblob?
How should I handle the imageblob?
现在，当我启动我的应用程序时，在第
Right now , when I start my application is crashes with "IllegalStateException" at line
" byte[] blob=c1.getBlob(c1.getColumnIndex("imageblob"));"
.如果我尝试 c1.setImage 它不起作用.
. If I try c1.setImage it doesn't work.
-----------新的-------------------------------------------在一项活动中:
------------------NEW--------------------------------------------------In one activity:
case R.id.photobtn:
Intent cameraIntent = new Intent(android.provider.MediaStore.ACTION_IMAGE_CAPTURE);
startActivityForResult(cameraIntent, CAMERA_REQUEST);
break;
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);
if(requestCode == CAMERA_REQUEST){
if (resultCode==RESULT_OK){
Bitmap photo = (Bitmap) data.getExtras().get("data");
imageView.setImageBitmap(photo);
ByteArrayOutputStream stream = new ByteArrayOutputStream();
photo.compress(Bitmap.CompressFormat.PNG, 100, stream);
blobvalue = stream.toByteArray();
Bundle extras = new Bundle();
Intent k=new Intent(this,MainActivity.class);
extras.putParcelable("Bitmap", photo);
k.putExtras(extras);
}
}
if (resultCode == RESULT_CANCELED) {
}
}
在适配器中:
public View getView(int position, View convertView, ViewGroup arg2) {
myItems theItems = getItems().get(position);
if (convertView == null) {
LayoutInflater inflater = (LayoutInflater) context
.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
convertView = inflater.inflate(R.layout.showadapterlist, null);
}
ImageView myImage=(ImageView) convertView.findViewById(R.id.myimage);
final Bitmap image;
if(theItems.getImagemyItems() != null)
{
byte []temp = theItems.getImagemyItems();
image = BitmapFactory.decodeByteArray(temp, 0, temp.length);
myImage.setImageBitmap(image);
}
else
{
image = BitmapFactory.decodeResource(context.getResources(), R.drawable.ic_launcher);
myImage.setImageBitmap(image);
}
在我的项目中:
public class myItems {
String id;
...
byte[] imageblob;
public String getID() {
return id;
}
....
}
推荐答案
As per you create database statement
As per you create database statement
private static final String SCRIPT_CREATE_DATABASE = "create table "
+ DATABASE_TABLE + " (" + KEY_ROWID
+ " integer primary key autoincrement, " + KEY_TITLE
+ " text not null, ......+KEY_COMMENTS+" text not null,"+KEY_IMAGE+" imageblob BLOB);";
你被提及
"+KEY_IMAGE+" imageblob BLOB
所以列值是imageblob imagebol BLOB"语法明智它不是一个正确的sql语句.所以只需从那里删除imageblob"并尝试，它可能会解决您的问题......
so the column value is "imageblob imageblol BLOB" syntax wise it is not a correct sql statement.so just remove the "imageblob" from there and try that, it may be solve your problem....
这篇关于如何保存从相机拍摄的图像并将其显示到列表视图 - 因“IllegalStateException"而崩溃；的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！