get String List by database Query - Android Database

Android examples for Database:Cursor Get

  1. HOME
  2. Android
  3. Database
  4. Cursor Get

Description

get String List by database Query

Demo Code


//package com.java2s;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;

public class Main {
    public static ArrayList<String> getStringListbyDBQuery(
            SQLiteDatabase db, String sql, String fieldName) {
        Cursor cursor = db.rawQuery(sql, null);
        int index = cursor.getColumnIndex(fieldName);
        ArrayList<String> retList = new ArrayList<String>();

        cursor.moveToFirst();//from w ww.j  a v  a2 s. com

        while (!cursor.isAfterLast()) {
            retList.add(cursor.getString(index));
            cursor.moveToNext();
        }

        return retList;
    }
}

Related Tutorials