private void showImg() {
dbHandler = new DBHandler(this);
Intent intent = getIntent();
code = intent.getStringExtra("code");
try{
// String sql1 = "select ncimg from members where "+ code;
// Cursor cursor = db.rawQuery("select code from members", null);
cursor = dbHandler.selectNC();
cursor.moveToLast();
byte[] image = cursor.getBlob(cursor.getColumnIndex("ncimg"));
// Bitmap bm = BitmapFactory.decodeByteArray(image, 0, image.length);
ImageView blobImg = (ImageView) findViewById(R.id.dbImg);
blobImg.setImageBitmap(BitmapFactory.decodeByteArray(image, 0, image.length));
cursor.close();
}catch (Exception e){
e.printStackTrace();
}
}
public Cursor selectNC() {
Cursor cursor = db.rawQuery("select ncimg from members where code =?", null);
return cursor;
}
blob타입으로 이미지를 넣고 select로 보려고 하는데, 보여주려는 부분에서 byte로 변환을 해주는 부분에서 에러가 뜨긴하는데 변환이 안되는건지 데이터를 못불러오는건지... 잘 모르겠습니다.
09-09 11:22:52.039 13189-13189/org.androidtown.lbs.map W/System.err﹕ android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 0
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.database.AbstractCursor.checkPosition(AbstractCursor.java:426)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.database.AbstractWindowedCursor.getBlob(AbstractWindowedCursor.java:44)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at org.androidtown.lbs.map.MypageModify.showImg(MypageModify.java:178)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at org.androidtown.lbs.map.MypageModify.onCreate(MypageModify.java:83)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.Activity.performCreate(Activity.java:6289)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1119)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2665)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2779)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.ActivityThread.access$900(ActivityThread.java:179)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1462)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.os.Handler.dispatchMessage(Handler.java:102)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.os.Looper.loop(Looper.java:145)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at android.app.ActivityThread.main(ActivityThread.java:5974)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at java.lang.reflect.Method.invoke(Native Method)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at java.lang.reflect.Method.invoke(Method.java:372)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1388)
09-09 11:22:52.044 13189-13189/org.androidtown.lbs.map W/System.err﹕ at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1183)
showImg를 onCreate안에 넣어서 Activitity가 실행되면서 동시에 db에서 이미지를 불러오게 하고 싶은데 잘 안되네요ㅠㅠ 도와주세요