@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
String filePickerResult = "";
if (data != null && resultCode == RESULT_OK) {
try {
ContentResolver cr = getContentResolver();
Uri uri = data.getData();
Cursor cursor =
GeckoApp.mAppContext
.getContentResolver()
.query(uri, new String[] {OpenableColumns.DISPLAY_NAME}, null, null, null);
String name = null;
if (cursor != null) {
try {
if (cursor.moveToNext()) {
name = cursor.getString(0);
}
} finally {
cursor.close();
}
}
String fileName = "tmp_";
String fileExt = null;
int period;
if (name == null || (period = name.lastIndexOf('.')) == -1) {
String mimeType = cr.getType(uri);
fileExt = "." + GeckoAppShell.getExtensionFromMimeType(mimeType);
} else {
fileExt = name.substring(period);
fileName = name.substring(0, period);
}
File file = File.createTempFile(fileName, fileExt, sGREDir);
FileOutputStream fos = new FileOutputStream(file);
InputStream is = cr.openInputStream(uri);
byte[] buf = new byte[4096];
int len = is.read(buf);
while (len != -1) {
fos.write(buf, 0, len);
len = is.read(buf);
}
fos.close();
filePickerResult = file.getAbsolutePath();
} catch (Exception e) {
Log.e(LOG_FILE_NAME, "showing file picker", e);
}
}
try {
mFilePickerResult.put(filePickerResult);
} catch (InterruptedException e) {
Log.i(LOG_FILE_NAME, "error returning file picker result", e);
}
}
public void onClick(View v) {
ContentResolver cr = getContentResolver();
switch (v.getId()) {
// 전부 읽기
case R.id.readall:
Cursor cursor = cr.query(Uri.parse(WORDURI), null, null, null, null);
String Result = "";
while (cursor.moveToNext()) {
String eng = cursor.getString(0);
String han = cursor.getString(1);
Result += (eng + " = " + han + "\n");
}
if (Result.length() == 0) {
mText.setText("Empyt Set");
} else {
mText.setText(Result);
}
cursor.close();
break;
// 하나만 읽기
case R.id.readone:
Cursor cursor2 = cr.query(Uri.parse(WORDURI + "/boy"), null, null, null, null);
String Result2 = "";
if (cursor2.moveToFirst()) {
String eng = cursor2.getString(0);
String han = cursor2.getString(1);
Result2 += (eng + " = " + han + "\n");
}
if (Result2.length() == 0) {
mText.setText("Empyt Set");
} else {
mText.setText(Result2);
}
cursor2.close();
break;
// 삽입
case R.id.insert:
ContentValues row = new ContentValues();
row.put("eng", "school");
row.put("han", "학교");
cr.insert(Uri.parse(WORDURI), row);
mText.setText("Insert Success");
break;
// 삭제
case R.id.delete:
cr.delete(Uri.parse(WORDURI), null, null);
mText.setText("Delete Success");
break;
// 수정
case R.id.update:
ContentValues row2 = new ContentValues();
row2.put("han", "핵교");
cr.update(Uri.parse(WORDURI + "/school"), row2, null, null);
mText.setText("Update Success");
break;
}
}