public void resolve() {
ContentResolver resolver = getContentResolver();
Uri uri = Uri.parse("content://com.android.contacts/raw_contacts");
Uri dataUri = Uri.parse("content://com.android.contacts/data");
Cursor cursor = resolver.query(uri, null, null, null, null);
while (cursor.moveToNext()) {
String id = cursor.getString(cursor.getColumnIndex("contact_id"));
Cursor cursor1 = resolver.query(dataUri, null, "raw_contact_id=?", new String[] {id}, null);
while (cursor1.moveToNext()) {
String data = cursor1.getString(cursor1.getColumnIndex("data1"));
String mimetype = cursor1.getString(cursor1.getColumnIndex("mimetype"));
String name = cursor1.getString(cursor1.getColumnIndex("display_name"));
if (mimetype.equals("vnd.android.cursor.item/phone_v2")) {
data = data.replace(" ", "");
phoneNumber.add(data);
getImage(data);
phoneNumberToId.put(data, id);
nameList.add(name);
}
}
cursor1.close();
}
cursor.close();
}
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;
}
}