开发者

Android SQLite query is always empty

开发者 https://www.devze.com 2023-02-19 22:59 出处:网络
So right now I\'m using this solution in my app Ship an application with a database In my main activity, I just want to test to make sure that the database is working, so all I\'m doing it a simply q

So right now I'm using this solution in my app Ship an application with a database

In my main activity, I just want to test to make sure that the database is working, so all I'm doing it a simply query to get some names, all I did was add 3 lines(commented where I added them):

       DatabaseHelper myDbHelper;
       SQLiteDatabase myDb = null;

       myDbHelper = new DatabaseHelper(this);
       /*
        * Database must be initialized before it can be used. This will ensure
        * that the database exists and is the current version.
        */
        myDbHelper.initializeDataBase();
       开发者_如何学C Cursor c;
        String s = null;
        try {
           // A reference to the database can be obtained after initialization.
           myDb = myDbHelper.getWritableDatabase();
//the next 3 lines are all I added
           c = myDb.rawQuery("select name from breads", null);
           s = c.getString(1);
           c.close();
           /*
            * Place code to use database here.
            */
        } catch (Exception ex) {
           ex.printStackTrace();
        } finally {
           try {
               myDbHelper.close();
           } catch (Exception ex) {
               ex.printStackTrace();
           } finally {
               myDb.close();
           }
       }

However, s just remains empty. If I do the exact same query select name from breads in the console, I will get data. Does anyone have any ideas?


myDb = myDbHelper.getWritableDatabase();
//the next 3 lines are all I added
c = myDb.rawQuery("select name from breads", null);
c.moveToFirst(); // ADD THIS
s = c.getString(1);
c.close();
0

精彩评论

暂无评论...
验证码 换一张
取 消