{"id":1450,"date":"2016-02-24T13:12:14","date_gmt":"2016-02-24T13:12:14","guid":{"rendered":"http:\/\/www.mplx.de\/Fremdgesteuert\/?p=1450"},"modified":"2019-09-04T04:43:08","modified_gmt":"2019-09-04T04:43:08","slug":"databases-in-android-apps","status":"publish","type":"post","link":"http:\/\/www.mplx.de\/Fremdgesteuert\/2016\/02\/24\/databases-in-android-apps\/","title":{"rendered":"Databases in Android Apps"},"content":{"rendered":"
\"Mobile<\/a>

Mobile form containing data from database<\/p><\/div>\n

After the description of all the Layout issues, I had to struggle with while developing my first Android App ‘Fitness Manager’, this time I want to write about databases in Android Apps. The Layout of the ‘Fitness Manager’ App had to be filled with data, statistics and life.<\/p>\n

The integration of a database in Android Apps is very simple and easy. The developer just needs to implement a Java subclass that overwrites the functions onCreate<\/i> and onUpgrade<\/i> of the SQLiteOpenHelper<\/i> API. In order to access the subclass an object of the subclass has to be instantiated.<\/p>\n

\"Java<\/a>

Java subclass extending SQLiteOpenHelper<\/p><\/div>\n

Finished \ud83d\ude42<\/p>\n

No but almost. Now tables have to be created, deleted and filled with values. Many database operations can be handled in different ways with SQLiteOpenHelper<\/i>.<\/p>\n

    \n
  1. \n

    Create a table by just executing a SQL command.<\/p>\n

    \"SQL<\/a>

    SQL command: Create table<\/p><\/div><\/li>\n<\/ol>\n

      \n
    1. \n

      Delete a table by just executing a SQL command.<\/p>\n

      \"SQL<\/a>

      SQL command: Delete table<\/p><\/div><\/li>\n<\/ol>\n

        \n
      1. \n

        Insert an entry into a table by just executing a SQL command.<\/p>\n

        \"SQL<\/a>

        SQL command: Insert table entry<\/p><\/div>\n

        Insert an entry into a table by using SQLiteOpenHelper<\/i> API. The function getWriteableDatabase<\/i> has to be called in the beginning of the operation when putting entries into databases.<\/p>\n

        \"SQLiteOpenHelper:<\/a>

        SQLiteOpenHelper: Insert table entry<\/p><\/div><\/li>\n<\/ol>\n

          \n
        1. \n

          Updating an entry of a table by using SQLiteOpenHelper<\/i> API. The function getWriteableDatabase<\/i> has to be called in the beginning of the operation when putting updating entries of databases.<\/p>\n

          \"SQL<\/a>

          SQL command: Update table entry<\/p><\/div><\/li>\n<\/ol>\n

            \n
          1. \n

            Delete an entry from a table by just executing a SQL command.<\/p>\n

            \"SQL<\/a>

            SQL command: Delete table entry<\/p><\/div><\/li>\n<\/ol>\n

              \n
            1. \n

              Selecting a single row entry from a table of the database by using SQLiteOpenHelper<\/i>. The function getReadableDatabase<\/i> has to be called in the beginning of the operation when selecting entries from databases.<\/p>\n

              \"SQL<\/a>

              SQL command: Select single row entry from table<\/p><\/div><\/li>\n<\/ol>\n

                \n
              1. \n

                Selecting multiple row entries from a table of the database by using SQLiteOpenHelper<\/i>. The function getReadableDatabase<\/i> has to be called in the beginning of the operation when selecting entries from databases.<\/p>\n

                \"SQL<\/a>

                SQL command: Select multiple row entries from table<\/p><\/div><\/li>\n<\/ol>\n

                These are the most convenient operations and functions for implementing databases for Android App devices.<\/p>\n

                In order to receive the data of the database in a virtual Android device of Android Studio, the AVD Manager can be used. The AVD Manager can be found within Tools \u2013 Android \u2013 AVD Manager or you just click the corresponding ImageButton in the Toolbar of Android Studio.<\/p>\n

                \"AVD-Manager<\/a>

                AVD-Manager in Android Studio Toolbar<\/p><\/div>\n

                Within the AVD Manager the developer has to switch to the File Explorer tab. After selecting the virtual device in AVD Manager, the database can be found in data\/data\/<package_name>\/databases\/<db_name>.db. The database file can be pulled from virtual device by using the small ImageButton in the right top corner of the AVD Manager.<\/p>\n

                \"AVD-Manager<\/a>

                AVD-Manager FileExplorer<\/p><\/div>\n

                In order to receive the data of the database in a real device, the ADB Terminal has to be used. The data of a real device is not accessable with the AVD Manager of the Android Studio. The ADB can be found in the folder \/Android\/sdk\/platforms-tools. Most often this directory is located in the user directory. A terminal must be opened at this directory and the PULL command is executed for ADB.<\/p>\n

                \"ADB-Terminal\"<\/a>

                ADB-Terminal<\/p><\/div>\n

                The data of the database can be verified using the SQLiteManager of Firefox. This tool can be found within Firefox \u2013 Extras.<\/p>\n

                That’s it. Sweet.<\/p>\n

                If you have any questions, any improvement suggestions for the implementation (I mentioned that this is my first Android App) or any improvement suggestions for my English, I really would appreciate if you can leave me a comment.<\/p>\n

                And I would even more appreciate if you like to check out the ‘Fitness Manager’ App in the Google Play Store<\/a> or the ‘Fitness Manager’ App in the iTunes Store<\/a>. See you.<\/p>\n

                Follow us on<\/p>\n

                Facebook<\/a>
                \n                Twitter<\/a>
                \n                Google Plus<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

                After the description of all the Layout issues, I had to struggle with while developing my first Android App ‘Fitness Manager’, this time I want to write about databases in Android Apps. The Layout of the ‘Fitness Manager’ App had to be filled with data, statistics and life. The integration of a database in Android […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[392],"tags":[394,436,435,431,433,434,432,395,404,393,405],"class_list":["post-1450","post","type-post","status-publish","format-standard","hentry","category-android-app-development","tag-android","tag-android-adb-terminal","tag-android-avd-manager","tag-android-database","tag-android-sql","tag-android-sqlite","tag-android-sqliteopenhelper","tag-android-studio","tag-app","tag-fitness-manager","tag-java"],"_links":{"self":[{"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/posts\/1450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/comments?post=1450"}],"version-history":[{"count":8,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/posts\/1450\/revisions"}],"predecessor-version":[{"id":1518,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/posts\/1450\/revisions\/1518"}],"wp:attachment":[{"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/media?parent=1450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/categories?post=1450"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mplx.de\/Fremdgesteuert\/wp-json\/wp\/v2\/tags?post=1450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}