// metodo para insertar a la tabla
private void insertPrso(String nombre, String ciudad) {
DataBaseHelper databasehelper = new DataBaseHelper(this);
SQLiteDatabase db = databasehelper.getWritableDatabase();
if (db != null) {
ContentValues cv = new ContentValues();
cv.put(DataBaseHelper.NOMBRE, nombre);
cv.put(DataBaseHelper.CIUDAD, ciudad);
db.insert("tabla", DataBaseHelper.NOMBRE, cv);
db.close();
}
}
private void updatePhoto(Long rawContactId, byte[] photo) {
ContentValues values = new ContentValues();
values.put(ContactsContract.Contacts.Photo.PHOTO, photo);
String selection =
ContactsContract.RawContacts.Data.RAW_CONTACT_ID
+ "=? and "
+ ContactsContract.RawContacts.Data.MIMETYPE
+ "=?";
String[] selectionArgs =
new String[] {
Long.toString(rawContactId), ContactsContract.CommonDataKinds.Photo.CONTENT_ITEM_TYPE
};
getContentResolver()
.update(ContactsContract.Data.CONTENT_URI, values, selection, selectionArgs);
}
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;
}
}
