Android อยากทราบวิธีการ insert image ลงฐานข้อมูล SQLite แล้วดึง path image จากหน้า gallery เพื่่อให้มาแสดงบน imageViewในหน้า profile ค่ะ

// Insert Account
public long InsertAccount(String ACCName, long InitialMoney,
String StartDate, String EndDate, String Photo) {
try {
SQLiteDatabase db;
db = this.getWritableDatabase();
ContentValues Val = new ContentValues();
Val.put("ACCName", ACCName);
Val.put("InitialMoney", InitialMoney);
//Val.put("ACCPicture", Photo);
Val.put("StartDate", StartDate);
Val.put("EndDate", EndDate);
long rows = db.insert(TABLE_ACCOUNT, null, Val);
db.close();
return rows;
} catch (Exception e) {
return -1;
}
}
อันนี้หนูเขียนเลือกภาพจาก หน้า gallery
imageView1 = (ImageView)findViewById(R.id.imageView1);
Button button1 = (Button)findViewById(R.id.button1);
button1.setOnClickListener(new OnClickListener() {
public void onClick(View v) {
imageView1.setImageBitmap(null);
if (image != null)
image.recycle();
Intent intent = new Intent();
intent.setType("image/*");
intent.setAction(Intent.ACTION_GET_CONTENT);
startActivityForResult(Intent.createChooser(intent, "Select Picture"), REQUEST_GALLERY);
}
});
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
if (requestCode == REQUEST_GALLERY && resultCode != 0) {
Uri mImageUri = data.getData(); 
try {
image = Media.getBitmap(this.getContentResolver(), mImageUri);
imageView1.setImageBitmap(image); 
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
ส่วนอันนี้เป็นปุ่มที่กด save ลง database
// Save Account
public boolean SaveData() {
final EditText AccName = (EditText) findViewById(R.id.NameEdit);
final EditText AccMoney = (EditText) findViewById(R.id.MoneyEdit);
final Button StartDate = (Button) findViewById(R.id.btnStartDate);
final Button EndDate = (Button) findViewById(R.id.btnEndDate);
final ImageView img = (ImageView) findViewById(R.id.imageView1);
final AlertDialog.Builder adb = new AlertDialog.Builder(this);
AlertDialog ad = adb.create();
if (AccName.getText().length() == 0) {
ad.setMessage("Please input Account name ");
ad.show();
AccName.requestFocus();
return false;
}
if (AccMoney.getText().length() == 0) {
ad.setMessage("Please input Initial money ");
ad.show();
AccMoney.requestFocus();
return false;
}
final myDBClass mDb = new myDBClass(this);
long saveStatus = mDb.InsertAccount(AccName.getText().toString(),
Integer.parseInt(AccMoney.getText().toString()), StartDate
.getText().toString(), EndDate.getText().toString(), null);
if (saveStatus <= 0) {
ad.setMessage("Error!! ");
ad.show();
return false;
}
Toast.makeText(NewAccount.this, "Add Account Successfully. ",
Toast.LENGTH_SHORT).show();
return true;
}