Execute raw query via SQLiteDatabase - Android Database

Description

Execute raw query via SQLiteDatabase

Demo Code

//package com.java2s;

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

public class Main {
    public static Cursor all(SQLiteDatabase db, String name) {
        return db.rawQuery("SELECT id, data FROM " + name + ";", null);
    }/*ww w . ja va 2  s.  c o m*/
}

• Previous
• Next

Related Tutorials

• Check if a table row exist
• Execute SQL Statement using SQLiteDatabase
• Execute select statement via SQLiteDatabase and return a cursor
• Get table row count from SQLiteDatabase
• test SQL query on SQLServer database