Example #1
0
        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;
          }
        }
Example #2
0
 public ContentValues toContentValues() {
   ContentValues cv = new ContentValues();
   cv.put(Table.COLUMN_FILENAME, getFilename());
   if (getLocalUri() != null) {
     cv.put(Table.COLUMN_LOCAL_URI, getLocalUri().toString());
   }
   if (getImageUrl() != null) {
     cv.put(Table.COLUMN_IMAGE_URL, getImageUrl().toString());
   }
   if (getDateUploaded() != null) {
     cv.put(Table.COLUMN_UPLOADED, getDateUploaded().getTime());
   }
   cv.put(Table.COLUMN_LENGTH, getDataLength());
   cv.put(Table.COLUMN_TIMESTAMP, getTimestamp().getTime());
   cv.put(Table.COLUMN_STATE, getState());
   cv.put(Table.COLUMN_TRANSFERRED, transferred);
   cv.put(Table.COLUMN_SOURCE, source);
   cv.put(Table.COLUMN_DESCRIPTION, description);
   cv.put(Table.COLUMN_CREATOR, creator);
   cv.put(Table.COLUMN_MULTIPLE, isMultiple ? 1 : 0);
   return cv;
 }