Java Cursor.moveToNext方法代码示例

import android.database.Cursor; //导入方法依赖的package包/类
private synchronized String getAlbumArtPicPath(Context context, String albumId) {

        // 小米应用商店检测crash ，错误信息：[31188,0,com.duan.musicoco,13155908,java.lang.IllegalStateException,Unknown URL: content://media/external/audio/albums/null,Parcel.java,1548]
        if (!StringUtils.isReal(albumId)) {
            return null;
        }

        String[] projection = {MediaStore.Audio.Albums.ALBUM_ART};
        String imagePath = null;
        Uri uri = Uri.parse("content://media" + MediaStore.Audio.Albums.EXTERNAL_CONTENT_URI.getPath() + "/" + albumId);

        Cursor cur = context.getContentResolver().query(uri, projection, null, null, null);
        if (cur == null) {
            return null;
        }

        if (cur.getCount() > 0 && cur.getColumnCount() > 0) {
            cur.moveToNext();
            imagePath = cur.getString(0);
        }
        cur.close();


        return imagePath;
    }
 

import android.database.Cursor; //导入方法依赖的package包/类
public String getCalendarIdForName(String calendarName) {
    String selection = "(" + CalendarContract.Calendars.NAME + " = ?)";
    String[] selectionArgs = new String[] {calendarName};
    Cursor cursor = contentResolver.query(CALENDAR_URI, FIELDS, selection, selectionArgs, null);

    try {
        if (cursor.getCount() > 0) {
            while (cursor.moveToNext()) {
                String id = cursor.getString(0);
                return id;
            }
        }
    } catch (AssertionError ex) { /*TODO: log exception and bail*/ }

    return "";
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public ArrayList<DayTask> getAllUndoneTasks(){
    SQLiteDatabase db = this.getReadableDatabase();
    ArrayList<DayTask> tasks = new ArrayList<>();
    String query = "SELECT * FROM " + VARS.TABLE_NAME + " WHERE " + VARS.STATUS + " = 'false'";
    Cursor cursor = db.rawQuery(query, null);
    cursor.moveToFirst();
    while(!cursor.isAfterLast()){
        DayTask dayTask = new DayTask(cursor.getInt(cursor.getColumnIndex(VARS.ID_NAME)), cursor.getString(cursor.getColumnIndex(VARS.STATUS)),
                cursor.getString(cursor.getColumnIndex(VARS.TITLE)), cursor.getString(cursor.getColumnIndex(VARS.DESCRIPTION)),
                cursor.getString(cursor.getColumnIndex(VARS.DATE)), cursor.getString(cursor.getColumnIndex(VARS.TIME)));
        tasks.add(dayTask);
        cursor.moveToNext();
    }
    cursor.close();
    db.close();
    return tasks;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public ArrayList<Deck> getDecks(int courseID){
    ArrayList<Deck> deckList = new ArrayList<Deck>();
    String selectQuery = "SELECT * FROM " + TABLE_DECK_DETAIL + " WHERE " + COURSE_ID + "=" + courseID;
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    cursor.moveToFirst();
    System.out.println("DBHandler courseID in getDecks: " + courseID);
    //loop through all rows to return
    while(!cursor.isAfterLast()){
        Deck deck = new Deck(Integer.parseInt(cursor.getString(0)), courseID,
                cursor.getString(2), Integer.parseInt(cursor.getString(3)));
        deck.set_deckId(courseID);
        deckList.add(deck);

        //Log.i(TAG, "HERE WE ARE CourseID: " + courseID);
        cursor.moveToNext();
    }

    Log.i(TAG, "Return All Deck Names");
    db.close();

    return deckList;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public List<ActivityDataTransfer> listarActividadesSistema(){
    List<ActivityDataTransfer> retList = new ArrayList<>();

    String query = "SELECT * FROM " + TABLA_ACTIVIDADES;
    Cursor c = db.rawQuery(query, null);

    while(c.moveToNext()){
        int id = c.getInt(c.getColumnIndex(KEY_ID));
        String actividad = c.getString(c.getColumnIndex(KEY_ACTIVIDAD));
        Date fCreacion = getDateFromSqlite(c.getString(c.getColumnIndex(KEY_FECHACREACION)));
        String url = c.getString(c.getColumnIndex(KEY_URL_IMAGE));

        ActivityDataTransfer activityDataTransfer = new ActivityDataTransfer(id, actividad, fCreacion, url);
        retList.add(activityDataTransfer);
    }

    return retList;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
@Override
public Cursor loadInBackground() {
    Cursor albums = super.loadInBackground();
    MatrixCursor allAlbum = new MatrixCursor(COLUMNS);
    int totalCount = 0;
    String allAlbumCoverPath = "";
    if (albums != null) {
        while (albums.moveToNext()) {
            totalCount += albums.getInt(albums.getColumnIndex(COLUMN_COUNT));
        }
        if (albums.moveToFirst()) {
            allAlbumCoverPath = albums.getString(albums.getColumnIndex(MediaStore.MediaColumns.DATA));
        }
    }
    allAlbum.addRow(new String[]{Album.ALBUM_ID_ALL, Album.ALBUM_ID_ALL, Album.ALBUM_NAME_ALL, allAlbumCoverPath,
            String.valueOf(totalCount)});

    return new MergeCursor(new Cursor[]{allAlbum, albums});
}
 

import android.database.Cursor; //导入方法依赖的package包/类
private List<T> createObjects(Cursor c) {
	List<T> items = new ArrayList<T>();
	
	while(c.moveToNext()) {
		T object = Model.createObject(mClass, c);
		
		if(object != null) {
			items.add(object);
		}
	}
	
	return items;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
@NonNull
public static ArrayList<PlaylistSong> getPlaylistSongList(@NonNull final Context context, final int playlistId) {
    ArrayList<PlaylistSong> songs = new ArrayList<>();
    Cursor cursor = makePlaylistSongCursor(context, playlistId);

    if (cursor != null && cursor.moveToFirst()) {
        do {
            songs.add(getPlaylistSongFromCursorImpl(cursor, playlistId));
        } while (cursor.moveToNext());
    }
    if (cursor != null) {
        cursor.close();
    }
    return songs;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public SosContacter query(){
    Cursor cursor=db.rawQuery("select * from tb_sos where ischecked=1",null);
    if(cursor.moveToNext()){
        return  new SosContacter(cursor.getInt(cursor.getColumnIndex("_id")),cursor.getString(cursor.getColumnIndex("name")),
                cursor.getString(cursor.getColumnIndex("relation")),cursor.getString(cursor.getColumnIndex("phone")),
                cursor.getString(cursor.getColumnIndex("content")),cursor.getInt(cursor.getColumnIndex("ischecked")));
    }
    return null;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public ArrayList<ContactBean> getGroupMemberLimit(int pageSkip, int maxCount, String table) {

        ArrayList<ContactBean> gbList = new ArrayList<ContactBean>();
        try {
            String selectQuery = "SELECT " + MEMBER_NAME + ", " + MEMBER_PHONE + ", " + MEMBER_SEARCHKEY + ", " + MEMBER_UID + ", " + MEMBER_FLAG + ", " + MEMBER_ORG_NAME + ", "
                    + MEMBER_PH_BOK_NAME + ", " + MEMBER_ISMY_CONTACT + ", " + MEMBER_BLOOD_GROUP + ", " + MEMBER_ADMIN_FLAG + ", " + MEMBER_CREATED_DATE + " FROM " + table + " Order by " + MEMBER_CREATED_DATE + " " + "LIMIT " + pageSkip + ", " + maxCount;

            SQLiteDatabase db = this.getWritableDatabase();
            Cursor cursor = db.rawQuery(selectQuery, null);
            // looping through all rows and adding to list
            if (cursor.moveToFirst()) {
                do {
                    ContactBean contact = new ContactBean();
                    contact.setName(cursor.getString(0));
                    contact.setNumber(cursor.getString(1));
                    contact.setSearchKey(cursor.getString(2));
                    contact.setUID(cursor.getString(3));
                    contact.setRequestFlag(cursor.getString(4));
                    contact.setOrignalName(cursor.getString(5));
                    contact.setMyPhoneBookName(cursor.getString(6));
                    contact.setIsMyContact(cursor.getInt(7));
                    contact.setmBloodGroup(cursor.getString(8));
                    contact.setAdminFlag(cursor.getString(9));
                    contact.setmCreatedDate(cursor.getString(10));
                    gbList.add(contact);
                } while (cursor.moveToNext());
            }
            if (cursor != null)
                cursor.close();
            db.close();
        } catch (Exception e) {
            // TODO: handle exception
            //Log.e("GroupDBErro", "FetchAllDB " + e.getMessage());
            e.printStackTrace();
        }
        return gbList;
    }
 

import android.database.Cursor; //导入方法依赖的package包/类
@SuppressWarnings("No problem")
@Override
public List<DownloadInfo> findAllDownloading() {
  Cursor cursor = readableDatabase.query(DefaultDownloadHelper.TABLE_NAME_DOWNLOAD_INFO,
      DOWNLOAD_INFO_COLUMNS, "status!=?", new String[]{
          String.valueOf(STATUS_COMPLETED)}, null, null, "createAt desc");

  List<DownloadInfo> downloads = new ArrayList<>();
  Cursor downloadCursor;
  while (cursor.moveToNext()) {
    DownloadInfo downloadInfo = new DownloadInfo();
    downloads.add(downloadInfo);

    inflateDownloadInfo(cursor, downloadInfo);

    //query download thread info
    downloadCursor = readableDatabase.query(DefaultDownloadHelper.TABLE_NAME_DOWNLOAD_THREAD_INFO,
        DOWNLOAD_THREAD_INFO_COLUMNS, "downloadInfoId=?", new String[]{
            String.valueOf(downloadInfo.getId())}, null, null, null);
    List<DownloadThreadInfo> downloadThreads = new ArrayList<>();
    while (downloadCursor.moveToNext()) {
      DownloadThreadInfo downloadThreadInfo = new DownloadThreadInfo();
      downloadThreads.add(downloadThreadInfo);
      inflateDownloadThreadInfo(downloadCursor, downloadThreadInfo);
    }

    downloadInfo.setDownloadThreadInfos(downloadThreads);

  }
  return downloads;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
@Test
public void log_queue_over_logLevel() throws InterruptedException {
  historian.initialize();

  historian.log(Log.INFO, TAG, "this is info1");
  historian.log(Log.DEBUG, TAG, "this is debug1");
  historian.log(Log.INFO, TAG, "this is info2");
  historian.log(Log.WARN, TAG, "this is warn1");
  historian.log(Log.ERROR, TAG, "this is error1");

  Thread.sleep(500);

  Cursor cursor = getAllLogs(historian);

  assertEquals(4, cursor.getCount());

  cursor.moveToFirst();
  assertEquals("INFO", Cursors.getString(cursor, "priority"));
  assertEquals(TAG, Cursors.getString(cursor, "tag"));
  assertEquals("this is info1", Cursors.getString(cursor, "message"));

  cursor.moveToNext();
  assertEquals("INFO", Cursors.getString(cursor, "priority"));
  assertEquals(TAG, Cursors.getString(cursor, "tag"));
  assertEquals("this is info2", Cursors.getString(cursor, "message"));

  cursor.moveToNext();
  assertEquals("WARN", Cursors.getString(cursor, "priority"));
  assertEquals(TAG, Cursors.getString(cursor, "tag"));
  assertEquals("this is warn1", Cursors.getString(cursor, "message"));

  cursor.moveToNext();
  assertEquals("ERROR", Cursors.getString(cursor, "priority"));
  assertEquals(TAG, Cursors.getString(cursor, "tag"));
  assertEquals("this is error1", Cursors.getString(cursor, "message"));

  cursor.close();
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public static List<Artist> getAllArtists() {
    List<Artist> artistList = new ArrayList<>();
    Cursor cursor = makeArtistCursor(MusicApplication.getContext());
    // Gather the data
    if (cursor != null && cursor.moveToFirst()) {
        do {
            // Copy the artist id
            final long id = cursor.getLong(0);

            // Copy the artist name
            final String artistName = cursor.getString(1);

            // Copy the number of albums
            final int albumCount = cursor.getInt(2);

            // Copy the number of songs
            final int songCount = cursor.getInt(3);

            // as per designer's request, don't show unknown artist
            if (MediaStore.UNKNOWN_STRING.equals(artistName)) {
                continue;
            }

            // Create a new artist
            final Artist artist = new Artist(id, artistName, songCount, albumCount);
            artistList.add(artist);
        } while (cursor.moveToNext());
    }
    // Close the cursor
    if (cursor != null) {
        cursor.close();
        cursor = null;
    }
    return artistList;
}
 

import android.database.Cursor; //导入方法依赖的package包/类
private static void exportSingleIndex(SQLiteDatabase db, String tableName, BufferedWriter writer) throws IOException {
    String sql = "SELECT sql FROM sqlite_master WHERE type = 'index' AND tbl_name='" + tableName + "'";
    Cursor cursor = db.rawQuery(sql, null);
    if (cursor == null) return;

    while (cursor.moveToNext()) {
        if (cursor.getString(0) == null)
            continue;

        writer.write(cursor.getString(0) + ";" + NL + NL);
    }
    cursor.close();
}
 

import android.database.Cursor; //导入方法依赖的package包/类
public List<RecordDetailsModel> getAllRecordDetails() {
    final List<RecordDetailsModel> listRecordDetails = new ArrayList<>();

    final Cursor cursor = getDatabase().query(DataBaseHelper.TABLE_RECORDS_DETAILS,
            allColumns, null, null, null, null, null);

    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
        RecordDetailsModel recordDetailsModel = cursorToRecordDetails(cursor);
        listRecordDetails.add(recordDetailsModel);
        cursor.moveToNext();
    }
    cursor.close();
    return listRecordDetails;
}