get Float List by database Query - Android Database

Description

get Float 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<Float> getFloatListbyDBQuery(SQLiteDatabase db,
            String sql, String fieldName) {
        Cursor cursor = db.rawQuery(sql, null);
        int index = cursor.getColumnIndex(fieldName);
        ArrayList<Float> retList = new ArrayList<Float>();

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

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

        return retList;
    }
}

• Previous
• Next

Related Tutorials

• Reads a Long out of a field in a Cursor and writes it to a Map.
• Read the entire contents of a cursor row and store them in a ContentValues.
• Reads a String out of a field in a Cursor and writes it to a Map.
• get Integer List by database Query
• get String List by database Query