Example usage for com.badlogic.gdx.sql SQLiteGdxDatabase rawQuery

Introduction

In this page you can find the example usage for com.badlogic.gdx.sql SQLiteGdxDatabase rawQuery.

Prototype

public SQLiteGdxDatabaseCursor rawQuery(String sql, String[] args) throws SQLiteGdxException;

Source Link

Document

Runs the provided SQL and returns a SQLiteGdxDatabaseCursor over the result set.

Usage

From source file:de.longri.cachebox3.sqlite.Database.java

License:Open Source License

public static int getCacheCountInDB(String absolutePath) {
    try {//w  w  w. j a  va  2s  . co m
        SQLiteGdxDatabase tempDB = SQLiteGdxDatabaseFactory.getNewDatabase(Gdx.files.absolute(absolutePath));
        tempDB.openOrCreateDatabase();
        SQLiteGdxDatabaseCursor result = tempDB.rawQuery("SELECT COUNT(*) FROM caches", null);
        result.moveToFirst();
        int count = result.getInt(1);
        result.close();
        tempDB.closeDatabase();
        return count;
    } catch (Exception exc) {
        return -1;
    }
}

---